Author |
Message |
Topic: increase the record length? |
naren_ab
Replies: 2
Views: 6587
|
Forum: Utilities Posted: Mon Jul 17, 2006 11:05 am Subject: increase the record length? |
I am trying to convert a 256 byte VB, to 23086 VB file. I am using sort, and I am getting error. Can you help? Thank You
My sort card :-
//SYSIN DD *
SORT FIELDS=COPY ... |
Topic: Error during matching files using Icetool or Syncsort |
naren_ab
Replies: 8
Views: 6149
|
Forum: Utilities Posted: Tue Jan 24, 2006 3:29 pm Subject: Error during matching files using Icetool or Syncsort |
Excellent,,
Thank you so much.
Naren |
Topic: Error during matching files using Icetool or Syncsort |
naren_ab
Replies: 8
Views: 6149
|
Forum: Utilities Posted: Tue Jan 24, 2006 11:18 am Subject: Error during matching files using Icetool or Syncsort |
So how else can I solve his problem. The LRECL for fileA is 20 bytes, and second fileB is 300, I need to match on key field.
FileA key is pos=1, length=20
FileB key is pos=13 length=20
and I ne ... |
Topic: Error during matching files using Icetool or Syncsort |
naren_ab
Replies: 8
Views: 6149
|
Forum: Utilities Posted: Tue Jan 24, 2006 10:56 am Subject: Error during matching files using Icetool or Syncsort |
That helped, but I am getting:-
CONCAT DS, LRECLS NE OR RECFMS DIFF
thought that I can use ICETOOL for different LRECL.
Thanks
Naren |
Topic: Error during matching files using Icetool or Syncsort |
naren_ab
Replies: 8
Views: 6149
|
Forum: Utilities Posted: Tue Jan 24, 2006 8:51 am Subject: Error during matching files using Icetool or Syncsort |
Here it is:-
1 SYNCSORT FOR Z/OS 1.1CRI TPF3A U.S. PATENTS: 4210961, 5117495 (C) 2002 SYNCSORT INC. DATE=2006/024 TIME=08.35.56
z/OS 1.4.0
PRODUCT LICENSED FO ... |
Topic: Error during matching files using Icetool or Syncsort |
naren_ab
Replies: 8
Views: 6149
|
Forum: Utilities Posted: Mon Jan 23, 2006 5:09 pm Subject: Error during matching files using Icetool or Syncsort |
I need to compare 2 files, fileA has key in pos=4, length=13, and fileB has in position=19 length=13, fileA LRECL=20, LRECL for fileB=300.
when there is match fileB needs to written to output.
her ... |
Topic: Need to pass month part to next step |
naren_ab
Replies: 11
Views: 9031
|
Forum: Utilities Posted: Thu Jan 19, 2006 12:59 pm Subject: Need to pass month part to next step |
Need some more help,
I got the value from previous step as 01 for January,
In the next sort step I have another file with date field, I want to get all the records from that file with same month ... |
Topic: Need to pass month part to next step |
naren_ab
Replies: 11
Views: 9031
|
Forum: Utilities Posted: Thu Jan 19, 2006 12:06 pm Subject: Need to pass month part to next step |
Kolusu,
I am getting this error. what I am missing here
in first sort step I have
OUTFIL OUTREC=(C' INCLUDE COND=(7,2,PD,EQ,',33,2,PD,EDIT(TT),C')')
output is INCLUDE COND=(7,2,PD,EQ,01 ... |
Topic: Need to pass month part to next step |
naren_ab
Replies: 11
Views: 9031
|
Forum: Utilities Posted: Thu Jan 19, 2006 12:03 pm Subject: Need to pass month part to next step |
It is date field, and I need to work on the month part of it.
naren |
Topic: Need to pass month part to next step |
naren_ab
Replies: 11
Views: 9031
|
Forum: Utilities Posted: Thu Jan 19, 2006 11:48 am Subject: Need to pass month part to next step |
Can I pass the packed decimal value itself instead of character, that way I can use that against a packed decimal month field on the second file in next sort step. Because the second file in the next ... |
Topic: Need to pass month part to next step |
naren_ab
Replies: 11
Views: 9031
|
Forum: Utilities Posted: Thu Jan 19, 2006 8:47 am Subject: Need to pass month part to next step |
Thanks Kolusu and Phantom, that works, thank you both. actually I overlooked the last line in Phantom reply, my mistake.
Thanks |
Topic: Need to pass month part to next step |
naren_ab
Replies: 11
Views: 9031
|
Forum: Utilities Posted: Thu Jan 19, 2006 7:08 am Subject: Need to pass month part to next step |
Yes, that helped me, thanks Phantom.
I wrote the month to file. How can I pass this month in the file to next sort step as a condition.
Thanks
naren |
Topic: Need to pass month part to next step |
naren_ab
Replies: 11
Views: 9031
|
Forum: Utilities Posted: Thu Jan 19, 2006 5:42 am Subject: Need to pass month part to next step |
Need help,
I have file, which I sorted and pickedup the records I wanted, and outreced the field I wanted to.
the output field contains a date field, I need to get just month part of it can I do ... |
Topic: BMC UNLOAD PLUS |
naren_ab
Replies: 4
Views: 9147
|
Forum: Database Posted: Tue Oct 28, 2003 11:55 am Subject: BMC UNLOAD PLUS |
That helps a lot, Thank you.
FYI - minus sign works, but not plus sign, the Ironic thing is plus sign works if i specify DIRECT NO.
thanks
krishna |
Topic: BMC UNLOAD PLUS |
naren_ab
Replies: 4
Views: 9147
|
Forum: Database Posted: Tue Oct 28, 2003 10:17 am Subject: BMC UNLOAD PLUS |
Kolusu thanx for the reply,
Can i use DSNTIAUL in this case and use shrlevel change and current date + 20 days thing.
And when you said "As far as I know you can only substract an integer with Th ... |
|