DSXchange

In the UniVerse (or DataStage Engine) environment, to which you can connect (because you are on a Windows platform) using telnet, there is a program called CONNECT. This allows you to act as an interactive user with the ODBC DSN (provided everything has been set up correctly, particularly the uvodbc...

Hi

We are starting a project, where we need to extract some information from BAAN, did anybody have try it, with Datastage ?

Best regards
Rui Soares

Thanks for the answers on the CREATE.FILE command. I forgot about the DSExecute function. I have another one for you gurus... ) I found a pdf document called Basic SQL Client Interface Guide. It explains how to access Sybase and Oracle through ODBC using the CONNECT statement. Has anyone ever try th...

Modesty forbids... But, yes. Craig_Hulett@rsau sa.com To: cc: 02/07/2002 09:37 Subject: RE: How to create a hash file in a job control? Please respond to datastage-users Unsupported yes, but very nice. If I recall, you are the author of that particular utility, are you not Ray? Yet another legacy yo...

Unsupported yes, but very nice. If I recall, you are the author of that particular utility, are you not Ray? Yet another legacy you leave behind. "Raymond Wurlod" To: Subject: RE: How to create a hash file in a job control? 07/01/02 05:10 PM Please respond to datastage-use rs Experience has shown th...

Experience has shown that some performance gains can be had, particularly for large hashed files, if static rather than dynamic hashed files are used. While this is somewhat outside the scope of the original question, I felt it was worth noting. There is an unsupported utility (hashed file calculato...

Try using any number of ways: Inside BASIC you can execute command line statements EXECUTE "CREATE.FILE YOURFILENAME DYNAMIC" CAPTURING ScreenOutput RETURNING SystemReturnCode Or use the DataStage API: CALL DSExecute("TCL", "CREATE.FILE YOURFILENAME DYNAMIC", ScreenOutput, SystemReturnCode) Both ret...

universe help will show have to pass the other params needed when creating the harsh file. or better yet, create the one file and clear it before each use -----Original Message----- From: Pelletier, Christian [mailto:CPELLETIER@probusiness.com] Sent: Monday, July 01, 2002 2:03 PM To: datastage-users...

Is there a way to dynamically create a hash file in a job control?

I can Open, Read and Close a hash file, but it seems that the CREATE.FILE command is not available in DataStage Basic. It only works in the Command Line Interface (CLI).

Thanks for any input

Christian

Hey Ray... This is good and bad news - but there is a redbrick list you could subscribe to: redbrick-list@iiug.org Its not as busy as datastage, but its a list at least, so you wont suffer any serious withdrawal symptoms. denzil -----Original Message----- From: Rom Linhares [mailto:romulo.linhares@a...

I am saddened to see someone who has made such a contribution of time and effort leaving... Specially for these reasons. Ray, I wish you the best. Good luck... and obviously: hope to see you soon back on the list. Cheers, Rom -----Original Message----- From: Raymond Wurlod [mailto:wurlodr@au1.ibm.co...

The link to Compile All has been emailed to the address in your member profile. Sorry about the inconvience.

Use ODBC stage versus an OCI stage in a DataStage job. Some background. An Oracle OCI stage is a native connection to Oracle from DataStage, that is it uses the Oracle SQLnet connection to the database. Similar principles also apply other to other native database connections (Eg Informix CLI or Syba...

Not quite, Mark. Brian Gray remains as a primarily U2 trainer; it is he who has picked up RedBack and MITS while I have been "distracted" becoming a guru and evangelist for Red Brick Warehouse. Also, Anastasia Patsakos (sales) spends pretty much all of her time working with our U2 community. To be b...

likewise, good luck ray... thanks for your help on the list.. all the best for the future... Andrew Webb Principal Presales Consultant, Ascential Software Profit From Intelligent Information www.ascentialsoftware.com Mobile : +44 (0)777 5762347 Direct : +44 (0)20 8818 0717 Fax: +44 (0)70 3115 2220 A...