DSXchange

Have you considered exporting the project and using an editor or other software to edit the export file? It wont be easy, but it might be worth a look. -----Original Message----- From: Riccardo Tani [mailto:riccardo.tani@datamat.it] Sent: Friday, 3 May 2002 6:47 PM To: datastage-ML Subject: Re: ALL ...

Thanks Ray! Ive made this question cause a customer of our as a problem with OCI derivation on DS5.1. They have upgraded from DS4.1 to DS5.1 and, as you know, the newest OCI release built the select reading, first, from the derivation and then, if the derivation is blank, reading from the column nam...

We will have to develop several jobs loading flat file to Oracle 91 database. Files will be Ascii encoded, but could be in French, English or Scandinavian. Im afraid that several Scandinavian character could exceed 1 byte - do we need use NLS? DataStage 5.1A HP-Unix 11i Oracle9i Thanks for help, asa...

Have anybody implement DataStage 5.1a with Oracle 9i? Could it works? Which
version of drivers do we need?

Kasia

Having limited space on the server is bad in lots of ways for DataStage. See what you can do to make more space. Things like log files and the files in the &PH& directory grow (that is why you must prurge them from time to time). The on-disk copy of in-memory hashed files also takes up space. As the...

The answer is NO. The only field names you can retrieve are those that the designers deigned to put in the file dictionary. In the case of the DataStage repository the decision to omit most field definitions was deliberate. Once upon a time (DS 4.0) I did work my way through the respository tables, ...

Hi Jain, Assuming the source directory, file and fifo exist and are readable/writeable, then the following code snippet will work on Unix for three known file extensions (you can extend to include, for example uuencoded files (extension .uue???)). Note that you must redirect to the fifo, not pipe to...

Guys, Fortunately, I need to run everything on Unix server. I created named pipe with mkfifo command and now in the file stage I defined that named pipe as input file. But the question is How to I write the data into named pipe, before using file stage. Whenever I try this command on Unix cat filena...

alot of the compressors/uncompressors are zip compatible (certainly alot of the linux ones are). so if your on unix.. run one that zip compatible, I think gzip is one... stream it into a named pipe read it from the named pipe, or like steve said.. version 6 supports just that sort of functionality, ...

This is actually physically impossible due to the fact that WinZip on Windows wont let you target a pipe /sysin with its output. You have to touch it down to disk. (I know this because Ernie and I were testing out the new filter stage in 6.0 and we were hoping to do just this with it. (Ernie discove...

Dinesh, No, there is not any plug-in to read a zip directly from DataStage. You need to unzip the file first. You could try to read across a network with an NFS mount. Chris -----Original Message----- From: Jain, Dinesh X [mailto:Dinesh.X.Jain@questdiagnostics.com] Sent: Thursday, May 02, 2002 11:52...

Hi all, Id like to know if there is a way to get ALL the fields name of an hashed file (i.e. DS_JOBOBJECTS). I know that the command "LIST DICT " return only some fields. How can I get COMPLETE structure of an hashed file (i.e. DS_JOBOBJECTS)?? Thanks all in advance Regards, Riccardo Tani Staff Cons...

You may be able to use the Target Stages Before SQL. You could then use the Target Stages After SQL to reactivate the index(s). The Before & After SQL is only acted upon once, prior to the first record being and after the last record handled in the Target Stage, respectively. Thanks, Lester F. Calli...

Is there a way to specify Oracle session parameters at the start of a Datastage job. For example: 1) to specify a specific rollback segment for the job. 2) alter index index_name unusable; etc. Thanks in advance RL _________________________________________________________________ Get your FREE downl...

Hi,

From the datastage I need to read zip file directly, beacuse of space constraint on the server. Is there a plug-in available to do that of someone has already done it?

Dinesh Jain