DSXchange

Does anybody know if the newer versions of Datastage have plugins for Paraccel and Kognitio??

I know that they have it for Netezza but I'm not finding much on these two.

We are currently under 7.5.1 but will upgrade our DB2 to one of these plateforms.

Thank you!

Hi, We are using the ODBC (5.3) Plug In to access an Informix database using Wire Protocol. When importing table structure with Manager it does not shows the entire list of the tables. We see all the Informix sys tables and some other that are all affected to Public role. Strangely using a Windows O...

Hi,

I have done some research but did not found the answer.

What is the maximum char length that can be use in a string parameter?

Having connectivity problem with DB2 after migrating to V9. In Director I see that we are still poinitng to DB2 V8. The DB2DIR variable do not seems to be iclude in the DS Administrator Environment panels. Curently we have DB2DIR=/usr/opt/db2_08_01 Where do we set this variable? Besides the path ,do...

ray.wurlod wrote:What is the format picture you are using for the timestamp? Does it include the fractional seconds part? ...

Hi,

I am using the following:

CONSENT_END_TIMEST: timestamp[microseconds] {text, timestamp_format="%yyyy-%mm-%dd-%hh.%nn.%ss.6"}

Thanks!

kandyshandy wrote:Did you try concatenating timestamp part with hardcoded '.999999' and loading them to target field?

Hi,

Yes I have tried that and not working for me.

Hi, I am working on converting some ETL programs from COBOL MVS to Unix DataStage PX. On some condition, one of the COBOL program is setting a timestamp column to '9999-12-31 23:59:59.999999'. Although DataStage does not seems to kick or issue warning of any sorts, I am getting '9999-12-31 23:59:59....

Hi, I have to retreive the content of two DB2 columns that are produced by the IBM DPROP utility. These columns are declared as: CHARACTER(10) for bit data with content looking like this from Quest: x'0000208E216190000000'. What I have to do is basic. In the case that the source record does not sati...

Hi, I am getting the following in my job output: cs}}},2: Fatal Error: Tsort merger aborting: Scratch space full [sort/merger.C:870] I know that increasing the scratch disk will resolved the problem but what I would like to know after reading on similar topics in this forum is; is it only the SORT s...

Does anybody has any success in using a stylesheet with the XML Input Stage? I am trying to get the stage to use a simple stylesheet but get full of warnings such as: XSLT Processor: Unknown element on the output. Element Name = "CustomerName" When I am removing the stylesheet reference my...

Hi, Having an error compiling a transform stage susing the following: CompactWhiteSpace(Trim(TPRTNLOC_01.STREET_NUMBER,"0","L"):" ": TPRTNLOC_01.STREET_NUMBER_SUFF:" ": TPRTNLOC_01.SUITE_NUMBER:" ": TPRTNLOC_01.STREET_NAME:" ": TPRTNLOC_01....

Hi, Is there a way that we can have Data Stage to avoid generating Warning messages? I am calling a Data Stage job from a shell script in a loop sequence in order to validate the format of submitted files from the client. When a file is not compliant with the format we expect, my script takes care o...

Hi, I need to merge 2 files together that have the same composite key structure. I am using a Join stage with the Full Outer join option. File 1: Column Key (y/n) --------- ----------- Report_date y Level_1 y Level_2 y Level_3 y WorkVolume n File 2: Column Key (y/n) --------- ----------- Report_date...

Looks like a job started yesterday at 7:55 Pm yesterday do not terminate. I am seeing that it have been running all night now for almost 11 hrs. I have first try to stop it from Director. It does not do anything, it is still running. Although we seems to have kill all related process yesterday night...

ray.wurlod wrote:You can rely on implicit casts in a BASIC Transformer stage.

Thank you Ray.

Should I been worried about any performance hit using a Basic Transform instead of the PX native Transform?

What should be the guidelines in using one or the other?

Is it something documented in the Onine manuals?