DSXchange

may be you have some restricted warning limit and when the limit cross the job will fail this error.

You have not handled the null value for the fields DESCR
probably in the transformer stage.

to know at which stage, disable the combination

its not a weird error.
what is bad record or error limit, you have set.

it is quite simple. read the whole string with quotes (in the file stage set quote=none) and then in a transformer stage trim the " .

Trim(<column name>,'"')

'"' is single quote:double quote:single quote

your input data is wrong.
have a reject link in the oracle stage, so all correct data will be loaded and you can filter out the wrong data

in datastage director

Project--->Print--->print to file

do you have any file or link for orchoracle at $APT_ORCHOME/lib

Error loading "orchoracle": Could not load "orchoracle": Unable to find library 'libclntsh.so.10.1'.

do you have the orchoracle softlink in your $DSHOME/../PXEngine/lib or $APT_ORCHOME/lib path

date format i have set is dd-mm-yyyy,...so now if date comes as 1/12/2001..its getting dropped

so the job is doing what it is supposed to do.

that is because your date field has a value "null". i think the file has "null" for null field value, so that should be either defined at record level or the column level. record {final_delim=end, delim=',',null_field='null'} ( Emp_ID:string[max=200]; Emp_status:string[max=100]; ...

num(<column name>) is true then real number

doesn't your earlier query regarding this help you http://www.dsxchange.com/viewtopic.php?t=121506 anyway it could be like: record {final_delim=end, delim=','} ( Emp_ID:string[max=200]; Emp_status:string[max=100]; Start_Date:string[max=26]; Position:string[max=100]; Remarks:string[max=1000]; )

if it is working fine then correct option only :D

first of all disable combination. and then check if you have write permission to the output directory path

use head stage and number of records 1.