DSXchange

Include null handling along with this condition

Why cant you write a simple server routine for this and call in your job.

Instead of using StageVar : Index(Word1,'-',1) can you try with this
StageVar : Index(to_processing.pri_emp_add1,'-',1)

Use Join stage with type as FULL OUTER.

Look for the logs in director for that sequence. It will display the return value.

Do both output links have same column names and data types. (i.e metadata).

Check any new line/extra characters are coming in your output.

Are both versions installed in same Unix server ? ?

There is no need to convert your incoming value to Timestamp. You can keep it as CHAR and load it in your table. For changing ':' to '.' Use convert function.

Check the format of the file that you defined in DataStage with the data present in the file. I think its not matching.

Have the datatype of the parameter where you pass password as Encrypted.

By referring the belwo topic I am closing this.

http://dsxchange.com/viewtopic.php?t=10 ... 9fa27b1597

This is about DB2_UDB load stage. I forgot to mention this.

I am trying to get familiar with DB2_UDB stage using one row to insert in table. But while running I am getting the warning "Warning: DB2BulkLoad.DB2_UDB_Load_0: SQL1325N The remote database environment does not support the command or one of the command options" . Because of that I am not ...

Get all the file names through execute command stage. Use loop stage to process all files one by one by sending the file names.