OraFAQ Forum: Forms » SQL Loader control

Home » Developer & Programmer » Forms » SQL Loader control

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL Loader control [message #128707]

Wed, 20 July 2005 04:33

bmpando
Messages: 1
Registered: July 2005
Location: Zimbabwe

Junior Member

I would want to upload data using SQL loader. part of my control file is listed below.

WHEN CUSTOMER_TEXT ='PAY'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(CUSTOMER_TEXT POSITION(01:03) CHAR,
BANK_ACCOUNT_NUM POSITION(37:51) CHAR,

I would also want to upload for when customer_text = 'DDB'
I have tried to use OR but it has given me an error , how best can I do this one

Report message to a moderator

Re: SQL Loader control [message #128824 is a reply to message #128707]

Wed, 20 July 2005 17:56

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Next time please show the message and the code that you DID use, not the code from which you started.

I assume that you changed
WHEN CUSTOMER_TEXT ='PAY'
to
WHEN CUSTOMER_TEXT ='PAY' OR 'DDB'

It should be either
WHEN CUSTOMER_TEXT ='PAY' OR CUSTOMER_TEXT ='DDB'
or
WHEN CUSTOMER_TEXT IN ('PAY','DDB')

David

Report message to a moderator

Previous Topic:	filtering in listbox
Next Topic:	PLLs in 9i forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:40:22 CDT 2024