DSXchange

Thanks to All

Is it the one and only solution?

Hi All,
How can I access a flat file which is in mainframe environment. DataStage Server is on Windows.

Thanks Ray.

Hi All,
I want my output in XML format. Can I customize XML tags in XML stage as output stage.

Regards

One important thing is, make sure that you have all the latest COMPILED datastage code.

Hi Williams,
The incoming date is in Julian format and length is 11.
Is the data type and length is same in both the Input/output tabs of Hashed file?

VS

Thank you all

In a PX job, If data is partitioned on key 1 and then aggregated on key 2, what issues could arise?

Thx
VS

Itried the following routine code, but its throwing compile errors, Eg:- code = trim(code) begin case case code = 'X' Ans = 1 case code = 'Y' Ans = 2 case code = 'Z' Ans = 3 case @true * (If any other value apperas for code) Ans = @null DSLogWarn("Unexpected code appeared":code,"myrou...

I Tried this in routine, it didn't work. I have routine named "myroutine(Arg1) , Arg1 is "Code", I am expecting 'X', 'Y' and 'Z' for Arg1, if any other value comes, I would like to throw a warning from myroutine Eg:- code = trim(code) begin case case code = 'X' Ans = 1 case code = 'Y'...

Thanks Ray

I tried VARCHAR , by changing metadata. It still showing in DS internal (integer) format of Date. I also tried changing data element to DATA-TYPE (of Varchar), it didn't workout.

How can we throw a warning message from a custom server routine when any of the else condition in a routine fails at job runtime.

Thanks
VS

I am writing date(YYYY-MM-DD from sequential file) to Hashed file, hashed file is storing in its internal integer format. I need to populate this date to Oracle table date field. Is there any way to populate date to target without doing any Iconv/Oconv conversions. I mean can we store the date as it...