Plz advice on problem

bobby · Post by **bobby** » Tue Jan 11, 2005 11:36 am

MY SOURCE IS

RECORD_ID IRD_NO FROM_LOC TO_LOC
2946632 R0022241458 8455100600889092 900270001
3165011 R0022241458 900270001 8455100622188010
3168849 R0022241458 911060001 8455100622188010

Target should look like

RECORD_ID IRD_NO FROM_LOC TO_LOC
2946632 R0022241458 8455100600889092 900270001
3165011 R0022241458 900270001 8455100622188010
seqno R0022241458 8455100622188010 911060001
3168849 R0022241458 911060001 8455100622188010

i want to create a fictious record between RECORD_ID 3165011 and 3168849 so as to plug the differnce. what approach should i follow

Thanks
Bobby

wnogalski · Post by **wnogalski** » Tue Jan 11, 2005 12:54 pm

I would try to create a routine which iterates thru the sequential file and if a proper condition is satisfied a fictious record is created.
Firstly the records may have to be sorted.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 11, 2005 3:42 pm

What is your specification of the conditions under which a fictitious record is to be inserted?

Do you have a full specification of the requirement? If so, please share that, too. If you don't understand the problem fully, and ask us to solve a portion of it, then the "help" may not end up being very helpful.

In a similar vein, can you please try to create more meaningful subject lines for your posts? The subject line is the primary means for finding appropriate posts using the Search facility. A subject like "plz advice on problem" is unhelpful on a number of levels.