MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 32 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: increase the record length?
naren_ab

Replies: 2
Views: 6587

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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 ...
 
Page 1 of 3 Goto page 1, 2, 3  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group