DSXchange

Hello,

Thank you.

The select stuff happens on mainframe, basically its an unload from DB2 table on mainframe i.e creating a file and sent across to DS server. this file is then used in CFF stage to read the data i.e EBCDIC to binary.

Thanks for the help

Hello, Thank you. I have PERIODKEY as PIC S9(4) COMP. and OUTLETKEY as PIC S9(9) COMP. PERIODKEY = 6957 and OUTLETKEY = 9. So What I am trying to do here is Multiply the SQL statement with -1 i.e SELECT (PERIODKEY * -1),(OUTLETKEY * -1) FROM CDS.FCREIMBS A So I expected this to be seen in datastage ...

Hello, Thank you. I have PERIODKEY as PIC S9(4) COMP. and OUTLETKEY as PIC S9(9) COMP. PERIODKEY = 6957 and OUTLETKEY = 9. So What I am trying to do here is Multiply the SQL statement with -1 i.e SELECT (PERIODKEY * -1),(OUTLETKEY * -1) FROM CDS.FCREIMBS A So I expected this to be seen in datastage ...

Hello, Is there a way to specify that a binary field is signed in datastage? I have a binary field Periodkey with value as 6957, however when I multiply it with -1 in the extract JCL it converts it into a integer value and doesnt shows the correct value as -6957 in datastage. it shows value as 0. So...

Hello,

Yes, I am using CFF stage and using the functions to convert the binary values to ASCII format? do you mean we should be able to see this binary values in CFF stage? I mean we should'nt be using the functions at all?, this binary is real trouble....any help would be great......

Hello Experts,

Could you please throw somelight here....is this doable? I mean can we use those DS transform function to convert it into Ascii, I am wondering why none of this functions give me accurate results.....please advice....

Thanks a lot experts, I have FTPied it using mainframe in EBCDIC and MODE is binary Here is an example I am struglling with my source column MONTHKEY is PIC S9(4), I have used Binary(4) in CFF stage and it shows me valyue as 7397, but the expected value is 7329 I have used following functions conver...

Thanks a lot experts, I have FTPied it using mainframe in EBCDIC and MODE is binary Here is an example I am struglling with my source column MONTHKEY is PIC S9(4), I have used Binary(4) in CFF stage and it shows me valyue as 7397, but the expected value is 7329 I have used following functions conver...

Hello,

Experts please suggest some alternative, or right way of using the transform functions to reac ebcdic(binary) data to convert it into Ascii, I am still struggling with this encdic to ascii conversion..any help would be great..

Thanks for the response, I have tried almost all the functions on the server transform/routines, none of this is working fine for me, i have a binary field, length is 2 I am unable convert it to ASCII format, Can you please suggest some way? alternate or right way of using this functions? I have tri...

Yes, I am using CFF stage with ASCII as data format , Record Style as binary and I have Binary fields in my source...as such I am getting data in a flat file with ebcdic and binary mode format, however when I am using CFF stage, I could view most of the other character fields as ASCII but Binary fie...

Thanks for the response, I quite didnt understood regarding unpacked and packed stuff? can you please elaborate little more with some examples? Dont we have a trasnform/routine which can convert my binary data to a readable format on datastage? I am curious to know?

Hi, I have tried almost all the transform Datatype functions to read the SmallInt(2) i.e a EBCDIC(binary) data from Complex flat file stage in the data format option selected ASCII and type binary to convert the field into ASCII data, none of the function is giving me expected results. Does anyone k...

[quote="Sandeep.pendem"][quote="chulett"]Have you [b]confirmed[/b] a timeout issue or is it just a belief? I for one haven't heard of a "3 minute timeout" - a 3 minute egg, sure, but timeouts are usually more in the 30 to 60 minute range. IMHO, 3 would just be crazy and...

[quote="Sandeep.pendem"][quote="chulett"]Have you [b]confirmed[/b] a timeout issue or is it just a belief? I for one haven't heard of a "3 minute timeout" - a 3 minute egg, sure, but timeouts are usually more in the 30 to 60 minute range. IMHO, 3 would just be crazy and...