DSXchange

What would be the following warning message,

DataStage Job 102 Phantom 20769
Program "JOB.122335461.DT.132456721.TRANS3": Line 1234, Variable previously undefined. Zero length string used.

Thanks
VS

Thanks Craig Hulett. I am curious to know the reson for it.

Thanks

I need to populate job start date_time (YYYY-MM-DD HH24:MM:SS, but not micro secs) to one of my oracle table field (of Oracle Date data type). We may use DS macros DSJobStartDate:" ": DSJobStartTime Or we can substring Macro DSJobStartTimestamp to pick date_time. My question is which the b...

Type 2(hashed) to Type 18(Hashed), Type 25(B-Tree) and Type 30(Dynamic) for both GENERAL and SEQ.NUM hashing algorithm.

Hi Shay, What do you mean "The number of tables/connections that the jobs make". Suppose if you want to look-up on 10 tables, take one ODBC stage(One instance) and write your SQLs in diffrent SQL tabs of 10 different links to Transformer( ODBC ---->Transformer). If you elaborate your job d...

Thanks Ray

As far as DS error message is concern, its absolutely DB error.
Something fishy with user defined SQL in ORA OCI stage.
can I see your userdefined SQL from ORA OCI Stage.
We don't know, some spaces may gives problems.
Why don't you re-type the user defined SQL

I don't think so.
But if you pull all the unwanted columns into transformer, job process time will be increased. Its a performance bottle neck at ETL level.

Why don't you re-type your user defined SQL. It works sometime. FYI Error: ORA-00911: invalid character Cause: You tried to tried to execute an SQL statement that included a special character. Action: The options to resolve this Oracle error are: This error occurs when you try to use a special chara...

Thanks ArndW

We recently upgraded to DS 7.5.0.5 Enterprise edision from DS 6.0.1 Server Edition. We have some batch jobs ( All server jobs) in old version. We performed integrate testing in DEV(DS 7.5.0.5 EE), it went well without any warnings. When comes to production, one of a server job in a batch finished wi...

I am using Dynamic RDBMS (DRS) Stage to access source SQL Server database. Source table is having Decimal, Varchar, Timestamp data type fields. I am writing it to Sort--->RemoveDuplicate Satge---->DataSet stage. While running the Job its giving the following warning messages Dynamic_RDBMS_0,0: Illeg...

Thanks Rich.
I want to run the job for 50 or 100 or 1000 .....rows
Is there any otherway to do it( without modifying the job)

Thnaks ArndW

Hi,
I want to run a PX job for a specified number rows.
But, in Job Run Options --->Limits Tab --->Rows -----> both the radio buttons No Limit and Stop Stages after Rows options were disabled.
Could anyone tell a way to do it.