Author |
Message |
Topic: DFSORT to extract group of recrods as for the detail rec amt |
rama krishna reddy
Replies: 3
Views: 2256
|
Forum: Utilities Posted: Mon Sep 14, 2015 8:45 pm Subject: DFSORT to extract group of recrods as for the detail rec amt |
thanks kolusu the sort job is working for my requirement |
Topic: DFSORT to extract group of recrods as for the detail rec amt |
rama krishna reddy
Replies: 3
Views: 2256
|
Forum: Utilities Posted: Thu Sep 10, 2015 8:53 pm Subject: DFSORT to extract group of recrods as for the detail rec amt |
Hi Team,
I need dfsort solution to extract only group with fee amount is greater than zero
ALL FN20 RECORDS HAVING FEE WILL HAVE SUBCAT VALUE AND FEE VALUE
if there is any fn20 with out fee ... |
Topic: Vsam open problem-cc 35 |
rama krishna reddy
Replies: 8
Views: 7897
|
Forum: Data Management Posted: Fri May 29, 2009 7:39 am Subject: Vsam open problem-cc 35 |
Hi Kolusu,
I have used the below job
//DBBA025 EXEC PGM=SORT,PARM='VSAMEMT=YES'
//SORTIN DD DSN=TEST.CLMFACTS.PENDMED2.EMPTY.FILE,DISP=SHR
//SYSOUT DD SYSO ... |
Topic: Vsam open problem-cc 35 |
rama krishna reddy
Replies: 8
Views: 7897
|
Forum: Data Management Posted: Mon May 25, 2009 11:29 pm Subject: Vsam open problem-cc 35 |
Hi,
The dd name is correct ,the cluster did not have any data
i mean the cluster is empty thats why iam getting this proble,i want to initialize the cluster thru job without changing the program ... |
Topic: Vsam open problem-cc 35 |
rama krishna reddy
Replies: 8
Views: 7897
|
Forum: Data Management Posted: Mon May 25, 2009 3:48 am Subject: Vsam open problem-cc 35 |
Hi All,
I need to initialize a vsam cluster because iam getting cc 35 (in the program they are opening in i/p mode ,it is an empty cluster)
We are not supposed to modify the program to handle ... |
Topic: SEQNUM value is not coming correctly |
rama krishna reddy
Replies: 6
Views: 3435
|
Forum: Utilities Posted: Wed Jan 14, 2009 9:33 pm Subject: SEQNUM value is not coming correctly |
Hi Kolusu,
As for the current requirement i will have maximum 6 plans
Thanks
Rama krishna reddy |
Topic: SEQNUM value is not coming correctly |
rama krishna reddy
Replies: 6
Views: 3435
|
Forum: Utilities Posted: Wed Jan 14, 2009 1:51 am Subject: SEQNUM value is not coming correctly |
Hi Kolusu
Thanks for the solution ,it is working fine .
I have used below JOB:
//STEP01 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=TES ... |
Topic: SEQNUM value is not coming correctly |
rama krishna reddy
Replies: 6
Views: 3435
|
Forum: Utilities Posted: Tue Jan 13, 2009 10:13 am Subject: SEQNUM value is not coming correctly |
Hi
I Need to print a report using the below input file ,when i try to use SEQNUM for the count iam not getting correct result.
Iam trying to do group by for first 12 char of teh input file
... |
Topic: Facing problem while matching 3 files using synctool |
rama krishna reddy
Replies: 5
Views: 2901
|
Forum: Utilities Posted: Thu Jul 31, 2008 1:56 am Subject: matching 3 files using synctool |
Hello Alissa Margulies
I have done using joinkeys it is working fine ,but as for my requirement
i need to match 3 files file-1,file-2,file-3
1)need to extract file-1 records which are t ... |
Topic: Facing problem while matching 3 files using synctool |
rama krishna reddy
Replies: 5
Views: 2901
|
Forum: Utilities Posted: Wed Jul 23, 2008 9:18 am Subject: Facing problem while matching 3 files using synctool |
Hi ,
it seems length of input file records data is less than 554
for some records, so iam facing this problem.
Please let me know what i need to do in this case.
i mean for vb files all ... |
Topic: Facing problem while matching 3 files using synctool |
rama krishna reddy
Replies: 5
Views: 2901
|
Forum: Utilities Posted: Wed Jul 23, 2008 7:51 am Subject: Facing problem while matching 3 files using synctool |
Hi ,
I have 3 VB files say file1,file2 and file3 with length as 554
As for my requirement i need to extract file1 records which are not in both file2 and file3 (i mean file1 uncommon records n ... |
Topic: JOINKEYS to join 3 files |
rama krishna reddy
Replies: 1
Views: 6374
|
Forum: Utilities Posted: Thu Jul 17, 2008 7:36 am Subject: JOINKEYS to join 3 files |
Hi ,
I need to join 3 files using syncsort ,is it possible to join 3 files using
JOIN KEYS of syncsort , if not is there any other option in sync sort where
i can join 3 files and i can wri ... |
Topic: Join two files |
rama krishna reddy
Replies: 10
Views: 5919
|
Forum: Utilities Posted: Thu Jul 17, 2008 7:35 am Subject: JOINKEYS to join 3 files |
Hi ,
I need to join 3 files using syncsort ,is it possible to join 3 files using
JOIN KEYS of syncsort , if not is there any other option in sync sort where
i can join 3 files and i can wri ... |
Topic: Spliting a file based on the key field range |
rama krishna reddy
Replies: 2
Views: 1677
|
Forum: Utilities Posted: Thu May 03, 2007 1:03 pm Subject: Spliting a file based on the key field range |
Hi Kolusu
Thanks for the quick response |
Topic: Spliting a file based on the key field range |
rama krishna reddy
Replies: 2
Views: 1677
|
Forum: Utilities Posted: Thu May 03, 2007 12:49 pm Subject: Spliting a file based on the key field range |
Hi ,
Please help me to find the solution for the below mentioned requirement
There is an i/p data set each record contains deptcode 1 to 100 and some other fields ,requirement is to split the ... |
|