Search found 4 matches

by colhogan
Sat Mar 06, 2010 5:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Transform logic not working in DS8.1 working in DS 7.5.2
Replies: 2
Views: 2432

Transform logic not working in DS8.1 working in DS 7.5.2

The following transform is not putting spaces into the column in DataStage 8.1. It works fine in DS 7.5.2. The code was converted. The column contains null in DS 8.1 IF NullToValue(TO_Transform.PROV_LOC_CD,"999") = "900" THEN NullToValue(TO_Transform.BZET_PRO_ID," ") EL...
by colhogan
Mon Mar 01, 2010 11:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Infosphere DataStage 8.1 Sybase OC stage not processing data
Replies: 0
Views: 1453

Infosphere DataStage 8.1 Sybase OC stage not processing data

We converted extract routines from DataStage 7.5.2 to DS 8.1 When we execute the jobs, we can open View Data on the Sybase OC stage and see the data. However, the data is not moved to the next process which is a join. The job "hangs" until aborted.
by colhogan
Thu Dec 10, 2009 11:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Column BATCH_ID floating point decimal is not fully supporte
Replies: 5
Views: 4555

Re: Column BATCH_ID floating point decimal is not fully supp

Smith, Did you get this issue resolved. I am also having the same issue . Pls. Let me know If you know any alternate for this.

Thanks...
by colhogan
Wed Aug 05, 2009 9:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Encoding conversion error : Truncated character
Replies: 0
Views: 1567

Encoding conversion error : Truncated character

Hello, We are encountering the fatal error: FACS_PROD_Tables,0: U_TRUNCATED_CHAR_FOUND encountered. FACS_PROD_Tables,0: Encoding conversion error : Truncated character found The FACS_PROD_Tables stage is a Facets system on a Sybase database, coming in through a DataStage Sybase connection. I pulled ...