DSXchange

Tom, have you considered using user status instead, you can get access to this from both sequencer and batch control jobs. Simon. ----- Original Message ----- From: To: Sent: Monday, July 07, 2003 9:14 AM Subject: Job return codes > Hi, > > I have a job, and need 3 types of return-values. > 1: OK (1...

Sorry, I dont have any experience with the ORAOCI9 plugin - yet. As for transaction size 0, that should be fine, provided: * Your insert and your update links are going to the same OCI stage (otherwise the updates wont see the prior inserts) * You dont have so many updates that you are going to blow...

Have you thought about DSSetUserStatus and DSGetJobInfo? Refer to the help for details. -----Original Message----- From: tom.peter.nielsen@nordea.com [mailto:tom.peter.nielsen@nordea.com] Sent: Monday, 7 July 2003 6:14 PM To: datastage-users@oliver.com Subject: Job return codes Hi, I have a job, and...

Hi, I have a job, and need 3 types of return-values. 1: OK (1) 2: OK (2) 3: failed How can i return the two different types of OK to the scheduler ? I need to determine with job to start, depending on the result of the job, and im not very keen on using DSJobRun routines. - Tom ---------------------...

Thank you very much David, Im using ORAOCI9 and i have set my transaction size to 0. >From: David Barham >Reply-To: >To: "datastage-users@oliver.com" >Subject: RE: Array size and update link >Date: Fri, 4 Jul 2003 11:32:21 +1000 > >I think the easiest solution for you is to send your insert and upda...

Hello,

does someone work with Oracle and PX ?

Benoit.

Ive stopped the and started the uniware services and everything is working fine now. Thanks "David Barham" on 03-07-2003 14:49:07 Please respond to To: cc: Subject: RE: Oracle error That means you have a problem with your database or a configuration problem with the listener on the Oracle server. Yo...

A couple of points. I suspect youre working from the version 3.6 manual for writing plug-in stages. The macro definition DSCVersion360M is for version 3.6. You need to be using DSCVersion600M for version 6.0. Better is to use DSCCurrentVersionM (see dscapi.h). Do you have a copy of the "DataStage Pl...

This is a topic for an orphaned message.

I think the easiest solution for you is to send your insert and update links to the same OCI stage. That way, it will only use a single connection/transaction and the updates will see the uncommitted inserts. To be honest, I havent experimented with what happens when two links go to the same OCI sta...

Conventionally the key columns are listed first but they dont have to be. What you do have to get right, in the Hashed File stage, is the Position. In the Columns grid (you will need to scroll right to see it) are three columns called Position, Type and Assoc. If Position is 0, that column is a key ...

You should stage your inserts and updates to files first. If you have pure updates, you should bulkload them. This is always faster than OCI, especially if you could use something like sqlldr with direct path option. You have limited your ability to instantiate your job and do parallel inserts and p...

Hello All, I have 2 links and 2 OCI stages, one for insert and one to update the target table. Insert OCI has an array size 1000 and update OCI has an array size 10000. Also insert link has execution order 1 and update link has it set to 2. Is there any way I can make sure that before sending all 10...

Please remove me from the DataStage mail list Larry Pedigo ------Original Message------- From: Moderator Sent: 07/01/03 06:04 PM To: datastage-users@oliver.com Subject: MONTHLY POSTING - DataStage Users List > > MONTHLY POSTING - DataStage Users List As of 1 July 2003 the DataStage Users discussion ...

Thank you David! Leonid "David Barham" To: cc: 07/03/2003 08:19 Subject: RE: Edit characters AM Please respond to datastage-users The issue is not how to do it in DataStage. The issue is what Excel expects. Control B is a keyboard shortcut for Bold in Excel. This has nothing to do with how BOLD is r...