Search found 31 matches

by archup20
Fri Oct 26, 2012 10:23 am
Forum: JCL
Topic: Load Jcl
Replies: 2
Views: 3471

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...
by archup20
Tue Aug 14, 2012 10:58 am
Forum: JCL
Topic: Parm limit
Replies: 12
Views: 13703

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...
by archup20
Mon Aug 13, 2012 3:41 pm
Forum: JCL
Topic: Parm limit
Replies: 12
Views: 13703

My requirement specifically asks for a file to be passed from JCL to COBOL using PARM. I wanted to know thestructure of Linkage Section for the file if its passed using PARM.
by archup20
Mon Aug 13, 2012 11:56 am
Forum: JCL
Topic: Parm limit
Replies: 12
Views: 13703

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...
by archup20
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: 7156

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.
by archup20
Fri Dec 23, 2011 2:53 pm
Forum: JCL
Topic: Delete a column from a file
Replies: 2
Views: 7602

I tried the following variation and it worked fine.

Code: Select all

//SYSIN    DD *           
  SORT FIELDS=COPY        
  OUTREC FIELDS=(1,40,    
                49,8,     
                65,212)   
Thanks :D
by archup20
Thu Dec 22, 2011 4:28 pm
Forum: JCL
Topic: Delete a column from a file
Replies: 2
Views: 7602

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.
by archup20
Thu Dec 22, 2011 4:22 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO
Replies: 7
Views: 12719

Hi All,

I asked the DBA about this issue and got to know that the DBXX region was changed and we were not informed about it. So changing the DBXX region in the JCL, the load was successful.
by archup20
Thu Nov 24, 2011 3:04 pm
Forum: JCL
Topic: DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO
Replies: 1
Views: 3345

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.
by archup20
Thu Nov 24, 2011 3:03 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DBXX NOT OPERATIONAL, RETRY COUNT IS ZERO
Replies: 7
Views: 12719

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.
by archup20
Thu Nov 10, 2011 10:25 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Sort to convert PD to numeric
Replies: 6
Views: 14356

Thanks Frank!!!

I included your suggestions in my sort card and it works perfectly for me now. :D :)
by archup20
Wed Nov 09, 2011 9:56 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Sort to convert PD to numeric
Replies: 6
Views: 14356

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...
by archup20
Tue Nov 08, 2011 6:20 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Sort to convert PD to numeric
Replies: 6
Views: 14356

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 ...
by archup20
Thu Oct 20, 2011 4:04 pm
Forum: JCL
Topic: JCL to get the record count of a table
Replies: 17
Views: 27722

//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, /...
by archup20
Sat Oct 15, 2011 11:14 am
Forum: JCL
Topic: JCL to get the record count of a table
Replies: 17
Views: 27722

Thanks dbZ and DikDude it is working fine now.
:)