DSXchange

Dear all, Im trying to connect to a unix (compaq tru64) datastage server. The answer is an error: Failed to connect to host: XX.Y.Z.XX, project: UV (The connection has timed out (81015)) I was able to connect to this server before a firewall was installed to hide my datastage server. Now Im able to ...

This is a topic for an orphaned message.

Check out the sdk routine sdk/Utility/StringDecode for a good example. Mike. -----Original Message----- From: Vincent McBurney [mailto:vmcburney@intramatix.com] Sent: Friday, April 19, 2002 5:01 AM To: Sameh Bishara; datastage-users@oliver.com Subject: Re: Using Arrays Your DataStage installation sh...

You can do this in BASIC with the CLEARFILE statement, but to use this you must first OPEN the hashed file. For example: Open hashedfilename To filevariable Then ClearFile filevariable Call DSLogInfo(hashedfilename : " cleared", "AfterJob") End (On Error and Else clauses omitted from Open statement ...

Given that Micorsoft doesnt have a specific API for Excel, why would you bother? Youd have to build it over ODBC or OLEDB in any case. Ray Wurlod Trainer, Asia-Pacific Region IBM Informix Education Department Level 22, 60 City Road Southbank, Victoria, 3006 Australia Telephone: +61 3 9626 6624 Facsi...

You can use aliases in both generated and user defined queries. In the generated query, you need to specify the qualified column names in the derivation (although due to a bug, this did not work in earlier versions of the ORAOCI8 plugin) What version of DataStage are you using? Can you provide more ...

Hi all, I am using an OCI stage to query from 8 distinct tables and need to query from another table twice. For that table, I am trying to use an alias. For some reason the datastage job aborts. Can any body suggest how to query from alias tables and what is the work around to perform that. Thanks, ...

Hi everyone!

Do you know if someone of some third party has built a native stage to access Excel files?
( such as the OCI for Oracle -- without using ODBC or MSOLEDB stage)

Thanks

Christian

Your DataStage installation should include the DataStage BASIC Guide which has sections on dynamic arrays. One of the examples they provide for populating an array: A = "" A = "JONES" A = "SMITH" A = 1.23 A = 20 A = 2.50 A = 10 There are Dynamic Array Operations that perform special functions agains...

Ive managed to sort it, it was easier then I thought. Regu Guys, I need to write a simple Before/After Subroutine that will take a hashed file name as an input variable and clear that file. Ive been going through the BASIC.pdf in the docs directory but cant find the information I need. I dont know w...

Guys,

I need to write a simple Before/After Subroutine that will take a hashed file name as an input variable and clear that file. Ive been going through the BASIC.pdf in the docs directory but cant find the information I need. I dont know where to begin.

Help!!
Regu.

Hi Regu, I dontt know if Ive urderstood well your needed. If you need to clear an hash file by Before/After Subroutine, is really easy. As follow I send you the code of the routine, where "FileName" is the Input Argument (the file that you need to clear) Statement = "CLEAR.FILE ":FileName Call DSExe...

Robert, there is not a UniObjects connection for UniData. You can connect to UniData by using ObjectCall or ODBC For ObjectCall: (the UDT stage in DataStage) On the DataStage server verify that you have the correct protocol identified in the uniapi.ini file (you will need PROTOCOL=13) for unidata 5....

On further reflection, my earlier statement about the Director Log View was incorrect. It does not use the BCI (you will notice that the error was generated by the BCIGetNext function). In fact, the Director does not use an SQL-based mechanism at all; it relies on the Read method of a File object (n...

This one needs to go to Ascential Support, because they might want to change the default value. The error message almost certainly means that there is too much information in one row - possible a Link Report event. The UniVerse default for VarChar is 254, though VarChar actually supports up to (64K-...