DSXchange

Hi Craig,

Thank you for your response.

the maximum number of columns are 150 columns.

Thanks and Regards,
Cheru.

Hi, Very good wishes to all! Could you Please assist on the question on Datastage technically for the below question. My question: Source file: Field1 Field2 Field3 abc 12f sLm 1234 hjd 12d Hyd 34 Chn My target file should generate the record count on field wise as below: Field1 has 4 values and fie...

Hi, My application is reading fixed width data file thru sequential file stage with file pattern read method. The stage refers a schema file as shown below. Can anyone tell me the meaning of width in {} against the fields ? record {record_delim='\n', record_length=fixed, charset='UTF-16LE', delim=no...

Hi, Please find the query below. Datastage = 8.5 (Parallel) OS = windows. Source data: ename,deptno,company,mobile rajesh,swami,10,IBM,99999 Expected output to be as shown below: ename = rajesh,swami deptno = 10 company = IBM mobile = 99999 Please suggest how to set the formate as comma delimer in s...

Thank you for your help and time.

Thank you for the reply...

I want 30 days old date..

for example today is : 26-04-2013

output should be : 27-03-2013 (which is 30days old date)

Please help on this.

Hi,

Please help how to get 30 days old date from current date .

Thanks and Regards,

My Source is a .txt File.

thanks and Regards,

Hi, I have a requirement as shown below: Input Records: Coulmn1 Column2 123 AF XC RG qw aa POP aa RT NN FM AF OutPut Records: Coulmn1 Column2 123 XX XC RG qw XX POP XX RT NN FM XX If values for Column2 input file has repeated vlaue like more then one then those records should replace with 'XX', if u...

Hi, I am using Mq stage to pull the .xml files and store it to local path. if the .xml files size is small then the file is going good as expected. But when using the .xml files in mq more size for example 82.7 KB the file in the local path is truncating the records and when checked it has only 1024...

Hi, I have a quesion as below: IPfield Nafta,no2,2012|Cafta,no2,2012|bafta,no2,2012 should get a data like this below OPfield Nafta|Cafta|bafta Please note the IPfield data can more with pipes. for example i can also have data like: Nafta,no2,2012|Cafta,no2,2012|bafta,no2,2012|Cafta,no2,2012|bafta,n...

thank you all for responding for my question.. appriciate for your inputs..

Regards,
Cheru.

Explaning the question again:

Input records:

SeqNo ValRecd
1 a
2 b
3 *
4 z

Should get out as below:

SeqNo ValRecd
1 a
2 b


i dont want record as :
SeqNo ValRecd
4 z


so imean the records after value '*' should not porcess ..

so i wnat the out as :

SeqNo ValRecd
1 a
2 b

Thanks .

Hi SwapnilVerma,

Seems like you did not understand the requirement.

My source is sequencial file .
The output should be only the records above the '*' value for ValRecd field.

only i want out put as :
SeqNo ValRecd
1 a
2 z

I mean the records above the * value

Thanks

Hi,

I have a question as below:

Input records:

SeqNo ValRecd
1 a
2 b
3 *
4 z

Should get out as below:

SeqNo ValRecd
1 a
2 b

The intension is not to process the records after the values '*' for ValRecd

Could please help to resolve... Thanks