DSXchange

Thanx to all your responses. Here I did not using Pivot Stage, bcos we dont have Pivot plug-in here and we cant use this also. And we are implementing of all jobs with OCI plug-ins only include LOOKUPS also. I have taken 11 Ref. Streams here and passed to Transformer Stage. But my problem is Perform...

This is a topic for an orphaned message.

> Hi all, > I want to ask is there any problem if I opened a hashed file as a > reference (to read from ) in 10 jobs at the same time? > and is there any problem to open another hashed file for writing from > 10 jobs at the same time taking into consideration that the jobs dont > overwrite each othe...

Hi, Data Stage Gurus! Please say is it possible convert files such as DS_JOBS, RT_LOGS and so on to UniVerse tables? Will it crash my system or not? I know this may be a stupid question, but if it can be done I will get an access to DataStage system information through ODBC and read information abou...

Hi, Would like to post a question for DataStage Gurus. We installed DS server (Version 4.0) in Windows NT and DB2 in AIX server. Is it possible for us to use UDBLoad to load (Bulk Insert) the data into DB2 server from the ETL job?. If Yes, can you please let me know how to configure the AIX environm...

This isnt directly a datastage or U2 issue, but I know a few folks here work with Oracle and wonder 1) whether anybody might have dealt with this problem and be prepared to share their solution/experience or 2) whether there is a consensus on the best newsgroup/discussion forum/mailing list for Orac...

Look at the "start" command to start a command in a separate Window. Also look at creating a BAT file to provide any necessary input - the BAT file can parse its own command line (and thus receive arguments from DataStage). Ray Wurlod Trainer, Asia-Pacific region IBM Informix Education Department Le...

Just to add a different perspective - Ascential engineering and product management are well aware of the differences between the ways transforms and routines operate. Not to mention several other areas within the DataStage XE server engine where performance improvements can and have been gained. Som...

Well, yes, you do use the corporate exchange server, but we dont have workstation tools like Outlook installed on our DataStage server. Running NT commands from DataStage that never end is sometimes indicative that they are trying to do some sort of user interaction. To test that idea out, you could...

What we did is: to create an .exe file in VB (which basically does almost all the job of sending the e-mail) and then try to call it from the after-job subroutine, what we failed to do is to find a correct Input Argument in order to run the email.exe .... The email.exe starts but it never ends.... T...

Blat for Windows is freeware. m -- Regards, Clif ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ CLIFTON OLIVER & ASSOCIATES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ W. Clifton Oliver, CCP P.O. Box 712470, Santee, CA 92072-2470 USA Tel: +1 619 596 0454 Web: www.oliver.com Friday, March 29, ...

We have exactly the same situation as you. You need to download a command line SMTP mail client - there are many around - just do a search on the Internet. One of the parameters for the mail client is the name of you mail server (in this case, your Exchange server). You do need to make sure that Exc...

Seeing as someone opened up this can of worms ... Ill add my 2 cents worth. So far, everyone has been talking about performance (notwithstanding Rays useful comments about multiple transforms calling the same routine). While I will concede that the inline code of a transform has less overheads than ...

It is highly unlikely that anything has changed in release 5.1, for the following reason. A Transform becomes in-line code when a job (Transformer stage) is compiled. You can even view the generated BASIC source code if you know where to look. A Routine continues to have a separate existence. It is ...

ok... as far as Im concerned.... IF an expression or piece of logic will fit into a transform.. put it there. If the logic is too complex to be fitted into a single line (and youll be surprised at what, with a little fiddling you can get into a transform) then use a routine. BUT ALWAYS if you can, p...