DSXchange

Hi, folks We have DataStage6.0 instlled. I am trying to use ORAOCI9 plugin as the source output. I find I must construct the sql script by using "Build..." option, otherwise it doesnt work if I use "User-defined SQL query" option by directly typing sql statement manually. Furthermore, after construc...

Siva, you have to license parallel extender. If you have a Sun, HP, or AIX machine (leave any out?) you can option to purchase Parallel Extender. In a nutshell, Ascential bought a company with a high-volume ETL tool called Orchestrate. They renamed it DataStage Parallel Extender. They then created a...

Yes, this is so. The upgrade process will upgrade and recompile all of your jobs and routines. OTOH, if youd like to do (or redo) this yourself, download the excellent "CompileAllPlus" from the DSXchange website - here is a direct link to its download page: m Note that youll need to "join" first, bu...

There is a separate manual, "Parallel Job Developers Guide" (768 pages), in the Docs folder. This takes you through the process. The main thing you need to know is that Parallel Extender can not execute server jobs; they have to be put into containers. The main mindset change is that PX uses the con...

This is a topic for an orphaned message.

There has been some confusion within Ascential as to the number of the next release, which has been called the "Twister" release while under development. Some held that it would be 6.5, others that it would be 7.0. It now seems that it will be 7.0. As to release date, the aim is definitely before th...

Hi Gang, Were currently using DS 5.2r1 on Windows 2000. We are upgrading to DS 6.0r3. As part of the upgrade process, do we still (and more importantly, is it a good idea?) have to recompile all of the routines and jobs? I was told by Ascential that it isnt necessary, the upgrade process will take c...

What kind of info are you looking for?
Siva wrote:Hi,

Could anyone know how to use Parallel Extender in Datastage Verison 6.

Thanks
Siva

The is my next test, but I have not had the time to do it. The OLE DB provider is the one that Microsoft Provides for SQL Server so I am fairly sure that it is ok (but I have not yet put that to the test). -----Original Message----- From: Ray Wurlod [mailto:rayw@mindless.com] Sent: Wednesday, March ...

Return Receipt Your Multiple instances document : was Carlos Pimentel/Madison/GNIC received by: at: 03/27/2003 07:12:50 AM CST

This is a topic for an orphaned message.

Hi,

Could anyone know how to use Parallel Extender in Datastage Verison 6.

Thanks
Siva

Thank you Len and Ray for your advice. Ill give it a try thanks again hp -----Original Message----- From: len.greenwood@ascentialsoftware.com [mailto:len.greenwood@ascentialsoftware.com] Sent: Wednesday, March 26, 2003 3:43 AM To: datastage-users@oliver.com Subject: RE: Datastage 6 and max columns T...

A trigger is like a stored procedure in the database on a table, so if a table was updated it could execute this trigger, such as on an insert execute the trigger which updates a field with a timestamp and another field with the user id or batch ID or something similar. We dont have to rebuild the i...

It could be as simple as a badly-written OLEDB provider. Can you perform non-DataStage OLEDB access as a comparison? (This will isolate the stage or the OLEDB provider as the culprit.) -- __________________________________________________________ Sign-up for your own FREE Personalized E-mail at Mail...