hi, i hav 5 ps with content , each of those ps s having output of differenrt queries , ie count * values. Now i want to get all those ps contents in to one ps and in the same row...can any one give the solution pls...
hi, i hav 5 ps with content , each of those ps s having output of differenrt queries , ie count * values. Now i want to get all those ps contents in to one ps and in the same row...can any one give the solution pls...
Here s my problem( i cant use icetool)
....example...
I want to merge two files laterally record by record. For example:
If FILE1 contains:
56789
BBBBB
CCCCC
and FILE2 contains:
11111
22222
33333
then my output file should contain:
5678911111
BBBBB22222
CCCCC33333
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
ofer71 wrote
Quote:
IEBGENER is a standard MVS utility. You can read more about it in the fine manual.
And where exactly in the fine manual does it show how to do the "join" that fuadk84 wants to do? Please show us the IEBGENER job to do that (I'm curious if IEBGENER can actually do it).
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
I believe that concatanating datasets in SYSUT1 will result in one SYSUT2.
You need to read fuadk84's description of what's wanted carefully. You could use IEBGENER to concat file1 and file2 to get this output:
56789
BBBBB
CCCCC
11111
22222
33333
But what fuadk84 wants for output is this:
5678911111
BBBBB22222
CCCCC33333
That's a "join" of the field in file1 with the field in file2. The SPLICE operator of DFSORT's ICETOOL can do that, but as far as I know, IEBGENER can't.
For some reason, fuadk84 says ICETOOL can't be used. Not sure why.
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
I'm stuck with Syncsort where I'm working for the moment, but I recall that it can join the data from two records, I'm not sure without the fine manual. I can only assume that DFSort can do it?
Hey Frank, working late? What time is "the" dinner......grin.....
hi, i hav 5 ps with content , each of those ps s having output of differenrt queries , ie count * values. Now i want to get all those ps contents in to one ps and in the same row...can any one give the solution pls...
Thank You ...i can use icetool here.....am getting the output partially..
please find the jcl below for the same problem
here the problem is "using (ctl3)" is not working.am getting the
output + low values bcos of this problem.actually my output
s lik 1111122222........( 11111 from file1,22222 frm file 2) .
Am getting lowvalues after my desired output since ctl3cntl
is not working properly.
Can any one help me on this plzz...
am getting the output "1111122222............."(i hav given reclen as 80 for the output file since the outrec lenght may cm till 80)
when i dont use this CTL3CNTL part. When i use CNTL3 to format it
it s givin maxcc 16.....Please hav a look on this...
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
am getting the output + low values
You are getting low values because you specified LRECL=80 on the TMP1 DD. The OUTREC in CTL1CNTL creates an 18 byte record, but since you have LRECL=80 for TMP1, DFSORT pads the 18 byte records will X'00's to 80 byte records. Remove the LRECL=80 from the TMP1 DD and you won't get the low values.
I'm not sure what you're saying about CTL3CNTL. If you got a RC=16, then there will be an error message in DFSMSG, but you didn't show it.
If you use:
Code:
OUTFIL FNAMES=OUT,OUTREC=(1,10)
you will create 10 byte records for the OUT data set. If the OUT DD specifies a file with LRECL=10, then you'll just get those 10 bytes. If the OUT DD specifies a file with LRECL=80, then again DFSORT will pad with low values. If you want 80 byte records, with the first 10 bytes and then blanks, use:
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
fuadk84,
You make it very difficult to help you. If you hadn't said you couldn't use ICETOOL, I would have immediately pointed you to the "Join fields from two files record-by-record" Smart DFSORT Trick at:
which would have shown you how to do what you wanted immediately. Many posts later, you showed an ICETOOL job even though you originally said you couldn't use ICETOOL. You said there was an error, but didn't show the error message. Subhasis then showed you the Smart DFSORT Trick that I would have told you about after your first post.
In the future, please try to post in such a way that you don't make it difficult for people to help you.
New the SPLICE operator creates a spliced record for each pair of sequence numbers with the 1-5 field from the first record and the 6-10 field from the second record. The OUTFIL statement removes the sequence number.
