DSXchange

Thank you everybody for giving their feedback. I am using 8.1 version of datastage. I wanted to use APT_ISVALID_75COMPAT parameter but unfortunately i can't see that in environment parameter list. But i cross checked the behaviour of IsValid for "Int32" in 7.5 and it is working fine there....

Hi Can anybody help me on following issue. I am using following funtion to validate integer values. IsValid("Int32","+2147483648") this retrun 1 even though the max positive value allowed is 2147483647. another issue: I am validating decimal[18,2] values using following function ...

Soryy, Craig... I put my question in parallel forum. My apology.

Hi All, This post is in continuation to the below post. http://www.dsxchange.com/viewtopic.php?t=140387 I have got the decimal to hexadecimal conversion right in datastage. Now I have got input as Binary(8 ) in datastage. But, when I load the input value to Teradata which datatype is Byte(8 ), the i...

Thanks for your help. Even I could not find any limitation of this function in documentation. :D

Hi Guys, It would be great if someone can help me to resolve the below issue: Requirement: I have 12byets of decimal input field that needs to be converted to hexadecimal and put into one table. My output field is Binary I am using OCONV(Input link,"MX"). It works fine when incomming value...

I have senario where i have to read the Unsigned Packed Decimal. I am using the sequential file stage to read the binary files. Its value is 22334 and its HEX Value is 0234 023F If any signed value come in the input file then it should be treated as Null. Like 0234 023C OR 0234 023D. I am able to re...

Thanks for the reply. I am working on it. I will post update.

Thanks again.

Hi All, Generating the sequence number and reseting the value for new rows. Example. I have to generate the sequence number after each row generated by the pivot stage. col_A col_B col_C rec_count A B C 1 D D D 3 D D D 3 D D D 3 Z Z Z 2 Z Z Z 2 K K K 1 Expected output. col_A col_B col_C rec_count A ...

"Try reading the file with a Complex Flat File stage" Ray, Thanks for the reply but Seqiencial Fille stage is recommended by the client to use not Complex Flat File stage. So have no choice but to use Sequencial file stage .Can we have something on Seqiencial Fille stage to acheive the res...

Hi All, I know this topic has been discussed so many times. But I really did not get the real clue how to go about it after serching the earlier post. In CFD one field is there with datatype Field PIC S9(8) COMP. In sequencial file it takes as Integer((Int32) 8 in length Data format Binary Default 0...

Hi All, I have gone through the Parrallel Job developer guide. It is mentioned that we have the option to flaten the Array and we can read it in CFF Stage.We can also flaten the Array based on the "occurs depending on" and i have the case where i have got "OCCUR DEPENDING ON" and...

I had the problem in reading the Array in the Complex Flat File. I have the Array with the OCCUR ON DEPENDING ON value. Can we read the Array in the Complex Flat File with the OCCUR ON DEPENDING Clause. or we need to read the Array without Expanding it and the normalizing it in the Transformer Stage...

You need to check your Decimal fields and make sure they have a default value of 0.

I tried this way also. But not succeeded.

Hi All, I have to read a mainframe file format binary/EBCDIC. I have imported copybook as metadata. I am able to view just 1 record which is not actual. Just for testing purpose I had created on server job of same design and I am able to view the actual number record. I put the following property at...