DSXchange

Thanks Jack.

I would be very interested to hear how it all goes.

Thanks Kryt0n.... unfortunately simply using the local variable technique didn't work with our installation of DataStage (7.5.3). So.... I have since added a static string variable to my code to achieve the desired result; #include <stdlib.h> #include <stdio.h> #include <string.h> #include <ctype.h>...

Thanks for the code JoshGeorge. I haven't had a chance as yet to test out your code, but I plan to give it ago in the upcoming days. Kryt0n, thanks for the feedback. Since your last post I have removed the two free() statements and I have changed char* varOutStr=(char*) malloc (varStrLen+1); to char...

Thanks for the feedback Kryt0n. free statements won't get executed due to the return being called prior to them You are probably right... I put the free statements in as an after thought.... I would assume that DataStage free's the memory its using at the completion of a process, but I am not sure? ...

I have received a response from IBM support in regards to this issue. After more investigation at my end, I have discovered that the issue is occuring in jobs when using a target Oracle Enterprise stage with the "Index Mode" setting. When we do not use this setting (ie. rebuild indexes aft...

Hi All, As a result of a previous post ( http://www.dsxchange.com/viewtopic.php?t=132126 ), I have received a few private messages asking me about a parallel routine that I have written to remove non ascii chars from an input string. For anyone who does not know how to create parallel routines, I fo...

Should have also mentioned that I don't have any other options set in my .ctl file (apart from the last test run where I had OPTIONS(DIRECT=FALSE, PARALLEL=TRUE)... For eg. OPTIONS(DIRECT=FALSE, PARALLEL=TRUE) LOAD DATA length semantics byte INFILE 'ora.23244.637488.fifo.0' "FIX 9463" APPE...

In our scratch directory, SQL Loader is producing .bad files which contain the records in question, so I would have expected that DataStage would at least produce a warning regardless of how many records are recorded as errors? I know that these records can be inserted into the target Oracle table b...

Hi All, I have recently discovered an issue with a simple parallel job I am working on. The job design is as follows; Oracle Enterprise --> Parallel Transformer --> Oracle Enterprise (Write Method = Load, Write Mode = Truncate) My source Oracle Enterprise stage is sourcing several million records. O...

This can be rectified by adding a new Environment variable to the user defined category in Datastage Admin(environment variables section).

the new variable name is
DS_NO_FF which is string type and set to value 1.

Pardon my ignorance, but how exactly do you do this...?

Ray, I dont know if this is the information you are after, but this is all I have from Ascential;


Ascential Support Survey for Case no.: 488298*AUA

As suspected.... It is indeed a problem with the configuration of the Oracle Client software. IBM Ascential support provided us with a patch a few weeks back, which replaced the library file oraoci9.so in the <install_dir>/DSEngine/lib directory. This patch sorted out a seperate issue, but caused th...

Thanks Ray.

IBM Ascential support have been able to replicate my problem. As to what causes it, not quite sure just yet, but they are leaning towards what we suspect.... problem with the OCI stage interacting with the Oracle client. If an explanation is provided I will post it.

Hi All, I have a group of very simple server jobs which currently source data from one Oracle 9i Database and write it to another Oracle 9i Database. Basically all of these jobs are structured as follows; OCI -> Transformer -> OCI The source database for these jobs is being upgraded from 9i to 10g. ...