DSXchange

i think this is not a valid sysntax..please give me the correct one

I have some NULL and empty values in column of file. I want to replace both of the values to some numeric value. I can replace a NULL with a value but i cannot for the empty one. Iam using If then else in datastage. Can anybody help me.

should i do it manually?....In datastage i have set the quote as double.

I have 55 columns in the file and only 2 columns have the problem. i.e., they are getting rejected. how can i set the delimiter for these two columns. delimiter is used for the whole file.

I have connected to a db2 database from datastage and taken the output of a table to a sequential file. Now iam using this sequential file as an input for another job. But iam geeting lot of warning saying that some data is rejected. The errors iget look like the following: Personnel,0: Field "...

Can anybody please tell me the meaning of the following warning:


Sequential_File_2: When checking operator: When validating export schema: At field "MOVE_JOB_ACTION": Exporting a fixed length field with a "null_field" of length 0 will prohibit a re-import of this field

I have 55 columns in my db2 file. Now the job running since i removed the extended type (unicode) for all the columns. In this file i have also some timestamp columns. Physically i got an output sequential file created. but when i try to view data from data stage i get this error. ##E TOIX 000139 08...

these are the error iam getting: DB2_UDB_API_10,0: Info: DB2_UDB_API_10: Using NLS map ISO-8859-1 DB2_UDB_API_10,0: Field type must be string in order to call setOutputFieldAsString() for field '37' in output dataset '0'. (fatal) DB2_UDB_API_10,0: Operator signalled one or more errors.(fatal) DB2_UD...

i have tried to change the extended code....but still it is not working.

I have created a prallel job in which i have source db2 connection, a transformer and a sequential file as output file. I just want to get the data from db2 source into a sequential file without any transformation. When i try to run the job, i get the following error. DB2_UDB_API_10,0: Field type mu...

samsuf2002 wrote:check the data types for the fields in source file

Iam using a column name called SSN and i defined it as an integer. since SSN has 9 digits.....it is automatically taking the length as 10. and iam using only one this column as input.

Hi ...Can anybody please tell me how i should view the data from the properties of a sequential file in a parallel job. What iam doing is i used a sequential file to extract data, sort it and load the data in an sequential file. But iam not able to see the data in the input file. when i compile ther...