DSXchange

Hi all,
is it possible parallel execution of several jobs loading into B.W.?

Thanks in andvance.

Riccardo Tani
Staff Consultant
Direzione Industria e Servizi
Datamat, Enabling Your Future
Rome, Italy
phone: 0039 (0)6 50272702
e-mail: rtani@datamat.it

THERE IS NO UNIX (server) SIZE EXPORT IN DATASTAGE! YOU MUST INCUR ALL NETWORK OVERHEAD GOING BETWEEN YOUR PC AND THE SERVER. THERE IS NO METHOD IN THE BASE DATASTAGE PACKAGE. SORRY. HEAVEN FORBID YOU ARE DIALED-UP ON A 56K MODEM. ALL EXPORT LOGIC IS IN YOUR GUI Manager client (fat client model inst...

Sorry, you got me there ! Maybe someone else knows ... ? -----Original Message----- From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt] Sent: Wednesday, October 17, 2001 4:01 PM To: datastage-users@oliver.com Subject: RE: Export only one Job Thanks Dirk, but there any utility that enables that in Unix s...

Thanks Dirk, but there any utility that enables that in Unix shell? I have read the dsexport parameters and seems like it cant do that. -----Original Message----- From: Dirk Moolman [mailto:dirkm@reach.co.za] Sent: quarta-feira, 17 de Outubro de 2001 14:35 To: datastage-users@oliver.com Subject: RE:...

Nuno: If youre on UNIX, write yourself the following shell script to run the DataStage tools program: UVHOME=`cat /.uvhome` . $UVHOME/dsenv cd /DataStage project directory Hi all, > > What are the options to unlock a locked job? > Do we have to kill all sessions and reset DataStage? > > Thanks in ad...

It can be done yes. Datastage Manager - Export - Datastage Components On this screen you can choose if you want to export the "whole project" or just one "job design" Ive done this succesfully. You might have to go to Options and enable (click) "By individual component". I had to do this because my ...

That single parameter is a string. It can contain any value you please. Including delimited values that the routine itself can parse. -----Original Message----- From: Ricketts, James [mailto:JAMES.RICKETTS@POLK.CO.UK] Sent: Wednesday, 17 October 2001 17:38 To: datastage-users@oliver.com Subject: Bef...

Hi, Im not using Datastage for the moment so I cannot test, but if I remember right it should be possible to define a function and therethrough send multiple variables to a routine. The command is something like "deffun"... I cannot remember but You could search in the help, there should be somethin...

.... and just for interests sake, we are using DS 4.2.1.R2 on HP-UX 11.00 -----Original Message----- From: Dirk Moolman [mailto:dirkm@reach.co.za] Sent: Wednesday, October 17, 2001 12:18 PM To: datastage-users@oliver.com Subject: RE: OCI Stage - Insert then Update Vs Update then Insert I have also h...

I have also had problems with insert/update & update/insert. I now split the update / insert in all my jobs. I will still create one job, but with a source file and a lookup (which reads from the target). I then have 2 outputs, one for insert and one for update. In the tranform, if the record exists...

Right idea, but... The #parameter# construct will only work if it is directly referenced in the call of the routine, which doesnt get you around the one parameter limit. You could still use the idea of a job parameter, but inside the routine, call DSGetJobInfo to check if the required job parameter ...

I think the logic of insert/update goes something like this ... Try the insert If number of rows processed = 0 then Do the update Conversely, the update/insert is like this: Try the update If number of rows processed = 0 then Do the insert It is my understanding that DataStage does not report the er...

Hi all, today i have noticed similar problem. When i use Insert new rows or Update existing rows OCI stage does not insert new rows while if i use Update existing rows or Insert new rows OCI stage inserts new rows. This is curious!!! I am running DS4.0 on Bull/IMB-AIX. Regards, Ricccardo ----- Origi...

Hi All Ive noticed something curious with update actions Insert new rows or update existing rows versus Update existing rows or insert new rows. We have a target table with all columns defined as not null. The source file have several rows where some columns are empty string/null. Therefore, Id expe...

Hi All Im trying to import a SQL Server 2000 stored procedure definition but keep getting: Parameter @RETURN_VALUE in stored procedure dev.dbo.usp_Reports_DataStage_Quality_Summary;1 is defined as type 5, which is not supported in DataStage. Definition not imported! What does the above mean? This sp...