Search results for query: *

Is there a users guide to MQ series online somewhere? TIA

Is the following IF FIELD-1 NOT = 'AB' AND 'CD' the same as IF FIELD-1 NOT = 'AB' AND NOT = 'CD'

Can I use a symoblic in a LABEL?? Such as - LABEL&NUM DD DSN=FILE.NAME The above example is giving me 'INVALID LABEL' error message. Just wondering if this can be accomplished.

Can someone tell me what PD6.2 equates to in terms of a COBOL PIC definition? Also, is there a website that is a beginners guide to SAS? Thanks!

SELECT COUNT(*) FROM TABLE1 B, TABLE2 A WHERE B.FIELD1 = 44441 AND B.FIELD2 = A.FIELD2 GROUP BY A.FIELD3 This query is pulling back the following info currently - 12 27 46 1 2 1 2...

What is the best command to get all VOLSERs associated with a dataset?

Our DB2 tables were moved from 1 region to another. I did make a change to my pgm but did not touch the cursor that is causing the following error. Why am I getting this all of a sudden? SQLCODE = -181, ERROR: THE STRING REPRESENTATION OF A DATETIME VALUE IS NOT A VALID DATETIME VALUE

I have a mutli-step job that executes the same program in a couple of different places, that is driven by a parm. I would like to get rid of the parm and do the processing based on the step being executed. Can I find out what step is being executed while my program is running?

I can't see any obvious errors. INSPECT WS-VCPY-DSN REPLACING ', ' BY 'VCPY,'. "', '" WAS FOUND IN THE "INSPECT" STATEMENT. IT WAS NOT ALLOWED IN THIS CONTEXT. THE STATEMENT WAS DISCARDED.

SELECT FIELD1 FROM TABLE1 A, TABLE2 B WHERE A.FIELD1 = :WS-FIELD1 AND B.FIELD1 = A.FIELD1 AND A.FILED2 = 2 AND B.FIELD3 = 2...

Our leader decided to keep our date fields as PIC X(8) instead of my recommended PIC 9(8). We are suppose to initialize some of the date fields for privacy reasons. So when I initialize the date it became spaces (obviously) instead of zeroes. My tech leader then kicked himself for not using...

This is for the mainframe. I have coded extensively in CLIST but not REXX. Can someone tell me if this can be accomplished with REXX? I have a COBOL job (job1) that writes out to a flat file, most of the times with mutlipe VOLSER's. I then have a 2nd job that reads the file created by job1...

Help. I am drawing a blank. I have built an internal table using an index. I now want to display the contents of the table. How do I do this?

I need to build an internal table. I can either build 1 talbe with 8 occurances or build 2 tables with 4 occurances each. This table will be search for each record. The top 4 occurances will be searched 1 time per record. The last 4 occurances can be searched more than 1 time per record...

I need to put a query together where the key is in 1 table but not in another table. How do I go about doing this? Thanks!!

Let's say I have coded a linkage section in my program but do not specify a PARM in JCL. What value would LINKAGE-RECL contain? 01 LINKAGE. 05 LINKAGE-RECL PIC S9(2) USAGE COMP. 05 LINKAGE-FIELD PIC X(1).

Sorry, could not find a JCL forum to put this under. I have a proc with 2 steps. 1st step is a SORT, 2nd step is executes a DB2 program. My run JCL looks like //JS020 EXEC PROC=PROCNAME //SYSTSIN DD * DSN SYSTEM (DB2T) RUN PROGRAM(PROGNAME)...

I have a COBOL DB2 pgm that updates a table with record counts for a request. Can my COBOL pgm pass the request number and record count to my DB2 pgm and succesfully call it?

Does anyone have experience with this? I have coded QuickStart previously in a driver program but not in a subprogram.

I am coding dynamic SQL. I have a input file with 100 claims. On 4 of the claims my program gets a +100 on the FETCH, but when I hard code a SELECT right after my FETCH, I am getting a row back. I am guessing my pointer is getting hosed somehow. Dynamic SQL uses address's for its WHERE...