Multiple Rows into Single row Multiple columns



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Multiple Rows into Single row Multiple columns

Postby ottoelflaco » Fri Sep 21, 2012 2:40 pm

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!
ottoelflaco
 
Posts: 36
Joined: Fri Sep 21, 2012 2:33 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Multiple Rows into Single row Multiple columns

Postby BillyBoyo » Fri Sep 21, 2012 3:41 pm

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Multiple Rows into Single row Multiple columns

Postby ottoelflaco » Fri Sep 21, 2012 3:53 pm

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
ottoelflaco
 
Posts: 36
Joined: Fri Sep 21, 2012 2:33 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Multiple Rows into Single row Multiple columns

Postby BillyBoyo » Fri Sep 21, 2012 3:59 pm

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...
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Multiple Rows into Single row Multiple columns

Postby ottoelflaco » Fri Sep 21, 2012 4:07 pm

thx Billy, is DFSort
ottoelflaco
 
Posts: 36
Joined: Fri Sep 21, 2012 2:33 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Multiple Rows into Single row Multiple columns

Postby BillyBoyo » Fri Sep 21, 2012 4:19 pm

OK, I will move it to the DFSort forum here once you tell me you have seen the message.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Multiple Rows into Single row Multiple columns

Postby ottoelflaco » Fri Sep 21, 2012 4:29 pm

OK, thank you
ottoelflaco
 
Posts: 36
Joined: Fri Sep 21, 2012 2:33 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Multiple Rows into Single row Multiple columns

Postby BillyBoyo » Fri Sep 21, 2012 4:49 pm

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?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Multiple Rows into Single row Multiple columns

Postby ottoelflaco » Fri Sep 21, 2012 5:16 pm

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 ^^
ottoelflaco
 
Posts: 36
Joined: Fri Sep 21, 2012 2:33 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Multiple Rows into Single row Multiple columns

Postby ottoelflaco » Fri Sep 21, 2012 5:22 pm

billy, ICEMAN is soported in my system.
ottoelflaco
 
Posts: 36
Joined: Fri Sep 21, 2012 2:33 pm
Has thanked: 1 time
Been thanked: 0 time

Next

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post