DSXchange

I am getting the following error:
main_program: Fatal Error: APT_DB2Utils::dbversion:unrecognized version string: `SQL09053'.
This started happening after we upgraded our DB2 (on AIX) from 8.1 to 9.5. We are using DataStage (ver 7.5.2) and the error occurs only when using the DB2 Enterprise Stage.

For the past several days the startup time on many of our jobs has increased from approx. 30 seconds to over 2 minutes. We are, of course, trying to find out why. DBA, Unix Admins, network admins and ETL programmers all state that no changes have been made to the system. On suggestion from IBM is to...

I was getting the same uninformative error message in our job tonight: "ODBCTORURLOGSUM, 0:Unable to run job --2" The ODBCTORURLOGSUM refers to the name of a container stage that includes an ODBC stage used to update data in a SQL server table. We are using the container stage to incorpora...

I've just noticed a comment in another post that indicates nested functions are not permitted in Modify stage. That must be my problem.

Given that, can I accomplish what I desire through some other method in the Modify stage or should I stick with the transformer stage?

I have a need to drop the time portion of a timestamp and store the data back into a timestamp field. The result basically changing the time portion to 00:00:00 Ive tried the following: trans_dt = Timestamp_From_date(Date_From_Timestamp(tdatetime)) but am receiving the following error: main_program:...

Can a modify stage be used to add or subtract two fields together into a new value? I'm getting the following error: main_program: Error parsing modify adapter: Expected ';' or end, got: "-"; input: trans_dt = trans_dt ; store_nbr = storenum ; wrkstatn_nbr = wrkstanum ; store_id = storenum...

I'm not sure this is the right forum for this post so let me know if not. Can a modify stage be used to add or subtract two fields together into a new value? I'm getting the following error: main_program: Error parsing modify adapter: Expected ';' or end, got: "-"; input: trans_dt = trans_...