Sorry dint check properly.
I tried using the DSNTEP2
DSN SYSTEM(GRT1)
RUN PROGRAM(DSNTEP2) PLAN(DSNTEP2) PARMS('SQL') -
LIB(' ')
But i am getting a MAXCC=8 with the below message
DSNT499I ERROR IN INPUT PARAMETER LIST
Search found 31 matches
- Fri Oct 14, 2011 5:50 pm
- Forum: JCL
- Topic: JCL to get the record count of a table
- Replies: 17
- Views: 27722
- Fri Oct 14, 2011 4:32 pm
- Forum: JCL
- Topic: JCL to get the record count of a table
- Replies: 17
- Views: 27722
- Fri Oct 14, 2011 9:02 am
- Forum: JCL
- Topic: Sort card to get the information to a file
- Replies: 6
- Views: 8208
- Thu Oct 13, 2011 4:22 pm
- Forum: JCL
- Topic: Sort card to get the information to a file
- Replies: 6
- Views: 8208
- Thu Oct 13, 2011 4:11 pm
- Forum: JCL
- Topic: Sort card to get the information to a file
- Replies: 6
- Views: 8208
- Thu Oct 13, 2011 3:28 pm
- Forum: JCL
- Topic: Sort card to get the information to a file
- Replies: 6
- Views: 8208
Sort card to get the information to a file
Can someone please help me with a sort option to get the following output. I have around 50 files, all having the data as follows, No of records: 0000000100 Each file has the record count of different tables. Ineed to get these data into a single file with the table name. Output TableName : 00000001...
- Thu Oct 13, 2011 9:53 am
- Forum: JCL
- Topic: JCL to get the record count of a table
- Replies: 17
- Views: 27722
- Thu Oct 13, 2011 9:24 am
- Forum: JCL
- Topic: JCL to Load multiple tables from files
- Replies: 6
- Views: 8348
JCL to Load multiple tables from files
Does anyone have JCL to load Multiple tables from different files?
- Wed Oct 12, 2011 11:50 am
- Forum: JCL
- Topic: JCL to get the record count of a table
- Replies: 17
- Views: 27722
- Tue Oct 04, 2011 11:58 am
- Forum: JCL
- Topic: JCL to get the record count of a table
- Replies: 17
- Views: 27722
- Mon Oct 03, 2011 3:02 pm
- Forum: JCL
- Topic: JCL to get the record count of a table
- Replies: 17
- Views: 27722
JCL to get the record count of a table
What should I include in my Unload JCL in order to get the record count of the table into a file while unloading it. Currently my Unload JCL is as given below, //STEP010 EXEC PGM=IKJEFT01 //STEPLIB DD DSN=DB2P.RUNLIB.LOAD,DISP=SHR //SYSTSPRT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(GRT1) RUN PROGRAM(DS...
- Wed Dec 29, 2010 4:30 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: How to load data from a (15,2) table to (16,0) table
- Replies: 3
- Views: 5722
- Fri Dec 24, 2010 11:11 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: How to check the date of data load into a Table
- Replies: 4
- Views: 7489
- Fri Dec 24, 2010 10:39 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: How to load data from a (15,2) table to (16,0) table
- Replies: 3
- Views: 5722
How to load data from a (15,2) table to (16,0) table
I have test table which has colums of size (15,2) and I have extract data from these Tables and load it into production table where the same colums are of size (16,0).How do I do this?.Thanks in advance.
do not use size in your posts - impolite
moved to db2 forum
dbz
do not use size in your posts - impolite
moved to db2 forum
dbz
- Fri Dec 24, 2010 10:34 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: How to check the date of data load into a Table
- Replies: 4
- Views: 7489