| Author |
Message |
Topic: Count records and copy only if more than 250 records. |
bprasanna
Replies: 4
Views: 2533
|
Forum: Utilities Posted: Sun Jan 10, 2010 1:18 pm Subject: Count records and copy only if more than 250 records. |
bsaishankar,
What do you want to write in the outut file when the count is greater than 250 ?
Thanks |
Topic: Report from a Report |
bprasanna
Replies: 6
Views: 3878
|
Forum: Utilities Posted: Mon Apr 13, 2009 5:01 am Subject: Report from a Report |
TVSSV,
Please check the below code.(Successfully tested with SYNCSORT FOR Z/OS 1.2.1.1NI).
//STEP0100 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=* ... |
Topic: SyncSort - how to save data from record |
bprasanna
Replies: 4
Views: 2846
|
Forum: Utilities Posted: Mon Apr 13, 2009 4:09 am Subject: SyncSort - how to save data from record |
Hi,
Try the below if you have old SYNCSORT version which supports IF then clause.
//STEP0100 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=* ... |
Topic: how to know the account info for a data set ? |
bprasanna
Replies: 3
Views: 2296
|
Forum: Job Control Language(JCL) Posted: Thu Dec 04, 2008 1:23 am Subject: how to know the account info for a data set ? |
| Thank you Tallyman for the info. |
Topic: how to know the account info for a data set ? |
bprasanna
Replies: 3
Views: 2296
|
Forum: Job Control Language(JCL) Posted: Tue Dec 02, 2008 8:23 am Subject: how to know the account info for a data set ? |
Hi,
Is there any possibility to find out the account info of a file that got created ?
We are using diffrent account info(of diffrent customers) in the JCL to create datasets,now some one asked us ... |
Topic: Sum of the records between group of records |
bprasanna
Replies: 4
Views: 3318
|
Forum: Utilities Posted: Tue Sep 23, 2008 1:21 pm Subject: Sum of the records between group of records |
Kolusu&Frank,
Thanks for the reply.Can we do this without using the DATASORT or WHEN=GROUP
conditions ?
Thanks
Bprasanna |
Topic: Sum of the records between group of records |
bprasanna
Replies: 4
Views: 3318
|
Forum: Utilities Posted: Tue Sep 23, 2008 6:52 am Subject: Sum of the records between group of records |
Hi,
I am having a FB file of length 80.The sample input looks like this.
M01
S225
627 AA bb 84
627 BB bb 05
627 CC zz 06
627 AA bb 05
T225
S225
628 ab cd 12
T22 ... |
Topic: converting data from one form to another |
bprasanna
Replies: 2
Views: 2152
|
Forum: Utilities Posted: Thu Sep 11, 2008 1:43 am Subject: converting data from one form to another |
Thanks a Lot Kolusu!
Thanks
Bprasanna |
Topic: converting data from one form to another |
bprasanna
Replies: 2
Views: 2152
|
Forum: Utilities Posted: Wed Sep 10, 2008 1:51 pm Subject: converting data from one form to another |
Hi,
I am having a file with the input shown below.
00000001923 C
00000357075 D
00000872666 D
00000880050 C
This is getting converted thru an Ezt as below.
0000000192L C
0 ... |
Topic: how to select a block of records from the file ? |
bprasanna
Replies: 4
Views: 2862
|
Forum: Utilities Posted: Sat Jun 14, 2008 1:27 pm Subject: how to select a block of records from the file ? |
Hi Kolusu,
The block starts always with 'aaaa...' .
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
and the second line will be 'ark'
ark
After that there might be 'n' number of 'a's .
a
a
.
.
... |
Topic: how to select a block of records from the file ? |
bprasanna
Replies: 4
Views: 2862
|
Forum: Utilities Posted: Fri Jun 13, 2008 2:42 pm Subject: how to select a block of records from the file ? |
Hi,
I am having a fb file of lrecl 80 with the as shown below.
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
ark
a
a
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
ack
a
aaaa ... |
Topic: Compare records on 2 files |
bprasanna
Replies: 5
Views: 3498
|
Forum: Utilities Posted: Wed Jun 04, 2008 5:08 am Subject: Compare records on 2 files |
chikdu,
Please check the below code.
//S1 EXEC PGM=SORT
//TOOLMSG DD SYSOUT=*
//DFSMSG ... |
Topic: DIVIDE option in SORT |
bprasanna
Replies: 5
Views: 4908
|
Forum: Utilities Posted: Fri Mar 14, 2008 11:06 pm Subject: DIVIDE option in SORT |
Thanks for the resonce.My question is when I use DIVIDE option on a number(123456) by 100,I need to get the o/p as 1234.56.How can I achive by using DIVIDE option.
123456 /100 = 1234.56
Regards
... |
Topic: SYNCSORT FORMATING OF RECORDS? |
bprasanna
Replies: 5
Views: 2786
|
Forum: Utilities Posted: Wed Oct 17, 2007 1:25 pm Subject: SYNCSORT FORMATING OF RECORDS? |
Hi,
I checked the forum ,but I don't see any thing to write the TOT as the initial line.
All the TOT is happening at the end with TRAILER options.Can this be done thru
IBM sort? I am just curious t ... |
Topic: SYNCSORT FORMATING OF RECORDS? |
bprasanna
Replies: 5
Views: 2786
|
Forum: Utilities Posted: Tue Oct 16, 2007 1:36 pm Subject: SYNCSORT FORMATING OF RECORDS? |
Hi,
I am having the file with FB of length 80.The i/p is like below.
----+----1----+----2----+----3----+----4----+----5----+----6----+
***************************** Top of Data **************** ... |
| |