Search found 8 matches

by mithunthakre
Fri Dec 07, 2007 6:10 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 Query
Replies: 1
Views: 5082

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...
by mithunthakre
Fri Dec 08, 2006 12:28 pm
Forum: JCL
Topic: Violation of DSN
Replies: 3
Views: 6158

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
by mithunthakre
Tue Sep 19, 2006 4:17 pm
Forum: JCL
Topic: How get totals at bottom of the files
Replies: 1
Views: 4245

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
by mithunthakre
Mon Sep 04, 2006 2:20 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: How to handle the null indiactor
Replies: 2
Views: 12024

Thanks Krishna
by mithunthakre
Wed Aug 23, 2006 4:10 pm
Forum: ENDEVOR, COOLGEN , PANVALET and CA-7
Topic: Endevor
Replies: 5
Views: 14189

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
by mithunthakre
Tue Aug 22, 2006 11:04 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: How to handle the null indiactor
Replies: 2
Views: 12024

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
by mithunthakre
Mon Aug 21, 2006 2:16 pm
Forum: JCL
Topic: How to count the no of records through JCL
Replies: 1
Views: 7426

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
by mithunthakre
Mon Feb 27, 2006 4:57 pm
Forum: JCL
Topic: HOW TO CAPTURE JOBLOG THROUGH JCL
Replies: 7
Views: 16659

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...