DSXchange

Error says : parallel load requested and XYZ has enabled triggers or constraints

Is there any way to load records into non empty existing tables with constraints, triggers enabled? In this case I'm loading(Append) records into table. With no option to disabling constraints and rebuilding index.


Any help greatly appreciated.


Thank you.

use to_date('dd-mm-yyyy') in user defined sql

thanks for your reply

I can try that, that raised one more doubt. If I have multiple scripts can I do like this way: "/export/home/project/shell.sh; /export/home/project/shell2.sh"

I have a complex stored procedure I created shell script to call it on unix box. I'm little confused how to integrate the script in job properties to run it after the job. This is what I did: In After -job subroutine I selected ExecSH and provided the script path as /export/home/project/shell.sh I w...