FB to VB conversion with a split.

IBM's Sort Product, ICETOOL, ICEMAN and ICEGENER.
Previous topicNext topic
User avatar

Topic Author
AD991
Registered Member
Posts: 76
Joined: Wed May 08, 2013 7:36 pm
Zodiac: Sagittarius

FB to VB conversion with a split.

Post by AD991 » Sat Jan 07, 2017 10:47 am

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: 499
Joined: Sun Aug 25, 2013 7:24 pm

Re: FB to VB conversion with a split.

Post by William Collins » Wed Jan 11, 2017 11:17 pm

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

Topic Author
AD991
Registered Member
Posts: 76
Joined: Wed May 08, 2013 7:36 pm
Zodiac: Sagittarius

Re: FB to VB conversion with a split.

Post by AD991 » Thu Jan 12, 2017 2:29 pm

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: 499
Joined: Sun Aug 25, 2013 7:24 pm

Re: FB to VB conversion with a split.

Post by William Collins » Sat Jan 14, 2017 1:37 pm

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

Topic Author
AD991
Registered Member
Posts: 76
Joined: Wed May 08, 2013 7:36 pm
Zodiac: Sagittarius

Re: FB to VB conversion with a split.

Post by AD991 » Wed Jan 18, 2017 10:48 am

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: 892
Joined: Wed Sep 11, 2013 3:57 pm

Re: FB to VB conversion with a split.

Post by enrico-sorichetti » Wed Jan 18, 2017 9:46 pm

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: 499
Joined: Sun Aug 25, 2013 7:24 pm

Re: FB to VB conversion with a split.

Post by William Collins » Wed Jan 18, 2017 11:03 pm

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

Topic Author
AD991
Registered Member
Posts: 76
Joined: Wed May 08, 2013 7:36 pm
Zodiac: Sagittarius

Re: FB to VB conversion with a split.

Post by AD991 » Thu Jan 19, 2017 3:30 pm

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.



Previous topicNext topic

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