DSXchange

Greetings, Im new to this list, so a little late with a reply but the last piece of advice isnt quite correct. The Aggregator only expects the input rows to be sorted if *you* tell it they are sorted. You tell it by filling in the Sort column. This lets the stage know the data is already sorted in t...

Hi all, I am using a DB2 Stage as a lookup stage(dont know why) to load to the same table. In transformer it looks for Key Columns(Key and FromDate) and the Criteria to load the table is: if ID is Null then load. Table A structure is: Id Integer Key char(8) FromDate Date Lookup Table A | Sourcedata-...

Hi all,

I want to make a routine that returns the value of a database sequence.

Where i can find the functions to do that?
There is any function that executes a select statement?


Thanks in advance,

NP

Hi all, In order to avoid a lot of complexity in our datastage programs we have implemented database triggers (before/after insert and update logic). Now we have the problem that these triggers create a lot of warnings (there is no way to avoid this). Is there a way to tell datastage director to ign...

Hi,

Has someone been editing the uvodbc.config file in a server project directory, or in the ServerEngine directory? Ive seen similar when people have changed the entry.

Regards

- Chris Thornton

Situation we are having is on two servers running Datastage (One currently Production, the other DR) Message we got tonight on the production server was when the first datastage job ran. UniVerse/SQL: Failed to establish internal local connection. We have also found if we tryto run a Universe sessio...

Thank you Ray. I assume that I wont have control over the transactions then. Datastage will pass the record to Redbrick which will either accept or reject the record - end of story. Pity, it will make life a bit more difficult when a job aborts and I have to restart the job where it left off ..... T...

Red Brick Decision Server is a database designed from the ground up for data warehousing. As such, it does not have row level locking and does not have transactions. Therefore it does not have the concept of commit. In a sense, every INSERT, UPDATE or DELETE is auto-commit, with no choice. Most user...

We are writing our data to Redbrick (datawarehouse). Im not very familiar with Redbrick yet, so Ill have to find out if I can set an option like this on the DB. Thanks Dirk -----Original Message----- From: Jason Mulvin [mailto:jmulvin@fuse.net] Sent: Monday, October 22, 2001 9:38 PM To: datastage-us...

I tried this out and if yourre quick you can catch the parameters being passed on the DSRunJob call; using the ps command: eg. psmith 14100 14098 1 10:59:52 ? 0:00 phantom DSD.RUN jtwhDimCustLoad 0/50 pDBPasswd=secret: pSourceServ -----Original Message----- From: Riccardo Tani [mailto:rtani@datamat....

Fixed.....Works a dream ! -----Original Message----- From: Ray Wurlod [mailto:ray.wurlod@Informix.Com] Sent: Wednesday, 24 October 2001 10:29 AM To: datastage-users@oliver.com Subject: RE: Unix env variables It may be that there is a line feed on the end of the captured output. This will have been t...

It may be that there is a line feed on the end of the captured output. This will have been translated to a "field mark" by CAPTURING. (I forgot about this gotcha.) Try: EXECUTE SH -c "echo $HOME" CAPTURING EnvHOME Call DSSetParam(hJob, "MyHomeDir", Trim(Convert(@FM,"",EnvHOME))) -----Original Messag...

Thanks for that Ray...it seems to work. Im having problems with the DSSetParam in that it returns -4 - not happy with the value being set - even though the Parameter is type String. -----Original Message----- From: Ray Wurlod [mailto:ray.wurlod@Informix.Com] Sent: Tuesday, 23 October 2001 2:53 PM To...

It now behoves you to analyse WHY your batches "never end". Do all the controlled jobs complete successfully? What else does your batch do? Can you code a timeout check near the end of the batch, that checks the status of all controlled jobs, and ends properly if they have all finished? (That it doe...

That worked.. Thanks!!!! jason -----Original Message----- From: Doris Zammit [mailto:Doris.Zammit@oit.state.nj.us] Sent: Tuesday, October 23, 2001 3:11 PM To: datastage-users@oliver.com Subject: Re: runaway batches Hi Jason, Ive had a similar experience with a never ending job run. What I do is sele...