DSXchange

I have defined a constraint in the Transformer len(ProductID) <> 0 (simple) I have a reject link pointing to reject file ..but the reject file is not made. the constraint page in my transformer does not have Reject Rows tab is this the reason why ..the reject file is not made though I can catch the ...

Yes my problem is solved the query was wrong ...

I am getting this error for any query type...

HI I am using DB2UDB as a look up (Not the enterprise but the plain one) in that I am using Enter custom sql statement as a query option ..and Iam getting following error.. D_Product,0: Fatal Error: Fatal: [IBM][CLI Driver] CLI0100E Wrong number of parameters. SQLSTATE=07001 DSTAGE-DB2CLI-0027`:`SQL...

actualy this is the requirement ..I need to show that the data coming from source file is valid..

My source is a .csv file which I am reading from sequential stage
I guess I will need to validate them in transformer stage..
my target is a DB2 stage

Hi

My source columns are varchar ,decimal and Numeric
how can I validate them in transformer...

How can we create an .xls file in Datastage??

I want to convert a date like 22Feb11 which is varchar in source to date datatype in format YYYYMMDD ..I know I must use stringtodate ...

but what formating i shud use?? I have used

StringToDate(DSLink100.PalanedDeliveryDate,"%yyyy-%mm-%dd")

but its not working..

Thanks abhilash and iHijazi :D I will mark this topic as resolved

ok the date column problem is solved by setting it to varchar .. but I have three decimal columns which have null values in the source ..I am able to view it when I set it as varchar ..but not as decimal.. can anyone tell how i can set default value in sequential file stage for those columns ..so th...

Hi

In my source .csv file the Date is in format ddmonyy ..I tried viewing the file through sequentialstage by giving it datatype Date,timestamp and NUmeric ..but I am not able to view it

what data type should i set so that i can view it ..can it be varchar ..

I am using a simple sum function ..adding salary of employees..

Hi I have all the columns non -nullable throughout the job .and they are set as nullable No through out still I am getting this warning.. Converting a nullable source to a non-nullable result; a fatal runtime error could occur; use the modify operator to specify a value to which the null should be c...

well yes it is a Datastage question ...
In the past I had implimented this ..but now I have forgotten