DSXchange

I am using the XML Stage and it was working fine during my initial testing. I renamed my input and output links and accordingly changed the mapping in the Assembler. When I re-reran the job, I get the following error. Message bundle error Can't find resource for bundle com.ibm.e2.Bundle_E2_engine_ms...

Thanks a lot chulett. Its working fine now.

Hi, I tried the above suggested option. My job desgin is: External Source Stage --> Transformer --> Sequential File I used gunzip -c Test.gz command in External Source Stage. The log says data import is successful. In the sequential file. I am creating a Test1.dat and in the filter option, the comma...

Hi, I have a source file Test.gz(Zipped File). I need to do some transformations and put it in another file Test1.gz. How i achieve this? The file is in UNIX server and i need to read it from DataStage. Can i use External Source and External Target stages? What kind of programs can i write? Thanks, ...

Hi, Can we use BETWEEN in the where clause of a Filter Stage? I got the following error : Parse error: Expected between [field/literal] and [field/literal], got: between "CLM_CHK_DT" "(" Parse error: Expected boolean operator (and, or) got: "'01/01/0100'". My where clau...

Hi,

I have a input data Varchar(24) coming as 214584654200708086120001.
I need the output as Integer(24).

I tried using AsInteger function. But, the output is giving me a completely different number.

Please provide a solution for this....

Thanks a lot Pavan...

Hi,

How to pad zero's to the left of an integer?

I have 2 inputs Id1(Integer 21) and Id2(Integer 4)
I want the output as Id3(Integer 25)

Logic for Id3 : Concat Id1 and Id2

If Id2 = 24, my output should be Id1:0024
If Id2 = 235, my output should be Id1:0235

Please provide a approach for this.

Hi,

I am new to DataStage PX. I have a query regarding Merge stage.

What kind of join does it do? Is it a left outer join?