DSXchange

Friends, I am wondering if anyone ever successfully created a valid .so using /usr/vacpp/bin/xlC_r -O -c -qspill=32704 to compile and /usr/vacpp/bin/xlC_r -G to link? I can use the .o file as Object in PX ROutine and compile/run to success. But once I link the .o using -G option to create .so, the c...

Thanks for the sharing, and it did work. I also found the syntax in Page 227 Designer Guide.

dsjob -report only gnereates the job RUN report in BASIC|DETAIL|XML format, which is the Director Log Info. Regarding to job DESIGN report from Designer->File->Generate Report, I have not found out a way to create then in a systematical way. Appreciated if someone has done that and share with us...

George, I believe you are asking two questions: 1. Using DSJOB to generate a XML or Text and then parsing the record count info is one of the options. However, there are some other decent ways you can consider to take such as calling DSGetLinkInfo to collect the count. 2. Cobol Over Punch function c...

You should probably learn how to escalate the issue to Critic 1 PMR, and they usually respond with proper answers. I just got a Basic Transfromer bug fixpack recently from IBM, and it just took them 2 weeks to figure it out. Good luck...

We had the similar problem last year while using 5.0 with ODBC stage, and IBM suggested to use the 5.2 instead to resolve this problem. I double-checked our jobs implemented in production last year and found out all our jobs were actually using DRS stage. My co-workers who designed these jobs told m...

Ensure you have latest DataDirect ODBC Driver 5.2.

I believe you are looking for function: GetEnvironment, because you cannot use Environment Variables directly in a transformer like the job parameter. You have to call the function to return the value for you.

May I know why not go to the up-to-date version which is 8.0.1? Did IBM advise you to stay in 7.5.2 for this migration?

Keith, We have successfully installed DataStage 7.5.2 on Linux RedHat V4 32 bits, and it's quite stable. I was told that the version 8.1 that yet to come on November this year will be fairly stable on Linux 64 bits. Why don't you wait for this and forget about 8.0.x for now if you are currently stru...

Sorry, I missed the part on ODBC Stage. My previous positg is related to UDB EE Stage, please ignore it if not applicable. I will recommend you get the latest Data Direct ODBC Driver sets(I believe it's 5.2) from IBM, and it might fix your problems.

Could you please do a
ls -al .../PXEngine/lib/orchdb2op8.o, and post the result here. I might be able to tell you if your version is a good one or not. I just happened to deal with UDB problems in various aspects, and I got so many versions of this library to deal with various UDB/DataStage problems.

If you have not upgraded to 8.x, you may have to use Server job CFF to extract all formats since PX CFF can extract one format at a time. Notes that Server job CFF extract all formats into one flatten record layout, and you have to identify every format via certain record type column using transform...

Yes, it's in Transformer Stage. But ensure you are using PX Transformer, Basic Transformer doesn't have this function.

I thought this problem only showed up in DataStage Windows 7.5.x2 version, I have never encountered the same problem in my current environment AIX 5.3 DataStage 7.5.2. Could you please tell us what's your OS and DS version? I believe it's time to open a case with IBM now. This problem is caused by t...