I am involved in a project where we will be moving mainframe data (from
Unisys DMSII) to Oracle for data warehousing. DMSII supports
variable-length records, where the length will depend on the type of
record. For example, a note might be a payment, which would have
payment amount and some other info, or a comment, which would have
different text info, etc.
There is a fixed portion to the record, a record type, and then the
variable portion. There are about 20 different types of records. Is
there a way to do this in SQL? It is important that this all be in one
table so that it can be searched in order.
Received on Wed May 26 1999 - 05:53:13 CDT
