Author |
Message |
Topic: Empty file |
Rahull
Replies: 20
Views: 17284
|
Forum: Job Control Language(JCL) Posted: Wed Oct 31, 2007 1:24 pm Subject: Empty file |
Hi,
Is it possible to check for the EMPTY ESDS ? I tried all above options for flat file and none of them giving me convincing output ?
Thanks
Rahul |
Topic: Trailer Issue! |
Rahull
Replies: 4
Views: 2803
|
Forum: Job Control Language(JCL) Posted: Wed May 16, 2007 11:24 am Subject: Trailer Issue! |
Hi,
Please help me figure out how to obtain the below result:
Problem : I have an input file with header, detail and trailer record. File length is 80 byte and record layout for trailer is :
... |
Topic: Replacing highest valued record using Sort |
Rahull
Replies: 3
Views: 2324
|
Forum: Utilities Posted: Thu Aug 03, 2006 2:39 pm Subject: Replacing highest valued record using Sort |
Hi Kolusu,
My Shop supports only SYNCSORT. Below are the error messages I m getting.
SYNCSORT FOR Z/OS 1.1CR TPF3A U.S. PATENTS: 42
... |
Topic: Replacing highest valued record using Sort |
Rahull
Replies: 3
Views: 2324
|
Forum: Utilities Posted: Thu Aug 03, 2006 1:27 pm Subject: Replacing highest valued record using Sort |
Hi,
Looking solution for the below problem.
Input file : Policy number (20), count(2),Name(5)
P1234567890 10 ROB
P1234567890 11 RYAN
P1234567891 05 MYAN
P1234567891 ... |
Topic: Time lag to handle Deadlock in DB2 |
Rahull
Replies: 2
Views: 1903
|
Forum: Database Posted: Tue Jul 25, 2006 3:24 pm Subject: Time lag to handle Deadlock in DB2 |
Hi,
In case of deadlock of Db2 table, my batch program abend with 911. Is there any way of adding parameter for eg some scaler function which we can add in Db2 cobol program so that program try mo ... |
Topic: Pick all Policy Number records based on selection criteria |
Rahull
Replies: 15
Views: 7181
|
Forum: Utilities Posted: Thu Jul 20, 2006 8:59 am Subject: Pick all Policy Number records based on selection criteria |
I forgot to put the error message...Sorry about that... Let me figure it out and if I failed I will ask your help... |
Topic: Pick all Policy Number records based on selection criteria |
Rahull
Replies: 15
Views: 7181
|
Forum: Utilities Posted: Thu Jul 20, 2006 8:43 am Subject: Pick all Policy Number records based on selection criteria |
Hi, Could you tell what's wrong in below job step. I want to sort PAIR file again on policy and trasaction id:
//STEP0100 EXEC PGM=SYNCTOOL
//DFSMSG DD SYSOUT=* ... |
Topic: Pick all Policy Number records based on selection criteria |
Rahull
Replies: 15
Views: 7181
|
Forum: Utilities Posted: Wed Jul 19, 2006 1:37 pm Subject: Sort on Policy |
Hi,
Is it possible to split the file with same policy number record but are in pair in one file and all other records in second file. If there are more then 2 records for the same policy, it shoul ... |
Topic: Pick all Policy Number records based on selection criteria |
Rahull
Replies: 15
Views: 7181
|
Forum: Utilities Posted: Wed Jul 05, 2006 2:30 pm Subject: Pick all Policy Number records based on selection criteria |
Thanks Frank for the update.
Should I write a cobol program for my problem? Or can we still achieve the same in multiple steps ? |
Topic: Pick all Policy Number records based on selection criteria |
Rahull
Replies: 15
Views: 7181
|
Forum: Utilities Posted: Wed Jul 05, 2006 12:50 pm Subject: Pick all Policy Number records based on selection criteria |
Also, If I go with SAR message, system by default is picking up SYNCSORT. I check in system libary SYS1.SYNCLINK and I found the load of ICETOOL but ICETOOL is DFsort product?
Is there anything I ... |
Topic: Pick all Policy Number records based on selection criteria |
Rahull
Replies: 15
Views: 7181
|
Forum: Utilities Posted: Wed Jul 05, 2006 12:02 pm Subject: Pick all Policy Number records based on selection criteria |
I am using SPLICE in many JCLs and its working fine. I don't know why its not working this time,. |
Topic: Pick all Policy Number records based on selection criteria |
Rahull
Replies: 15
Views: 7181
|
Forum: Utilities Posted: Wed Jul 05, 2006 12:01 pm Subject: Pick all Policy Number records based on selection criteria |
When I ran it first with the JCL you gave me I got the below error messages:
SYT000I SYNCTOOL RELEASE 1.4D - COPYRIGHT 2003 SYNCSORT INC.
SYT001I INITIAL PROCESSING MODE IS &q ... |
Topic: Pick all Policy Number records based on selection criteria |
Rahull
Replies: 15
Views: 7181
|
Forum: Utilities Posted: Wed Jul 05, 2006 11:47 am Subject: Pick all Policy Number records based on selection criteria |
Thanks Kolusu for quick reply.
Its not working on my shop. May be we don't have new release. I am getting syntax error for IFTHEN. Could it be possible with normal Dfsort utility ? |
Topic: Pick all Policy Number records based on selection criteria |
Rahull
Replies: 15
Views: 7181
|
Forum: Utilities Posted: Wed Jul 05, 2006 10:23 am Subject: Pick all Policy Number records based on selection criteria |
Hi,
Please help to get SORT JCL for the below problem.I have an input file with following record layout.
Account X(10)
Code X(02)
Policy Number ... |
Topic: Sum of amounts using SPLICE |
Rahull
Replies: 5
Views: 3069
|
Forum: Utilities Posted: Tue Apr 11, 2006 10:25 am Subject: Sum of amounts using SPLICE |
Hi Kolusu,
Sorry for the misunderstanding.
Whatever I posted in my last post is the final layout for each file. Also please find the layout of Files :
File 1 :
Account Pic X(10).
Policy ... |
|