View previous topic :: View next topic
|
Author |
Message |
Hemamalini Vasudevan
New User
Joined: 21 Sep 2006 Posts: 5
|
|
|
|
I have a input file which contains 48 field, but of different length.
It could be of great help if this 48 fields are written into a single dimension table with 48 as occurs clause.
For example ,
INPUT-FILE
Name pic x(10)
status pic x(1)
Table
Det occurs 2 times pic x(10)
and i want the usage like
Det(1) as name
det(2) as status.
How do i go about this, is this possible?
Please advice. |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
Read the record....
Move the fields....
Where is the confusion? |
|
Back to top |
|
|
Hemamalini Vasudevan
New User
Joined: 21 Sep 2006 Posts: 5
|
|
|
|
File has 48 fields , Instead of manually moving, any other way !!!!! |
|
Back to top |
|
|
sandeep1dimri
New User
Joined: 30 Oct 2006 Posts: 76
|
|
|
|
Hi
what i understond is that u have varible length fields and u want to store these fields into an array. For examp if data is like
aa
aaa
aaaa
aaaaa
bb
bbb
Then u can have an array of lenght 48 and data type as per the hightest length of field you have. For my exa
data-array of length 6 with x(5) so that it can store my hightest length of
'aaaaa' .
Ples correct me if was wrong at understanding |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Please clarify this
Quote: |
File has 48 fields , Instead of manually moving, any other way !!!!! |
You know exactly what you mean, but many of the people here do not.
If use examples it will help.
Does each record have 48 fields? Are they delimited?
If they have different lengths in the same record, how do you know one field from the next?
How does the occurs 48 relate to the occurs 2?
If you more clearly define what you have and what you want to do with it, we will be able to offer suggestions. |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
are you looking for a MOVE CORR that will work for you? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Or possibly an UNSTRING. . . .
We won't know until more info is posted. . . . |
|
Back to top |
|
|
|