DSXchange

Thanks a lot for your time and replies. If Trim(column) = ' ' Then '' Else Trim(column) I have tried the above option. However, I'm still getting the whitespaces. What are the data types in your job for the fields in question? Two output fields are defined as character datatype - length(20) One othe...

I'm using @INROWNUM funtion in one of the columns and rest other column derivations are included with Trim functon in the transformer stage prior to DB2 UDB API output stage. The output table has all the columns defined as NOT NULL. The job is working fine, except that extra spaces are getting inser...

Great!! Working fine. Thanks a lot......

The input column is defined as INP_Col, char(30). The output column which is mapped to INP_COL column is also defined as char(30). I am confident that both input and output columns would contain only numeric value. I need to subtract an integer value from the input column (INP_Col,char data type) an...

Thanks

Thanks

The DB2UDB API target has view data option on Input tab --->view data button. I fixed this problem now. Thanks a lot.

Yes my job is working fine. Thanks a lot for your kind help.

The columns col#_1 and col_data_1 that are defined in the inputs vary in number. If I hard code these columns in pivot stage the job would work for one input but the same would fail for another. Therefore, I'm looking for an option that can make this job suitable for many possible inputs. Say, for t...

There is a scenario where the row values Col1 | col#_1| col_data1| col#_2 | col_data_2| col6| col_data_3 100 | 1 | Z | 2 | Y | 3 | X Using Pivot stage I'm able to achieve the output C1 C2 C3 C4 100 1 Z A 100 2 Y A 100 3 X A There are various inputs where the input columns Col#_1 and Col_data_2 may e...

Thanks for your reply. Source DB2 stage - Query Type Generate SELECT clause from column list; ... I can view the source data using View Data... option. Input date is shown as : 14641 (2008-01-31) Input column data type is Date and length is 4. The same data type and length are defined in output DB2 ...

In my job Input Column : Date_In DataType : Date Length : 10 Output column : Date_out Data type : Date length : 4 Its a one to one mapping from source to target. Target is a mainframe table in DB2. I am using a DB2 UDB API stage. When I tried to view the output from the target DB2 the following erro...

Yes the target field allow null values.

When I insert rows from pivot to DB2 UDB API stage the performance statistics shows 3 rows. However, only 2 rows are getting inserted into DB2 stage. I tried replacing DB2 API stage with a Data Set stage. I am able to get 3 records as Data set output without any issues. Data Set : output col1 col2 c...