DSXchange

Thanks a lot nripendra . It's working fine

Iam having another requirement .

The double must be appended to starting and end of each row

Hi, Iam having a sequential file with following two columns SHPDATE column with data 20080202 of varchar (8) SHPTIME column with data 1825 of varchar (4) Both the columns should be concatenated and map to target column SHPTM of timestamp datatype and data should be of 20080202182500 Please suggest m...

hello I have a datastage job which processes the file stocks.dat. i can expect the size of the file to be of zero bytes some times. In the cases datastage process the file stocks.dat with success with zero records imported and i produce a out put file with zero bytes. My problem is i want the datast...

Hi In my job i am producing two rejectfiles with same filename for both the rejectfiles. The file write mode for both of them is Append. The data to the two reject files varies. In the end it seems like i am missing some data in the final reject file. once I have given the different file name for bo...

Hi I have a sequentialFixedwidth file from which i am extracting a field on which i want to do nullhandling. I am using a function IF IsNull(In.Column[2,20]) Then NullToValue(In.Column[2,20], " ") Else In.Column[2,20] Its throwing compilation error. Does datastage recognizes null values ou...

Hello I have fixed with file as source in which there were couple of fields which were defined as Integer datatypes and right justified with leading spaces. Is it a common practice to have integer values as right justified. If i want to make the integers as left justified in the target file, is ther...

Ray . It's working fine.

Can you share the information about the available options for dsjob command.

Regards,
dodda

Hi, I wrote the below script to know the information about sequential file that i used in my job. eval $DSHOME/bin/dsjob -lstages DESRMNA4 testdup Sequential_File_2 Where DESRMNA4 is the project name and testdup is my job name. when i tried to execute the script, it is displaying the following error...

Hi, I have a input file .txt, which has a column QT of integer type of length 6. The input data for QT is like 888 3456 12 And i want to map column QT to QTY with leading zeros and the target column QTY should also be Integer type of length 6 My desired ouput should be like 000888 003456 000012 Can ...

thanks ray that solved my problem

Hello I have a column QT defined as varchar data type. QT will be having values like QT 12 124 89765 3456 ...... QT could be of any length up to varchar(6).I need to map QT to QAT. QAT should look like QAT 000012 000124 089765 003456 QAT should be of 6 character length with zeros infront. Any ideas ...

hello i have a delimited sequential file as source and i need to produce fixed width file. my problem is i have a column called DEP which holds same values (all values in the column are 111) DEP(column name) 111 111 111 111 111 and i need to produce a fixed widht sequential file with DEP columns val...

I have one problem...We are unable to connect datastage ...If we try to connect datastage it displaying following error...

THE CONNECTION HAS TIMED OUT(81017) like that.....
How to resolve this error kindly tell me about that error[/b]