DSXchange

Has anyone experienced an issue with the dscc.exe command returning a 0 when an error occurs? If I run the dscc.exe using a valid job name it completes with a return code =0. If I run the same command with an invalid job name it completed and with a return code =0 and same thing happens if the job d...

I am calling dscc via a batch srcipt and seems like the dscc command returns a 0 even if the compile fails or the job does not exist. Has anyone else experienced this issue?

No... The job design is the same just compiled with 2 different DS clients.

We are having an issue with a lookup stage behavior being compiled using DS client 7.5.1 vs. 7.5.2. The server is 7.5.2. I was always under the assumption that the job is compiled on the server and uses the version on the server and not on the client. If run a binary compare between the 2 executable...

Does anyone know if MS Sql Server has a native AIX CLI driver which can serve as a bulk loader for DataStage? I am starting a POC to and need the ability to bulk load data quickly to SQL Server via DataStage. I am currently using the DataDirect drivers for my POC. Currently on AIX DataStage 7.5.2. I...

I need to run through all the jobs in our repository and dump a Usage Analysis report for each job. Can this be done via dsjob or DSDesign.exe on the client? If not on the client can I do this on the server?

I have a need to read a daterange from a DB2 table and pass the daterange from the table to an ORACLE PX job which has an ODBC stage. The daterange will be used in the query in the WHERE clause. Anyone have any idea on how to pass the DB2 datarange as a parm for the ORACLE job?

We are having an issue with the dsjob command returning a 141 but the job is completing successfully. I think the 141 is some sort of timeout return code but not sure the process that is timing out. Thinking it is the the dsjob submit process but the job process complete successfully. Any insight wo...

We are being questioned by IBM auditors stating that we have the SAS pack for 7.5.2 AIX installed. I cannot find any indications we have it installed nor do we have any SAS stages on the pallette. Can someone tell me how I confirm if it is installed?

Thanks

David

Any one using this plugin for DataStage? Also does this product only work with DS8.X or will it be available on DS7.X?

Our file system backups for the DataStage Engine seem to be taking exponentially longer every day. We have configured all job logs to be purged on a weekly basis. Also have not moved many new jobs to production. It looks to me that DataStage is not cleaning up the Projects folder correctly. Their ar...

Yeahh.. The inteface was a typo... Also trying to run the SQL below to give me all the jobs that have changed since current date -1 and does not seem to be picking up the DTM in the where clause.. Any ideas? -------------SQL---------- SELECT INSTANCE, DTM, MODIFIER, REASON,CAST(CAST(CURRENT_DATE -1 ...

Tried the above SQL and received the error below. The UNNEST qualifier looks to be a field modifier based on the SQL documentation. UV..uv_ds_audit.DSLink2: DSD.BCIOpenR call to SQLExecDirect failed. Statement was:SELECT INSTANCE, DTM, MODIFIER, REASON FROM UNNEST DS_AUDIT WHERE CLASS = '2' AND INST...

I have the UNIVERSE stage working returning rows but looks like some of the columns are multi valued. I am retrieving row from the DS_AUDIT table. I need an individual row per entry and not just one row. Is their a UV SQL keyword to output as multiple rows? QUERY: SELECT INSTANCE, DTM, MODIFIER, REA...

I would like to execute UV SQL via DataStage and not an AIX script. Can this be done?