Search found 31 matches
Load Jcl
Hi, I need to load few records in to a table. My question is what does the Position in load card signify? for eg: ( T_N POSITION( 1 ) CHAR ( 6) ) Also I wanted to know if I remove some columns in load card(these colums should not be loaded to the table)will those not be loaded to the table? Please h...
- Tue Aug 14, 2012 10:58 am
- Forum: JCL
- Topic: Parm limit
- Replies: 12
- Views: 13708
NicC, its the latter option that is I have to pass parameters in a dataset. In the requirements they had used the word PARM card and file, hence the confusion. As you have mentioned it is an input file to be read in the program. Got to know about it today. :) Just curious on how a dataset name passe...
- Mon Aug 13, 2012 3:41 pm
- Forum: JCL
- Topic: Parm limit
- Replies: 12
- Views: 13708
- Mon Aug 13, 2012 11:56 am
- Forum: JCL
- Topic: Parm limit
- Replies: 12
- Views: 13708
Parm limit
I need to send around 300 different values to the cobol program via parm card. I was thinking of using a file. What is the maximum limit of the Parm? I checked the forum and found that the limit is 100. Will that be applicable to the file also? In my requirement it is specifically mentioned to use p...
- Thu May 24, 2012 9:19 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sort to copy data from first column from a file and paste it
- Replies: 4
- Views: 7160
Sort to copy data from first column from a file and paste it
Hi,
Can a sort card be wriiten to copy data from first column of a file and paste in the 16th column of the same file?
Please suggest me on this.
Can a sort card be wriiten to copy data from first column of a file and paste in the 16th column of the same file?
Please suggest me on this.
- Fri Dec 23, 2011 2:53 pm
- Forum: JCL
- Topic: Delete a column from a file
- Replies: 2
- Views: 7605
I tried the following variation and it worked fine.
Thanks
Code: Select all
//SYSIN DD *
SORT FIELDS=COPY
OUTREC FIELDS=(1,40,
49,8,
65,212)
- Thu Dec 22, 2011 4:28 pm
- Forum: JCL
- Topic: Delete a column from a file
- Replies: 2
- Views: 7605
Delete a column from a file
Hi,
I have data in a flat file from which I have to remove 2 columns of packed decimal first column starts at position 41 and is of length 8 and the second column begins at position 57 and is of length 8.
What should be done in order to delete these 2 columns.
I have data in a flat file from which I have to remove 2 columns of packed decimal first column starts at position 41 and is of length 8 and the second column begins at position 57 and is of length 8.
What should be done in order to delete these 2 columns.
- Thu Dec 22, 2011 4:22 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO
- Replies: 7
- Views: 12725
- Thu Nov 24, 2011 3:04 pm
- Forum: JCL
- Topic: DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO
- Replies: 1
- Views: 3346
DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO
Hi
While trying to load or unload a table, I am getting the retirn code MAXCC=12 and the error message as
DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO
How can I solve this?
Please guide me.
I tried giving the command -START DB2, but that is not working.
Please help.
While trying to load or unload a table, I am getting the retirn code MAXCC=12 and the error message as
DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO
How can I solve this?
Please guide me.
I tried giving the command -START DB2, but that is not working.
Please help.
- Thu Nov 24, 2011 3:03 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO
- Replies: 7
- Views: 12725
DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO
Hi
While trying to load or unload a table, I am getting the retirn code MAXCC=12 and the error message as
DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO
How can I solve this?
Please guide me.
I tried giving the command -START DB2, but that is not working.
Please help.
While trying to load or unload a table, I am getting the retirn code MAXCC=12 and the error message as
DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO
How can I solve this?
Please guide me.
I tried giving the command -START DB2, but that is not working.
Please help.
- Thu Nov 10, 2011 10:25 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sort to convert PD to numeric
- Replies: 6
- Views: 14371
- Wed Nov 09, 2011 9:56 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sort to convert PD to numeric
- Replies: 6
- Views: 14371
Thanks DikDude and Frank. I got hte decimal point by using the below code SORT FIELDS=COPY OUTREC FIELDS=(1,558, 559,9,PD,EDIT=(sTTTTTTTTTTTTTT.TT),SIGNS=(,,+,-), 568,33) But now I am getting too many leading zeroes and the negative signs are not visible. Now 17688.54 comes like this 0000017688.54 I...
- Tue Nov 08, 2011 6:20 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sort to convert PD to numeric
- Replies: 6
- Views: 14371
Sort to convert PD to numeric
I have PD field of length s9(14)v99 I got it converted to numeric using the code SORT FIELDS=COPY OUTREC FIELDS=(1,558, 559,9,PD,EDIT=(TTTTTTTTTTTTTTTTS),SIGNS=(,,+,-), 568,33) But instead of getting the values with decimal like 17688.54 I am getting like this 1768854 Please give suggestions on how ...
- Thu Oct 20, 2011 4:04 pm
- Forum: JCL
- Topic: JCL to get the record count of a table
- Replies: 17
- Views: 27725
//STEP010 EXEC PGM=IKJEFT01 //STEPLIB DD DSN=DB2P.RUNLIB.LOAD,DISP=SHR //SYSTSPRT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(GRT1) RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) - LIB('DB2P.RUNLIB.LOAD') END //SYSREC DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //* //SYSPUNCH DD DUMMY //SYSPRINT DD DSN=T6329EG.DATA.PUSDSMX, /...
- Sat Oct 15, 2011 11:14 am
- Forum: JCL
- Topic: JCL to get the record count of a table
- Replies: 17
- Views: 27725