DSXchange

I did not use any stage variables.. I know how to handle it using MLOAD but as of now I am using fastload..

Thanks Ray, as I mentioned it is Decimal (8,0).. is it okay if I have a non zero value in precision?

I receive error "Parsing parameters "0,0" for schema type "decimal": Precision must be > 0 and <= 255" while compiling the job I have source field CODE_ID as decimal (8,0) in oracle and target as CODE_ID as decimal (8,0) in teradata with fastload utility as the table is...

I did that in a custom defined server routine and calling it as before job sub routine

I checked the form and found the syntax

"Call DSExecute('UNIX',Script A,Output,Error)"

I am using following :

Call DSU.ExecSH("/export/ds/xyz/abctest.sh", ErrCode)
If ErrCode <> 0
Then Call DSLogFatal("failed", rtnName)


am i doing the right way?

I have BTeq script in a routine activity sequence, based on the return value how can I fail the Sequence?

I understand the insert fails and update went good, it could be possible cause of violation of constraints. It shows up in the log and here the case is failure of inserts so it should be saved in the log

If it is is Windows check the installation folder, IBM/Information Server/Server/Scratch

can you identify the cause for that by spliting the job into 2 jobs, do insert in one stage and then update later or vice versa? that could get you to the core cause.

Parallel loading into oracle table with indexs will make break indexs, you have to use conventiaonal way to load into that, you can use environmental variable APT_ORACLE_LOAD_OPTIONS = OPTIONS(DIRECT=FALSE,PARALLEL=FALSE)

In Job properties-->environmental variable--->Operator Specific---> APT_ORACLE_LOAD_OPTIONS(right now the Value box is empty) and set the values as (DIRECT=FALSE,PARALLEL=FALSE)

Enter Environmental variable APT_ORACLE_LOAD_OPTIONS as (DIRECT=FALSE,PARALLEL=FALSE) and do not provide any index options at load. That should work.

I figured it out, thank you!!!

Thank you for the help, to switch to a conventional load (DIRECT=FALSE) is that a datastage option or an oracle setting?

Complete Error:

SQL*Loader-937: Parallel load requested and XYZ has enabled triggers or constraints.

Thank you.