SQL Loader question
From: Scott Mattes <smattes_at_erols.com>
Date: Wed, 17 Feb 1999 15:57:12 -0500
Message-ID: <36CB2D28.423413D8_at_erols.com>
I can not test on a real system yet (and believe it or not, my Oracle guru just died from injuries suffered in a car crash last week), but while I wait I am creating a utility to take in COBOL copylib members and create load statements.
Scott Mattes
ICQ: 18330579
Work: Scott.Mattes_at_Wang.com
Home: SMattes_at_Erols.com Received on Wed Feb 17 1999 - 21:57:12 CET
Date: Wed, 17 Feb 1999 15:57:12 -0500
Message-ID: <36CB2D28.423413D8_at_erols.com>
I can not test on a real system yet (and believe it or not, my Oracle guru just died from injuries suffered in a car crash last week), but while I wait I am creating a utility to take in COBOL copylib members and create load statements.
[Quoted] How do I specify the datatype of a field that is 9(5)v99 (hence the data
looks like 99999 in the source file)? I am guessing for right now that I
would say
DECIMAL EXTERNAL(5) (but, how do I tell it the precision - we need 2?).
Or, can I do INTEGER EXTERNAL(5) and use some function (at load time) to
divide it by 100?
Thank you.
Scott Mattes
ICQ: 18330579
Work: Scott.Mattes_at_Wang.com
Home: SMattes_at_Erols.com Received on Wed Feb 17 1999 - 21:57:12 CET