DSXchange

For newcomers: to Suppress "Commit point reached" log add SILENT=FEEDBACK option

like this:

APT_ORACLE_LOAD_OPTIONS = OPTIONS(DIRECT=FALSE,PARALLEL=TRUE,SILENT=FEEDBACK)

you can write start and end times inside your shell script eg: #!/usr/bin/ksh ####################################### # yourshellscript.sh ###################################### sqlplus -s <<EOF test/test@test PROMPT Insert start time into audit table INSERT INTO AUDIT_TABLE (STAR_TIME) SELET SYSDAT...

it worked great.

thanks guys

Hi Iam new to DataStage, can anyone help me how to get the Next avialable Date using DataStage's builtin functions,..etx. Example: Iam using Date format as YYYYMMDD (integer) as a parameter. So if my current parameter is 20060507, then I want next available date as 20060508 like wise for 20060531, i...