Search found 31 matches

by archup20
Fri Oct 14, 2011 5:50 pm
Forum: JCL
Topic: JCL to get the record count of a table
Replies: 17
Views: 27722

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

Is nt this an unload JCL??

Is there any other way to get the record count of a table into a file?
by archup20
Fri Oct 14, 2011 9:02 am
Forum: JCL
Topic: Sort card to get the information to a file
Replies: 6
Views: 8208

The Input will be coming from around 50 Files, each having just 1 line i.e.,

No of records: 0000000100

The output should be as mentioned above.

The Tablename and the header should be present in the output file.
It should be hard coded in the sort card.
by archup20
Thu Oct 13, 2011 4:22 pm
Forum: JCL
Topic: Sort card to get the information to a file
Replies: 6
Views: 8208

To be more specific, the output file should look like this.

Table Records
TableName : 0000000100
by archup20
Thu Oct 13, 2011 4:11 pm
Forum: JCL
Topic: Sort card to get the information to a file
Replies: 6
Views: 8208

It should come from the sort card only
by archup20
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...
by archup20
Thu Oct 13, 2011 9:53 am
Forum: JCL
Topic: JCL to get the record count of a table
Replies: 17
Views: 27722

Which Utility should I use? Can you please suggest an alternate one.
by archup20
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?
by archup20
Wed Oct 12, 2011 11:50 am
Forum: JCL
Topic: JCL to get the record count of a table
Replies: 17
Views: 27722

thanks for the new bit of information Anuj.
I did not know that unload JCLs can work like this.

When I gave SELECT COUNT(*) in my unload JCL, the output file did not contain the number of records.
by archup20
Tue Oct 04, 2011 11:58 am
Forum: JCL
Topic: JCL to get the record count of a table
Replies: 17
Views: 27722

I have tried The SELECT COUNT(*) option instead of SELECT (*) but the output is not proper in my SYSREC00.
by archup20
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...
by archup20
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

I used a JCL to convert 13,2 to 15,2 but from 15,2 I have to load to a 16,0 table.
I am not able to write a code for that. Can u please give an idea how to write that code
by archup20
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

Can you please give me the exact query? Thanks in advance
by archup20
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
by archup20
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

Thanks.... But I dont have permission on that