Can we Use TRIM funtion in fastload script?

Tools & Utilities
Enthusiast

Can we Use TRIM funtion in fastload script?

Hi all,

Need your inputs....

One of my friend has written a fastload script and he included TRIM function for few fields and when tried to execute.... he got the error msg :RDBMS error 3618: Expression not allowed in Fast Load

could someone please explain how to use trim function in fastload script?

script is something like....

insert ( a,b,c)
VALUES
( : trim(a),b,b)

field 'a' is defined as varchar(1)
2 REPLIES
Enthusiast

Re: Can we Use TRIM funtion in fastload script?

script is something like....

insert ( a,b,c)
VALUES
( : trim(a),b,b)

field 'a' is defined as varchar(1) )

try like this

insert (a,b,c)
values

(:trim(a),
:b,
:c
)
Enthusiast

Re: Can we Use TRIM funtion in fastload script?

I am having a similar problem trying to use COALESCE with the same error. Putting the ":" in the front does not solve the problem as the previous poster suggested trying. Anyone else have ideas?

ss

---------

VALUES ( :ACCOUNTNUMBER,
:TYPE_ID,
:LASTFMDATE,
:OPENDATE,
:CLOSEDATE,
:BRANCH,
COALESCE(:RESTRICTACCESS, ''),