Re: SQL*loader and variable recs

From: Bill Manry - IBM SBU <bmanry_at_upsizeme.us.oracle.com>
Date: 23 Aug 1994 01:04:10 GMT
Message-ID: <33bhua$ejm_at_dcsun4.us.oracle.com>


In article <33av43$jun_at_marlin.ssnet.com>, Joe Minnich writes:
|> Has anyone used sql*loader to take apart a very messy
|> cobol output file that contains many redefines, etc. ?
|> If you have what type of success/problems did you
|> encounter? Is sql*loader to tool to use ?

The major problem in loading such files is determining how you want to structure the data in relational terms. Several RDBMS tables may be required to provide a reasonable relational model for your data. The Loader control file syntax is complete enough that most records can be decomposed by repeated INTO TABLE clauses as long as remapped (COBOL "REDEFINES") sections can be distinguished with explicit data tests such as "WHEN (RECORD_TYPE = 'C') AND ((38:39) = X'01E7')". Variable repeating fields (COBOL "OCCURS DEPENDING ON") can be tricky but also can be handled.

/b



Bill Manry
Oracle Corp. / Mainframe & Integration Technologies / BManry_at_us.oracle.com #include <disclaimer.usual> Received on Tue Aug 23 1994 - 03:04:10 CEST

Original text of this message