FB to VB conversion with a split.

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.
Post Reply
User avatar
AD991
Registered Member
Posts: 92
Joined: Wed May 08, 2013 7:36 pm

FB to VB conversion with a split.

Post by AD991 »

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
William Collins
Global Moderator
Global Moderator
Posts: 490
Joined: Sun Aug 25, 2013 7:24 pm

Re: FB to VB conversion with a split.

Post by William Collins »

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?
User avatar
AD991
Registered Member
Posts: 92
Joined: Wed May 08, 2013 7:36 pm

Re: FB to VB conversion with a split.

Post by AD991 »

William Collins wrote: Can logical records split across physical records?
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.
William Collins
Global Moderator
Global Moderator
Posts: 490
Joined: Sun Aug 25, 2013 7:24 pm

Re: FB to VB conversion with a split.

Post by William Collins »

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?
User avatar
AD991
Registered Member
Posts: 92
Joined: Wed May 08, 2013 7:36 pm

Re: FB to VB conversion with a split.

Post by AD991 »

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.
enrico-sorichetti
Global Moderator
Global Moderator
Posts: 825
Joined: Wed Sep 11, 2013 3:57 pm

Re: FB to VB conversion with a split.

Post by enrico-sorichetti »

But why do you mention 49? Is there some constraint on that number?
How many X'10's can you have? 49? Some lower number?
just a generic placeholder for the number of X'10' to process
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 8-)
William Collins
Global Moderator
Global Moderator
Posts: 490
Joined: Sun Aug 25, 2013 7:24 pm

Re: FB to VB conversion with a split.

Post by William Collins »

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).
User avatar
AD991
Registered Member
Posts: 92
Joined: Wed May 08, 2013 7:36 pm

Re: FB to VB conversion with a split.

Post by AD991 »

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.
Post Reply

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

Register

Sign in

Return to “IBM DFSort, ICETOOL, ICEMAN, ICEGENER.”