Home » RDBMS Server » Server Utilities » Sub Parsing data in Variable len delimited
Sub Parsing data in Variable len delimited [message #69348] Wed, 12 December 2001 15:11 Go to next message
Tom Feehan
Messages: 1
Registered: December 2001
Junior Member
I have a control card like:
LOAD DATA
APPEND
INTO TABLE AFF
FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
RCRD_NBR RECNUM,
ID ,
CD ,
A_NBR "SUBSTR(REPLACE(REPLACE(REPLACE(REPLACE(:NBR,' '),')'),','),'-'),1,3)",
B_NBR "SUBSTR(REPLACE(REPLACE(REPLACE(REPLACE(:NBR,' '),')'),','),'-'),4,3)",
C_NBR "SUBSTR(REPLACE(REPLACE(REPLACE(REPLACE(:NBR,' '),')'),','),'-'),7,4)"
)

I get an error msg "variable unbound". I want to keep the input variable length ( not fixed position), but want to parse the one field. Any ideas?

----------------------------------------------------------------------
Re: Sub Parsing data in Variable len delimited [message #69357 is a reply to message #69348] Fri, 14 December 2001 07:40 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
i didnt see NBR field in control file. what is your requirement exactly?

----------------------------------------------------------------------
Previous Topic: Selective loading of data using SQL Loader
Next Topic: SQLLDR and time
Goto Forum:
  


Current Time: Fri Mar 29 02:02:05 CDT 2024