DSXchange

Ah, I see the problem. I thought you saying it was a function yet calling a stored procedure was a simple typo in the post. I see I was wrong. You don't usually call an Oracle function, you call oracle stored procedures. It should be invoked via a SQL statement. Have you tested this function in SQL ...

I would seek some guidance from Ascential on the future of MQ in DataStage. My feeling is that RTI will be the preferred method and this stage will be left to it's own devices. My opinion would be that this stage began life as a neato idea from the "two-drink" minimum boys over in Marketin...

You can't set them in the environment at job runtime and have them available to the job is what I meant. Also I meant if you want the job parameter to be named the same as the env variable, you cannot do this in the shared container. Naturally, you can equate a $<name> to <name> if you want. I would...

My understanding is that the environment variables can be set ONLY in dsenv. Fairly useless when multiple jobs within the same server need different values. We are finding $environment variables useful as global parameters. By global I mean by project. These variables are set in the DSParams and can...

What is the failure that link2 is reporting?

We got it with this; plogpath=`${dshome}/bin/dssh "LIST UV.ACCOUNT <Projectname> UNIQUE.PATH FMT '256L' HDR.SUP COUNT.SUP ID.SUP COL.SUP NOPAGE" | sed -e 's/^[^/]*//' | tr -d "\012"` The sed eliminates everything but two line feeds. The tr does the rest. I think I like the head t...

I would like to use this: echo `${dshome}/bin/dssh "LIST UV.ACCOUNT ${Projectname}FACR1DEV UNIQUE.PATH FMT '256L' HDR.SU P COUNT.SUP ID.SUP COL.SUP NOPAGE"` in a shell script and assign its output to a env variable. In English, I want to manipulate the directory path for a passed Project n...

We requested an enhancement that would prompt when viewing data from an OCI stage for a set of values corresponding to the where clause. That would be nice from a troubleshooting point of view.

I didn't have this problem while saving a job rather while trying to view data from a OCI9 stage. The problem was a column defined as varchar was attempting to map to a CLOB field in Oracle. Sounds completely different then your case but my point is to suggest that you verify that you have no "...

In the transaction Handling tab, I assume you have rollback for On Fail?Do not have the reject checkbox checked? If, so I would uncheck it, in fact I would never use it. If the first link fails and transaction handling is enabled, why would it bother with the second link? Logically, you would never ...

Assumptions 1. This is not a batch job and maybe two jobs isn't appropriate. 2. You want transaction control for some foreign key constraint reason. I prefer to use REJECTEDCODE because REJECTED includes the constraint. You can easily interrogate the REJECTEDCODE from each of the output links in a t...

1. Define the job as multi-instance from the properties window.
2. Tack on a "."<identifier> to the DSRunJob command. Example:
DSRunJob <JobName.001>

Great Tip! I tried a simplified version and it works. The routine in the Initial Value of the stage variable only executed once.
Thanks!

Reason Numero Uno:DataStage has weak Transaction Control. We use Stored Procedures as one part of our Transaction Manager Two-phase commit functionality. It greatly simplifies the ETL job design although I completely agree that you lose the GUI metaphor. It was pretty much lost anyway since updating...

I can't help you with Windows, I'm UNIX but... I'd guess the problem is with MQ. 1. Can your DS User MQBrowse the queue from the command prompt? 2. Is the Queue Manager on the ETL Server? 3. The warning concerning no terminating condition means you've not defined a way for the job to terminate. The ...