|
View previous topic :: View next topic
|
| Author |
Message |
Barbara
New User
Joined: 21 Jan 2009
Posts: 8
Location: Baltimore, Md
|
|
|
|
I need to pull records from 10 states. the lrecl = 13004, recfm=vb, and there are re-occurring fields. The re-occurring fields have an fixed indicator field that tell you how many times the reoccurring field will be populated.
How do I get to the data is these fields? |
|
| Back to top |
|
 |
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
Hello and welcome to the forums.
It's not clear what you are trying to do. Could you please explain with a few sample input records(showing relevant fields) and the expected output out of it. While posting data use the "Code" tag provided here for better readability. |
|
| Back to top |
|
|
Barbara
New User
Joined: 21 Jan 2009
Posts: 8
Location: Baltimore, Md
|
|
|
|
1) I need to pull all data for NY, DC, GA. This data can be found in a field on the record that occurs up to 13 times.
2) There are five other fields that can occur from 3 to 13 times.
and pull the record.
3) All re-occurring field have a indicator field that will tell you how many time the re-occurring field will re-occur. These indicators are in the fixed prosion of the record.
My problem is, how do I locate this field show the state?[/code] |
|
| Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007
Posts: 496
Location: USA
|
|
|
|
Barbara,
As Arun had previously stated, it would be more helpful if you could provide some sample input records and the desired output.
Thank you. |
|
| Back to top |
|
|
Barbara
New User
Joined: 21 Jan 2009
Posts: 8
Location: Baltimore, Md
|
|
|
|
| I have a record with six arrays in it. I a an array indicator field that tell me how much of the array has data in it. I need to pull data from the 4th array on the record. This is the travel state code field. This can have up to 13 occurence. of this field Does this help?? |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| Errrrmmmmmmmmmm I think that Arun and Alissa meant a graphical example rather than commentary |
|
| Back to top |
|
|
Barbara
New User
Joined: 21 Jan 2009
Posts: 8
Location: Baltimore, Md
|
|
|
|
| I can not send a sample of the data the gov will not let me do that and the record is too long to make up something. |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
Couldn't you just use your imagination 
It doesn't have to be the actual all singing dancing live data, just a graphical representation of the way that the records are laid out, what format the fields are in, just to clarify to those that wish to help you.
Maybe something like ..........
pos 390 field occurs indicator PD 2bytes
pos 392 fields 1-n character 10 bytes
And then explain the situation. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| I can not send a sample of the data the gov will not let me do that and the record is too long to make up something. |
Basically a "cop-out". . .
If you are unwiling to do a bit of work to present somthing that reflects your requirement no one should post anything in reply. . . If anything other than a better explanation/definition of the requirement is posted, it will be deleted until the explanation/definition is posted. When you create sample data, it does not need to be "full-size" only enough to show the requirement. You need to post some sample input records and the output you want when these sample input records are processed. |
|
| Back to top |
|
|
Barbara
New User
Joined: 21 Jan 2009
Posts: 8
Location: Baltimore, Md
|
|
|
|
| Thank you for your help |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
Barbara,
You dont really need to post the 'actual' data. If you could just prepare some dummy input records and post it here along with the expected output, it might help us to help you. Good luck. |
|
| Back to top |
|
|
|
|
