DSXchange

At 10:20 PM 7/10/02 +1200, you wrote: >Yes, DataStage has an XML writer stage. Ernie Ostic from Ascential has >made mention of it in the past on this list. Perhaps you could check the >archives, or maybe Ernie is lurking. Just in case hes not... Yes, DataStage has both an XML Reader and XML Writer s...

Hello, I have a very simple job. The intention of the job is to initialize a hash file if a given condition has met. It is something like this: OCI ---------> TRANSFORM ---------> HASH Note: 1) The HASH file already has records within it. 2) I have checked the CREATE FILE option, write cache option ...

Hello,

I was wondering if anyone had any experience integrating Data Techs AccuMail or Intelligent Searchs NameSearch with their database, either using DS or not?

Thanks!

Rachel

Rachel Pedreschi
Senior Marketing Database Systems Analyst
Vail Resorts, Inc.
970-845-1909
www.snow.com

If disk space is an issue, you may want to look at moving hash files (not the log hash files) from within the project to hash files that are external to the project. See discussion over the last few days for details. Chris. Quoting Raymond Wurlod : > > The log files are actually hashed files within ...

Ive inherited this nifty little DataStage 4.1 ETL [NT] for one of our products. It loads from staging area to one of two servers (QA & Prod). Recently Ive been asked to add a third. The trick is that this new server is a Msql 2000 server while the older existing ones are 7.0. The ETL uses the SQL bu...

if you have the record ID for the Hash file, the lookups are just as fast ( so long as the hash file is sized properly ). im not sure about others, but i have not had any problems. -----Original Message----- From: Andy Burnage [mailto:AndyBurnage@Hutchison3G.com] Sent: Tuesday, July 09, 2002 11:01 A...

Does anyone have any experience with the upper limits of hash files ?? For example the trade off in time and processing between building a potential multi million row hash table, as opposed just performing the lookups against the base oracle table. All comments welcome. Thanks, Andy. _______________...

An alternate approach is to generate the sequence in DataStage itself. It avoids the OCI call and will provide better performance. DataStage comes with a sample routine that does that. Look at /sdk/KeyMgt/KeyMgtGetNextValue. You can copy the code and modify it to suit your needs. If you go this rout...

This is probably not the right forum for this and my apologies if that is
the case. Does anyone know of any DataStage or Universe job ops in the
SouthEast USA area ?

Hi every body, Can DataStage5.2 supports perl script?If yes,what is the procedure to invoke the perl script?Please help me in solving this problem... Thanks Prasad ************************************************************************** This email (including any attachments) is intended for the so...

Hi Vincent, I have tested a job that transferts (FTP stage) a fixed lenght file from UNIX to NT. It Works fine! I have opend the sequential file (notepad) and I have found out the delimiter ("|")! The difference is that Im working with DS5.2 on NT system. Riccardo ----- Original Message ----- From: ...

The log files are actually hashed files within the DataStage Repository. There is nothing to be gained from moving them, and very many things that can go wrong. Why do you want to do this? If disk space is an issue, implement a mechanism for archiving and purging the log files, or free up some disk ...

Thank You very much to

Cristina Cezon
Peter H. Reich
Himanshu Patel

You are the best !

Massimiliano

Susan, every single job has its own logfile. What is your motivation for moving it? Since the logfile is an internally controlled hash file inside the DataStage project, theres not much you can do with it. Please elaborate on your motivations. Moving the log file for a specific job is not simple, so...

Hi,

Im planning to move the location of the log file of Datastage ETL. How to do that? and what are the things that will be affected?

thanks.

Best Regards,
Susan