DSXchange

Hi There,

Can DataStage read Oracle Spatial Data.

I heard that DataStage can call an FME process, how is it done .

Thanks in Advance.

Thanks guys for the response.

I have asked admin to look into it, he might have missed to add some path.

Hi Every one,

I have designed a job to invoke a stored procedure, but i'm facing the below errors while running the job, below is my job design

Row_generator---->Transformer---->SPS


Could not load dsstpora.so

Error occurred in call to ORPHCallActivePluginInitialize().

Please help me out

Hi All,

I am facing problem in updating the data using the odbc stage , getting the below error.

Destination "APT_TRinput0Rec0.WELL_LOG_ID" is already bound.

My job design is

Dataset--->Transformer--->Odbc Stage.

Thanks in Advance!

Hi All,

Can anyone explain me about Null seed and percent null options in Row generator with an example.

Thanks in Advance!

The obvious answer is to use the function within a user-defined SELECT statement. ... Thanks for the reply ray. yes we can call using the select statement, but i want to know how to call it from any of the other stages. And how to invoke the procedures from datastage jobs please help me out if you ...

Hi Jay, By using Transformer stage along with a pivot stage we can do this. Eg: In the transformer take two more fileds 1. value1=value[1,up to 1st split u want] 2.value2=value[2nd split] -- substr functions. Now in the pivot stage while deriving output columns assign value1,valu2 to the filed value...

Hi All,

I need to use a function which will return one value.

for Ex: Sum Function which adds two input values and returns a value.

How can i use this function in datastage job?

Please explain in brief if someone knows this b'coz i never used scripts and functions in datastage.

Thanks in Advance!

Hi ray,

The issue got resolved, but i used fileset instead of dataset then the job ran successfully.

The job nearly took 12hrs to complete, can you suggest any other alternative so that it will take less time, again i need to use this data as a reference in other job.

Hi All, I want to write huge amount of data from a table into a dataset. Number of records are almost equal to 17crores. After loading 11crore records job is getting aborted. I'm getting the below errors TGT_RM_IMAGE_LOC: ODBC function "SQLEndTran(SQL_ROLLBACK)" reported: SQLSTATE = 08S01:...

Hi All, I'm getting the below error's while using sparse lookup in my job. LKP_AMI_WS_APRGTS,1: Operator terminated abnormally: received signal SIGSEGV LKP_AMI_WS_APRGTS,0: Operator terminated abnormally: received signal SIGSEGV . Job Detail: Source ODBC>lookup on target odbc>dataset. Thanks in Adva...

In the shared container we have used to transformers, one for null handling and another to apply the business rules using 10-12 stage variables.....

Hi , I have a ob which has a shared container in it. The job is running fine when ran directly, but through sequencer it is getting hanged..... In job monitor status it is showing as if it is finished but in director it is still in running state... And also aborting the job using job cleanup resourc...

Thanks!

Hi All, While running a job individually, it's running fine. But when the same job is run through the sequencer it is not coming into finished state but when looked at the performance characteristics and the job monitor it looks like as if it is finished. Fast response would be appreciated. Thanks i...