FB to VB conversion with a split.
FB to VB conversion with a split.
Hi
For one of the requirment, I wanted to copy a FB dataset to new file of RECFM VB. But while copying I need to split the any existing record, to a create a new record, on every occurance of x'10'. Can someome please guide me on this. Thanks
For one of the requirment, I wanted to copy a FB dataset to new file of RECFM VB. But while copying I need to split the any existing record, to a create a new record, on every occurance of x'10'. Can someome please guide me on this. Thanks
-
- Global Moderator
- Posts: 490
- Joined: Sun Aug 25, 2013 7:24 pm
Re: FB to VB conversion with a split.
How many records may there be? Record-length? Can logical records split across physical records? Where do the X'10' come from? Why can't the split be done there?
Re: FB to VB conversion with a split.
Can you please explin it again?
103 records for test data and that much we anticipate. Record-length is 100 for both input and output.
-
- Global Moderator
- Posts: 490
- Joined: Sun Aug 25, 2013 7:24 pm
Re: FB to VB conversion with a split.
You want to split records based on X'10'. For the final X'10' on a record, does all the data follow on that same record, or is there some data on the next record.
How many X'10's can you have? 49? Some lower number?
How many X'10's can you have? 49? Some lower number?
Re: FB to VB conversion with a split.
We can have around 21 X'10' not more than that. But why do you mention 49? Is there some constraint on that number?
For final record there can be some dara on next record.
For final record there can be some dara on next record.
-
- Global Moderator
- Posts: 827
- Joined: Wed Sep 11, 2013 3:57 pm
Re: FB to VB conversion with a split.
But why do you mention 49? Is there some constraint on that number?
just a generic placeholder for the number of X'10' to processHow many X'10's can you have? 49? Some lower number?
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
-
- Global Moderator
- Posts: 490
- Joined: Sun Aug 25, 2013 7:24 pm
Re: FB to VB conversion with a split.
You said you have 100-byte records. 100/2 = 49 (since you didn't say if that was F or V records).
The "limit" is the number of "records" which can logically exist. If the smallest record, including the X'10', is 10 bytes, you could have a maximum of 10 per records (assuming F, else nine per record if V).
The "limit" is the number of "records" which can logically exist. If the smallest record, including the X'10', is 10 bytes, you could have a maximum of 10 per records (assuming F, else nine per record if V).
Re: FB to VB conversion with a split.
100/2=50, is not it?
I think I got you wrong last time and if I'm getting you correctly now, in a record, only one occurence of X'10' is possible.
I think I got you wrong last time and if I'm getting you correctly now, in a record, only one occurence of X'10' is possible.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute