DSXchange

Is there a way to validate numeric digit-only string input in a parallel job transformer stage? Each character of the entire string must contain digits 0 through 9 only. Periods, negative signs, or any character outside of the 0..9 range needs to be invalid. I have tried the Num() function and it fa...

That solution worked for me as well! I had been getting a fatal error (below) on the DB2 Connector stage when the write mode was set to "Insert then update." Message Id:IIS-CONN-DB2-00695 Message: DB2_Connector,0: DB2 reported: SQLSTATE = 40506: Native Error Code = -1,476: Msg = [IBM][CLI ...

I tried a job using the stage variable to set DSJobStartTimestamp. Don't know why but it aborts after 4 million rows. Ran it again, same abort. Then I re-ran the previous job that queries -> xfm -> seq file and it ran 10 million rows fine. Must be a bug in DS 7.5.2. It sounds like a good tip but I t...

The job queries one Oracle database and loads into a separate Oracle database. The query is against a view: SELECT SDATE, LEVEL1, LEVEL2, LEVEL3, LEVEL4, LEVEL5, LEVEL6,CAST(C_PRED AS DECIMAL(38,10)) C_PRED FROM BIEO_SL_BASELINE_FCST The view definition has some grouping and joins: CREATE OR REPLACE...

I have a 7.5.2 AIX parallel job that reads 10 million rows from one Oracle database, does minor transformations and does a truncate and load into another Oracle database and it takes 15 hours. I have split the job into two jobs. First job is the Oracle to transformer to sequential file and that job ...