Use two functions - Control file 1

[AlStl]

Hi,

How can I use two functions against single data field. Ex:

Flat file look like this:

Name, Address, Last_automobile
XXXX ,2222 , Honda
YYYY, 3333 ,NULL

Control file:

Name RTRIMName),
Address TRIMAddress),
Last_automobile RTRIM (NULLIF (Last_automobile='NULL'))

Last line is not working and causing an error. How can I use RTRIM or TRIM & NULLIF together ?

thx,

Al

 

[Thargy]

I would suggest that you use external tables instead of SQL loader.
That way you have the full power of SQL at your disposal when loading the data.

Regards

T

 

[taupirho]

You should use something like this


automobile NULLIF automobile ='NULL' "rtrimautomobile)"


In order to understand recursion, you must first understand recursion.

 

[AlStl]

taupirho & Thargy.

Thanks for your suggestions.

taupirho, your idea worked well for me. Thx a lot !!

Marking your post as valuable.

Al