DSXchange

Thank You All for your contributions. We are discussing it with our Account Manager. Thanks Jack ----- Original Message ----- From: "Bibhu C" To: Sent: Tuesday, July 24, 2001 1:03 PM Subject: Re: Licensing Issue Going from 4.0 to 4.2 > Jack, > > There is a "Users" value you would need to enter when ...

Ok, im convenced, the script will be the best choice. Thanks all! -NSP -----Original Message----- From: lamont.lockwood@ascentialsoftware.com [mailto:lamont.lockwood@ascentialsoftware.com] Sent: segunda-feira, 23 de Julho de 2001 18:58 To: datastage-users@oliver.com Subject: RE: Delete Statement The...

2nd request.

PLEASE REMOVE ME FROM THE MAILING LIST

____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie

Jack, There is a "Users" value you would need to enter when you install the DataStage components in 4.x versions. This value is probably 2 for your license. HTH Bibhu --- Jack Luchjenbroers wrote: > Hi, all > > I have a client that has upgraded from Datastage > 4.0 to 4.2. > > Now that they have upg...

The Oracle OCI8 plugin in DS 4.2 has an After SQL tab. I agree, though, about the sequence-of-events processing. If you have a SQL failure, do you still want to do the exchange? From HELP: "Before. This tab contains the SQL statements executed before the stage processes job data rows." -----Original...

Absolutely do this outside the datastage job. You must separate the job from this kind of work, it makes development incredibly complex when testing, because it keeps doing the partition exchange. Use batch jobs to control and orchestrate job execution, you can then put SQL, unix scripts, whatever, ...

Andrew, my situation is something like this: I have a process that writes to an oracle table by the ORAOCI8. After this, i want to execute a exchange partition, but i have no post sql box in stage to execute the statement. Do you have any suggestions? Thanks! NSP -----Original Message----- From: And...

This is a topic for an orphaned message.

Everyone do yourself a favor and execute all SQL, stored-procedures, etc from a batch job rather than inside a job design. Your life will be much easier. Its simple, just use code like the following. For SQL scripts, just stick them inside a shell script or batch file that does the connection to the...

some of the stages have post and pre sql boxes, you can execute sql before or after the stage starts or finishes. it depends on what you want to do, and to which database. Andrew Webb Principal Presales Consultant Ascential Software Changing the Way the World Looks At Information www.ascentialsoftwa...

Or, if i want to make a alter table instruction? Where can i execute that? -----Original Message----- From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt] Sent: segunda-feira, 23 de Julho de 2001 16:03 To: datastage-users@oliver.com Subject: Delete Statement Hi, I want to execute a delete statement, for ...

Hi,

I want to execute a delete statement, for example: delete * from tab;

How and where may i execute that in DataStage?

Thanks in advance,


NSP

if you only have a 2 developer licence then 4.2 will only allow you to connect 2 at once (full licensing was not enforced before, it is now). check what your licence limit is, if its more than 2, then contact support since it should allow all your purchased users to access the server. Andrew Webb Pr...

lorry, Metastage itself only runs on windows environments. The process metabroker will run on unix (since its a java class). were currently at release 2.1r5 of metastage. There is specific version for unix. maybe if you want to email me offline I can tell you if specific things have changed. Andrew ...

There is no MetaStage on Unix. The directory database can be anywhere you want, Oracle on Unix, SQL-Server on NT, whatever. The application is still a Windows based app that is bound by the CPU, memory, and disk of your desktop. I suggest you send your complaints on to Ascential.... -Ken lorry.siro@...