|
|
| Author |
Message |
cvishu
New User
Joined: 31 Jul 2007
Posts: 58
Location: india
|
|
|
|
HI can we covert column to rows using Sort ?
Eg :
111 2222
333 4444
555 6666
needs to converted to
111 2222 333 4444 555 6666 |
|
| Back to top |
|
 |
References
|
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1149
Location: Bangalore,India
|
|
| Back to top |
|
|
Frank Yaeger
DFSORT Moderator
Joined: 15 Feb 2005
Posts: 6001
Location: San Jose, CA
|
|
|
|
cvishu,
You haven't given enough information. You need to explain the rules you want to use for converting columns to rows. Do you want to convert everything to ONE row as shown in your example? Or some other variation? How many rows can you have - how many columns - how big can the output row be? What is the RECFM and LRECL of the input file and expected output file? What is the starting position, length and format of each relevant field? |
|
| Back to top |
|
|
cvishu
New User
Joined: 31 Jul 2007
Posts: 58
Location: india
|
|
|
|
Lets say , my input is going to be of 80 bytes and o/p can go as fas as the
row size is needed.
Only single row for o/p , so my entire column in the input will be displayed in onle single row in the output.
Also could you please suggest any alternative for SPLICE option , i am not sure its supported in my office environment
Thnks to both of you for ur response  |
|
| Back to top |
|
|
dick scherrer
Global Moderator
Joined: 23 Nov 2006
Posts: 13608
Location: 221 B Baker St
|
|
|
|
Hello,
| Quote: |
| and o/p can go as fas as the row size is needed. |
No, it can't. . .
Everything has a limit. . . |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Moderator
Joined: 15 Feb 2005
Posts: 6001
Location: San Jose, CA
|
|
|
|
| Quote: |
| Also could you please suggest any alternative for SPLICE option , i am not sure its supported in my office environment |
Unlikely. SPLICE has been available with DFSORT since Feb, 2003!
| Quote: |
| Only single row for o/p , so my entire column in the input will be displayed in onle single row in the output. |
Too vague to answer. If you can't give a better description of what you want to do, then I can't help you. |
|
| Back to top |
|
|
cvishu
New User
Joined: 31 Jul 2007
Posts: 58
Location: india
|
|
|
|
| dick scherrer wrote: |
Hello,
| Quote: |
| and o/p can go as fas as the row size is needed. |
No, it can't. . .
Everything has a limit. . . |
ok my input is going to have 30 columsn and the size of each colum is 10 byts so i need a output with record length 300 byts |
|
| Back to top |
|
|
Lijo
New User
Joined: 24 Aug 2008
Posts: 41
Location: Cochin
|
|
|
|
Hello,
| Quote: |
| ok my input is going to have 30 columsn and the size of each colum is 10 byts so i need a output with record length 300 byts |
Doesn't this mean i/p is of 300bytes???
So, your output will be 300bytes*no of rows in i/p???
I wonder how a project can have such strange requirement  |
|
| Back to top |
|
|
cvishu
New User
Joined: 31 Jul 2007
Posts: 58
Location: india
|
|
|
|
| Quote: |
| ok my input is going to have 30 columsn and the size of each colum is 10 byts so i need a output with record length 300 byts |
OOPS !! My bad !! 
its actally 30 rorws in input the length of each row is 10 bytes , so output is
10*30 =>300 byts
eg:
aaaaaaaaaa
bbbbbbbbbb
.
.
.
zzzzzzzzzzz
Hope am clear now. |
|
| Back to top |
|
|
Skolusu
DFSORT Developer
Joined: 07 Dec 2007
Posts: 961
Location: San Jose
|
|
| Back to top |
|
|
cvishu
New User
Joined: 31 Jul 2007
Posts: 58
Location: india
|
|
|
|
Skolusu
Thank you |
|
| Back to top |
|
|
|
|
