DSXchange

I was able to use \x8F (delimiter is hex 8F) in delimiter string and can view the data, but can't use this string in delimiter.

Hi, I wants to connect to Db2 database on remote server (OS linux) using datastage 7.5.1.A version installed on windows server. Please let me know what all configurations needs to be done. I checked for .odbc.ini file which is not present in datastage server. Checked the uvodbc.config and added the ...

The data on which I am working is not cleansed data. I am cleaning and applying transformation rules in transformar. e.g my address detail tables, 'C/O' string is inputed as 'C / O','C.O','C/ O','C/ '. I am finding all the occurances of these, replacing it with stanard format and based on these, i a...

I am getting error below while compiling datastage job. I am using very long expression in transformer, I have no other option than using it. Is there any solution for this issue. Compiling: Source = 'RT_BP48/JOB.1381947501.DT.1408851130.TRANS1', Object = 'RT_BP48.O/JOB.1381947501.DT.1408851130.TRAN...

Hi,
I have created Batch Job using DataStage Director to run the jobs in a sequence. Can anybody know how to pass parameter from Batch Job to It's Underlaying job. In this case I don't want to user DataStage Sequencer.