DSXchange

Thanks Craig and Ray for your reply! I already have the sort method set in aggregator stage and Hash partition defined on the key columns. just an update on the number of records in to transformer and to aggregator stage (approx. 2M records ) --> Trasformer--> (64 M records) ---> Aggregator This the...

Hi, I have a job designed as below. While running this job we are running out of DataStage memory issue. I see that there are many records coming out of transformer stage because of the 40 constraints defined. DataStage is holding up all the data in memory before processing the aggregator stage. Can...

Thanks Chulett for your reply !
But, its just not me facing this issue. Other team member are having the same issue as well.

Hi , When I try to view the Datastage Director to see the logs , while the job is running. I get this error message "Run-time error '5' Invalid procedure call or argument " When I click "OK" the director crashes. Why does this happen and please let me know if there is a solution ...

I am calling the stored procedure in the Before SQL of an ODBC connector stage. The stored procedure has 5 input/output parameters that are defined. While making the call to stored procedure stage in the before SQL of ODBC connector , I am passing in parameter values. Can we read the output values o...

Yes Chullet, you got the point. Do we have an option in datastage to read the data from the global temporary table in the same session when we are making the stored procedure call?

Hi, I am using a stored procedure stage in datastage to call a db2 Cobol stored procedure .The db2 stored procedure loads the data of to a global temporary table. As datastage ends the db2 session after the call to stored procedure, we are not able to read the data from the global temporary table. D...

Can we call a cobol stored procedures from datastage 11.x(Parallel job) stored proc stage?

Thanks!

When I am trying to run the job which is a stored proc stage trying to call a DB2 stored procedure I am getting the below error
[IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009'

Any solution to this issue?

Thanks!

Hi,

Transformer_12: When checking operator: Dropping component "logo" because of a prior component with the same name.

I am getting this error for all the column in source table

Desgin of job
ODBC ENTERPRISE Stage(SQL SERVER)------>Transformer------->Oracle Enterprise Stage

Hi, The Design of Job is as follows: ODBC STAGE(SQL Server)------> Transformer -------> OCI STAGE I am try to read a timestamp column from ODBC stage and write the same OCI stage which is also a timestamp column, but when i try to do this i am getting the following error: Oracle_Enterprise_0: Column...

Hi,

When i am trying to load data to oracle database using Oracle Enterprise Stage i am getting the following error:

Oracle_Enterprise_1,1: Unable to create FIFO with name '/Data/CDH/Scratch/ora.10487.567021.fifo.1' and mode 00666 - Permission denied

Hi,

Can any one explain in detail the use of $APT_CONFIG_FILE and $APT_ORACLE_NO_OPS config file and links for PDF to get more information.

I have tried that too but i get the same warning as beofre.I tired to run this job with the sequential file as target for 2.8 million records, and i still get the same warning. When I reduce the number of records by applying a filter in the soucre and it seems to work fine.The problem i am assuming ...

After resetting the job the From previous run shows the follwoing messages: DataStage Job 45 Phantom 958 Program "DSD.StageRun": Line 657, COMMON size mismatch in subroutine "DSP.Close". Program "DSD.StageRun": Line 657, Unable to load file "DSP.Close". Progra...