DSXchange

I know this is 4 years old, but we just came across the same issue. The commands SELECT DS_JOBS and DELETE DS_JOBS work fine. The problems of benzzano are caused by the blanks in the folder names. We use folder names with "_" instead of blanks and the DELETE command works fine. :idea: So t...

Hello, I am trying to read a decimal column from csv as decimal. The values have a format like this: From -1,23 up to -123.456.789,12 I defined the decimal separator and tried various decimal data type definitions (length, scale) but I don't get the "view data" to run. I get the error: Fie...

Thank you all, I will let the local IBM support team know.

Greetings,

Joerg

Hello,

I searched the forum but did not find any answer.

The customers developer guide defines jobs to be developed "warning free". I am using a lookup-stage which might be empty. How can I eliminate the warning on the empty lookup stream?

Regards,

Joerg

Hi, I'm sure there are several ways to the solution. If ODBC connections are allowed in your environment and architecture, you could use an ODBC stage. An ODBC stage can be set to "Reference link with multi row result set". The same can be done with an Universe stage, but never used that b...

Hi, can anybody tell me how to use the fields "Fatal errors:" and "Warnings:" on the tab "Error Codes" on "Inputs" of an ODBC Stage calling a stored procedure? The procedure to call is: create or replace procedure test_exception (i in number) as begin if i=0 t...

Hello, we are currently running DataStage 6 with Integrity Server and Designer and have plugins registered. For within the next two or three month, we are planning to upgrade to DataStage 7.5.1. DS Jobs migration tests have been successful and we will be starting shortly with testing the Integrity p...

Hello,

we have a very long chain of sequences and sometimes we need to interrupt this chain. To do this, we set the job status of a job to "not compiled". For the time being, this is done by compiling the job with an error. Is there a way to do this by a routine?

Regards,

Joshi.

I have tested serveral options. We are using an SMP system. I solved the problem by activating row buffering for Inter Process and put an InterProcess Stage between the two transformers. It even works without using an InterProcess Stage. The key is, wether using SMP or Uni-Processor System.

Hi,

I tried the option to use parameters from the job sequencer. How do I have to use the parameter (#PARAM#, $PARAM, ....)?

Joerg.

Hi,

well, we are on Windows here and tried to use #ENV_VAR# in the sqlplus parameter list. Did not work. We do not need to hide the command line, but we would like to hide the user and password combination. How is this done (set environment variables before executing commands)?

Joerg.

Hi,

we are executing an sqlplus command through an ExecuteCommand Stage and we would like to hide user/password information in the list of parameters. Any idea? What about environment variables?

Joerg.

Would it be enough to set up the three DataStage-Servers with according project parameters (in Director) and use them in the different jobs? I think that would avoid a manual change after deploying the job into test or production. Joerg quote: Originally posted by Ray.Wurlod [br]After you deploy a j...

The datasource names are configured in the tnsnames.ora, which is the central configuration file for Oracle Databases. But when defining an ORA8 or ORA9-Stage, one has to define the Datasource, User and Password to connect to the database and I would like to keep this variable to avoid changing thes...

Hello Stephan, the datasource names will be different in all three environments and we will not connect through odbc but using OCI. Does that make a significant difference? Background information: We are currently planning the environment setup and we are actually working on Windows. The destination...