Page 1 of 2

Multiple Rows into Single row Multiple columns

PostPosted: Fri Sep 21, 2012 2:40 pm
by ottoelflaco
first of all, sorry my english not good

I want do the next in jcl:

file in:
charles
1999
spain


file out
charles 1999 spain



is posible do that in step?

thanks all!

Re: Multiple Rows into Single row Multiple columns

PostPosted: Fri Sep 21, 2012 3:41 pm
by BillyBoyo
You have posted in a Cobol forum.

JCL allocates the resources and tells the system what programs to run.

Do you want to do this with Cobol (yes, it would be possible) or your Sort product (yes, it would be possible) or with what? Just can't be done "in jcl" without knowing what program to execute.

Re: Multiple Rows into Single row Multiple columns

PostPosted: Fri Sep 21, 2012 3:53 pm
by ottoelflaco
Hi Billy, i want do it in Sort product. jcl step.
I m looking for that, but posibly because of my low level of english, i find nothing for that.


Thx for post

Re: Multiple Rows into Single row Multiple columns

PostPosted: Fri Sep 21, 2012 3:59 pm
by BillyBoyo
You're doing OK with your English. If you have something you feel is too complex, you can always give Google Translate a go. Try to write it really simply in your language. Use the translate. Use the translate to translate back to yours. Post the English when it translates reasonably back to your language.

For simple things, you're doing OK.

We have here forums for DFSort and SyncSort. Which do you use? If you don't know, look at the output from a sort step. The products mention their names, and DFSort messages start ICE... with SyncSort starting WER...

Re: Multiple Rows into Single row Multiple columns

PostPosted: Fri Sep 21, 2012 4:07 pm
by ottoelflaco
thx Billy, is DFSort

Re: Multiple Rows into Single row Multiple columns

PostPosted: Fri Sep 21, 2012 4:19 pm
by BillyBoyo
OK, I will move it to the DFSort forum here once you tell me you have seen the message.

Re: Multiple Rows into Single row Multiple columns

PostPosted: Fri Sep 21, 2012 4:29 pm
by ottoelflaco
OK, thank you

Re: Multiple Rows into Single row Multiple columns

PostPosted: Fri Sep 21, 2012 4:49 pm
by BillyBoyo
Now we need more information.

Is this a learning exercise, or a business requirement?

What are the LRECL and RECFM of the input and output files?

I'm thinking of RESIZE, but is your DFSORT level up-to-date?

Can you run this in a job and paste the sysout from the step here, so that we can tell?

//S1 EXEC PGM=ICEMAN
//SYSOUT   DD SYSOUT=*
//SORTIN DD *
RECORD
/*
//SORTOUT DD DUMMY
//SYSIN   DD   *
  OPTION COPY
/*


Do you only have three records? Do you have groups of three records? Is this part of a larger task?

Re: Multiple Rows into Single row Multiple columns

PostPosted: Fri Sep 21, 2012 5:16 pm
by ottoelflaco
many questions! hehe, it s only learning exercise. I only looking for the most simple way to do it. Not import size, (not resize it). I am looking the function to do that the easiest way by jcl.

thx billy ^^

Re: Multiple Rows into Single row Multiple columns

PostPosted: Fri Sep 21, 2012 5:22 pm
by ottoelflaco
billy, ICEMAN is soported in my system.