DSXchange

Hello, I need to convert a numeric field into a varchar when I am loading into my DB2 target. I have tried the DecimalToString function, but returned blanks. I also got the same result when I tried the Char() function. I am extracting this field from SAP, which comes as a numeric. But my DB2 target ...

No suggestions from anyone?

Hello,

I have field in SAP that is being read using ABAP Extract stage. This field's data type is BIN1. How can I convert it to ASCII in datastage?

Yes, I know of those. I was seeing if anybody else had some...

I am looking to become certified in the upcoming months, and I starting to collect study matierals. Does anyone have any good resources containing any sample questions?

Well if you do, please let me know! I'd love to hear how it operates (if i don't get my hands on it first!)

Well, I suppose I was really leaning towards was mid-stream profiling. This is where you can debug your jobs mid-stream, rather than running the complete job and seeing what happened. I haven't actually got my hands on this yet, but I've been to a presentation and I was interested. I am hoping to ge...

I would like to see something alongs the lines of a Data Preview, like Informatica 9 has implemented.

Hello, I had a parallel job that was working yesterday, made some small changes, and re-ran the job and recieved this error: An error occurred while loading the DB2 library entry points main_program: Fatal Error: You may need to add the path to the DB2 client library ALGN to the appropriate environm...

Thanks anbu!

Hello, I am trying to concatenate several files into one file in a execute command stage. I am successful in concatenating them in Unix, however not in DataStage. Below is what I have written in my execute command stage: Command: cat Parameter: #GetPROJDEFValues.$Target_file_location#cust_mstr_r3_* ...

I have used this logic, which is correct:

Str('0',3 - Len(Counter)) : Counter

Where 'Counter' is my stage variable.

"So it is unsure how many characters will be in the stage variable at a given time. Also, the stage variable has to be 3 characters long" The above statements are a perfect contradiction. It means that the variable has to be 3 chars long. But the counter will be an unknown length inside t...

Hello, I am trying to pad a stage variable with zeros in front of it. This stage variable is a counter, but it is not static counter; it resets to zero often. So it is unsure how many characters will be in the stage variable at a given time. Also, the stage variable has to be 3 characters long, and ...