Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Syncsort VB field Pull

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Barbara

New User


Joined: 21 Jan 2009
Posts: 8
Location: Baltimore, Md

PostPosted: Wed Jan 21, 2009 11:30 pm    Post subject: Syncsort VB field Pull
Reply with quote

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
View user's profile Send private message

Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2287
Location: @my desk

PostPosted: Wed Jan 21, 2009 11:39 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Barbara

New User


Joined: 21 Jan 2009
Posts: 8
Location: Baltimore, Md

PostPosted: Wed Jan 21, 2009 11:51 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Thu Jan 22, 2009 9:05 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Barbara

New User


Joined: 21 Jan 2009
Posts: 8
Location: Baltimore, Md

PostPosted: Mon Jan 26, 2009 7:52 pm    Post subject:
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8619
Location: Back in jolly old England

PostPosted: Mon Jan 26, 2009 8:35 pm    Post subject:
Reply with quote

Errrrmmmmmmmmmm I think that Arun and Alissa meant a graphical example rather than commentary
Back to top
View user's profile Send private message
Barbara

New User


Joined: 21 Jan 2009
Posts: 8
Location: Baltimore, Md

PostPosted: Mon Jan 26, 2009 8:38 pm    Post subject:
Reply with 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.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8619
Location: Back in jolly old England

PostPosted: Mon Jan 26, 2009 8:44 pm    Post subject:
Reply with quote

Couldn't you just use your imagination icon_eek.gif

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Jan 26, 2009 10:15 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Barbara

New User


Joined: 21 Jan 2009
Posts: 8
Location: Baltimore, Md

PostPosted: Mon Jan 26, 2009 10:18 pm    Post subject:
Reply with quote

Thank you for your help
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2287
Location: @my desk

PostPosted: Tue Jan 27, 2009 12:53 am    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Incrementing current time field by 30... arunsoods DFSORT/ICETOOL 11 Thu Oct 26, 2017 3:22 pm
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts Partial color change of a field in CI... waseem0424 CICS 5 Fri Sep 29, 2017 7:56 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts Remove leading spaces from numeric field rexx77 SYNCSORT 6 Wed Sep 06, 2017 2:15 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us