Search found 8 matches
- Fri Dec 07, 2007 6:10 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: DB2 Query
- Replies: 1
- Views: 7429
DB2 Query
I need to find Failed Jobs from Mainframe DB2 Table. In the table three fileds(JOBNAME START_TIMESTAMP , END_TIMESTAMP) on this basis i want to search failed jobs from this. when the Job abend on that day there are 2 entry for that job in the table for successful exectution only one entry. I wrote t...
- Fri Dec 08, 2006 12:28 pm
- Forum: JCL
- Topic: Violation of DSN
- Replies: 3
- Views: 9128
Violation of DSN
Hi All,
I have 10 files having the size greater than 430 MB. I want to transfer the files on tapes. These files are on DASD.
How i will do this ?
Any one please help me out for this. It's very Urgentttttttt
Bye
Mit's
I have 10 files having the size greater than 430 MB. I want to transfer the files on tapes. These files are on DASD.
How i will do this ?
Any one please help me out for this. It's very Urgentttttttt
Bye
Mit's
- Tue Sep 19, 2006 4:17 pm
- Forum: JCL
- Topic: How get totals at bottom of the files
- Replies: 1
- Views: 6514
How get totals at bottom of the files
Hi,
I have the input with ZD values and i want the sum all the input records and diaplay the sum at bottom through JCL.
I am getting the totals for the duplicate records only but i need to get total irrespective of the data.
Anyone please help me.
Thanks,
Mit's
I have the input with ZD values and i want the sum all the input records and diaplay the sum at bottom through JCL.
I am getting the totals for the duplicate records only but i need to get total irrespective of the data.
Anyone please help me.
Thanks,
Mit's
- Mon Sep 04, 2006 2:20 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: How to handle the null indiactor
- Replies: 2
- Views: 20126
- Wed Aug 23, 2006 4:10 pm
- Forum: ENDEVOR, COOLGEN , PANVALET and CA-7
- Topic: Endevor
- Replies: 5
- Views: 17821
Endevor
Hi,
I have the cobol program with me. I want to find which job uses this cobol program.
How to scan the endevor for paticular program. please help me.
Thanks
Mit's
I have the cobol program with me. I want to find which job uses this cobol program.
How to scan the endevor for paticular program. please help me.
Thanks
Mit's
- Tue Aug 22, 2006 11:04 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: How to handle the null indiactor
- Replies: 2
- Views: 20126
How to handle the null indiactor
HI,
I am getting the SQLCODE as -305. how i can handle the sqlcode -305
please help me
Thanks & Regrads,
Mit's
I am getting the SQLCODE as -305. how i can handle the sqlcode -305
please help me
Thanks & Regrads,
Mit's
- Mon Aug 21, 2006 2:16 pm
- Forum: JCL
- Topic: How to count the no of records through JCL
- Replies: 1
- Views: 9701
How to count the no of records through JCL
Hi,
Suppose my input file contain 6 records then my output files having only one records that is. The no. of records in input files is 6. This i have to do by JCL please help me.
Thanks
Mits
Suppose my input file contain 6 records then my output files having only one records that is. The no. of records in input files is 6. This i have to do by JCL please help me.
Thanks
Mits
- Mon Feb 27, 2006 4:57 pm
- Forum: JCL
- Topic: HOW TO CAPTURE JOBLOG THROUGH JCL
- Replies: 7
- Views: 22243
HOW TO CAPTURE JOBLOG THROUGH JCL
HI ALL,
I WANT TO CAPTURE THE JOBLOG THROUGH JCL MEANS I WANT JESMSG
JESJCLAND SPOOL ALSO INTO FLAT FILE. WHEN I WILL SUBMIT THE JCL IT WILL STORE ALL THESE INFORMATION INTO FLAT FILE.
I DON'T WANT THROUGH SPOOL COMMOND XDC
THANKS & REGARDS,
MITHUN...
I WANT TO CAPTURE THE JOBLOG THROUGH JCL MEANS I WANT JESMSG
JESJCLAND SPOOL ALSO INTO FLAT FILE. WHEN I WILL SUBMIT THE JCL IT WILL STORE ALL THESE INFORMATION INTO FLAT FILE.
I DON'T WANT THROUGH SPOOL COMMOND XDC
THANKS & REGARDS,
MITHUN...