Page 1 of 1

FB to VB conversion with a split.

Posted: Sat Jan 07, 2017 10:47 am
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

Re: FB to VB conversion with a split.

Posted: Wed Jan 11, 2017 11:17 pm
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?

Re: FB to VB conversion with a split.

Posted: Thu Jan 12, 2017 2:29 pm
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.

Re: FB to VB conversion with a split.

Posted: Sat Jan 14, 2017 1:37 pm
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?

Re: FB to VB conversion with a split.

Posted: Wed Jan 18, 2017 10:48 am
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.

Re: FB to VB conversion with a split.

Posted: Wed Jan 18, 2017 9:46 pm
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

Re: FB to VB conversion with a split.

Posted: Wed Jan 18, 2017 11:03 pm
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).

Re: FB to VB conversion with a split.

Posted: Thu Jan 19, 2017 3:30 pm
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.