DSXchange

Ultramundane,

What has been the response from IBM when you raise this issue with them?

Are your jobs multi-instance? You will not be able to see performance statistics in the master job log files, only in the instances of the job.

Hi Ray,

EXACTNUMERIC was set as 15.

I experimented with different values all the way up to 57 and couldn't get rid of the '0.NanQ'.

When playing in Excel (which has an inbuild FACT function) I can work out the factorial up to 170 (7.2574E+306). 171 returns '#NUM!'.

Zac.

Hi Ray, First of all, my apologies for not marking topic as a Server job. It is a server job, simple sequential file to transformer to sequential file design. I've edited the original post to correct. We tried the PRECISION argument with no success - same results. For no good reason other then 'just...

The first thing that stands out is that for every loop pass the factorial is recalculated. When the SOH is large, this is inefficient. You're better off keeping the running factorial and just add the next value in with each pass. This efficiency will probably help out a bunch. Thanks Ken, you were ...

Hi All, I've got some complex calculations to perform that require a loop process. My prototype was built in MS Access and handled the functionality with very few performance issues. I'm trying to implement in DataStage using a server job and routine. I pass my routine two arguments (ExpectedUsage a...

We thought we had looked at this. liborchsun.so is stored in our $PXHome/lib path, which is /data/edw/Ascential/DataStage/PXEngine.752.1./lib Our LD_LIBRARY_PATH in the Director log shows /data/edw/Ascential/DataStage/DSEngine/java/jre/lib/sparc/client:/data/edw/Ascential/DataStage/DSEngine/java/jre...

The exact message we get is: testDS_PrepLoad_Batch..JobControl (@countEpisode): Executed: dsrecords /data/edw/dev_01a/processing/EDW_IDS_DVP.EPISODE.ref.ds Reply=137 Output from command ====> ld.so.1: dsrecords: fatal: liborchsun4.so: open failed: No such file or directory Killed All good when run f...

Hi Guys, We are trying to use the DB2 Load function for our tables and often get problems with the jobs hanging. Looking at the db2 log: Type = LOAD Database Name = DEDW Partition Number = 0 Description = OFFLINE LOAD ASC AUTOMATIC INDEXING INSERT COPY NO EDW_IDS_DVP.PARTY Start Time = 16-03-2007 12...

Thanx Ray.

Where is this default functionality documented in the Developers guides?
Can the default value be changed? (I checked Edit Metadata on the column and could not see an option)
And, can the default functionality be switched off or a warning raised?

Regards,

Zac.

Datatype conversion from NULL to NOT NULL occurs in the Transformer. The source column was VarChar(3) NULL. Derivation was: IF link.column ='' OR link.column = '_' THEN SetNull() ELSE link.column The target column was VarChar(6) NOT NULL. An empty string is passed out of the Transformer, into a data...

Hi Guys, I have an example where a user has used SetNull() in a Transformer derivation to populate a column in DB2 that is NOT NULL. There is no warning message raised. The transformer passes the database column an empty string which is loaded into DB2. Does this seem right? Should a warning be gene...

Thanks for the responses, guys. Some feedback: Explicitly allocate memory for your variable inside the routine and then free it after making the return call. Tried this and the SIGSEGV error is gone! Can you try describing your "empty" strings in code as '\0' ? We tried this for both input...

Follow up question: what is the performance overhead of implementing this business rule in a BASIC Transformer? Derivations throughout this project are very simple for the most part, just changing names, some IF statements, and assessing if dates are valid and/or within a parameter-driven range. It ...

(Related topics to this issue have been posted before, and I am familiar with the potential causes of my problem - seeking advice on a specific solution) The Background: I have a need to convert invalid data to {Null} throughout my project. My intention is to develop and maintain a single DSRoutine ...