How to treat members of a physical file in other databases?

[manty]

Hi,

How do i treat members of a physical file when i migrate from AS400 UDB Db2/400 to other databases say SQL Server or Oracle?
I believe there is no concept of file members there.

Should i take all the data from the main member and all the other members and put it into a single table in the other database?

Would really appreciate any inputs...

Thanks,
Manty.

[FaStOnE]

Re: How to treat members of a physical file in other databases?

Technically, Members are just copies of the physical file. Unless you have a separate way of dealing with them, I would treat them as separate files.

If you have a primary key associated to the data as well as a definition between Members, then yes, you could put them all into a single table.

[kitvb1]

Re: How to treat members of a physical file in other databases?

This may help you. http://www.code400.com/forum/showthread.php?t=5419

One change to the original post: one need not register to get the source.

[manty]

Re: How to treat members of a physical file in other databases?

Thanks all...

Regards,
Manty