DSXchange

Anybody know how can i retrieve th SQLCODE when i using an Oracle loader ? Because i must load one table who i know have indexes but i'm loading with OPTIONS(DIRECT=TRUE,PARALLEL=TRUE,ERRORS=0,SKIP_INDEX_MAINTENANCE=TRUE) and in production enviroment i get the below error: Time : Fri Jul 10 10:27:10...

ok thanks for the help...

Internal Error: (0):util/pathutils.C: 349:

But my problem such as i understand it wasn't in traceback...but is in "Unable to determine current working directory! This very likely due to a problem with file permissions on the directory or directories above this point. The error was Permission denied " and i try to search something a...

Sorry but i didn't understand this answers...

OK Thank's for all.

ok. but tis solution doesn't increase my number each row ? because i don't want it.

Can't i make an Oracle stage to select max(PROCESS_ID) and on Transformer i increase +1 ?

Hi all,

I must insert on my table an dynamic number called by PROCESS_NUMBER. So this number must be different each time i run my DS job.

Any idea ?

Hi all, When i run my job on production enviroment. I get the below error. But i want to know how i know what directory the job is trying to use ? Unable to determine current working directory! This is very likely due to a problem with file permissions on the directory or directories above this poin...

Only for explain the solution:

in Development the parameter APT_STRING_PADCHAR = 0x00 and in the Production enviroment the parameter APT_STRING_PADCHAR = 0x20. So the Data Stage expects a Null character at the end of string in Production.

thanks for all

up