DSXchange

Tried to do that.. Still the same error...

I'm facing this issue in DataStage 8.1. I have access to DataStage 8.5 test env where we are testing our migration activities... The same job works fine in 8.5... Could it be something to do with the installation of 8.1

Oracle with just a peek/dataset works perfectly fine... No problems there...

Oracle with just a peek/dataset works perfectly fine... No problems there...

I tried setting the APT_DISABLE_COMBINATION to true.. It still gives me the same set of errors: main_program: Unrecognized argument: secondary main_program: Unrecognized argument: secondary main_program: Unrecognized argument: secondary main_program: Could not check all operators because of previous...

Hi, I have a parallel job with data being read from an Oracle Ent. Stage followed by an Investigate Stage. I am trying to perform a character discrete investigation on a zip code column in my source data. I have given a mask of CCXXX. The job fails with the error: main_program: Unrecognized argument...

Hi, We are using Oracle database as the source/target DB in our extraction process. I have a particular column - ColA of datatype VARCHAR2(40 CHAR). The NLS setting of the database is UTF8. When I use the ODBC Table Definitions to import the metadata, this column translates to NVARCHAR(160). But, wh...

I checked with the IBM team and they agree that the rutine doesn't work as expected. And I also shared the routine code. They provided a workaround for my code piece. And also conformed that there is no correction for this even in v8.5

Hi, I'm trying to list out the passive stages in a DataStage Parallel Job [DataStage v8.1] using the DSGetJobInfo function. #### Server Routine Code as below #### $INCLUDE DSINCLUDE JOBCONTROL.H JobHandle = DSAttachJob(JobName,DSJ.ERRFATAL) Ans = DSGetJobInfo(JobHandle,DSJ.STAGELIST2) ### End of Cod...

Thanks!
That works... But is there any performance implication by changing the method from hash to sort?

How are these two different?

Hi , We are using an aggregator stage with a large number of grouping keys (about 24). Prior to the aggregator stage we have a sort stage which is sorting data on all the keys used for grouping in the aggregator stage. When I run this job for 33,000 reocrds I get a warning saying: "Hash table h...

Could anyone elaborate on how the database connections are established in a parallel job having an oracle stage running sequentially? Does sequential mode of operation mean that data from the DB is handled by the conductor node and this node opens only a single connection to the oracle DB? We have a...

Will there be 40 open connection, even if the oracle stage are set in sequential execution mode?

Hi,

We have designed jobs to extract high volume data from some sources. So, we wanted to configure them for >4nodes configuration.

Some of the jobs have 10 oracle stages. If I execute this job on a 4node configuration, then will I have 40 open database connections (4*10)?

Thanks
Deepti

Hi, While extracting data from a given source system (sourcing 10 tables), we decided to have a single ETL job for it. The source and target are both databases and so, to extract and load the 10 tables we used 20 oracle enterprise stages in a single job. When executing the job, we encountered the fo...

Hi,

The NLS_CHARACTERSET in the DB is also WE8ISO8859P1. Doesn't this map to ISO8859P1 in Datastage?

The project level NLS setting in Datastage was UTF-8, which I now changed to ISO8859P1. But, the error still persists.

Any thing else that I seem to have missed?