DSXchange

Hi again, Actually, I lied below. There is one issue when upgrading. In version 3.6.3, the hash file stage allowed you specify columns with the Primary Key field set to No for all columns. This is not permitted in v4.2, the first column (first n columns) must have Yes in the Primary Key field. The u...

Peter, I dont know what version of D/S you have, but from v4 on (I think) the SYBASEOC stage has a Before and After tab in the SQL tab. These are for SQL to be executed once before any row-processing takes place and once after. Job Parameters can be put in the SQL code. So, if you do not want to use...

Hi Stashima, As far as I am aware, there are no upgrade issues for HP_UX to 4.2.1r8 - except, of course, that its for HP_UX 11 only! However, version 5.2 should be available in Q1 2002. The improvements in performance/usability are quantum (especially with the Accelerator Pack). You may want to save...

Hi, All!

Does anybody have competitive comparison between DS & OWB. I need it as soon as possible.


Thanks in advance,Alexandre Stoulov
------------------------------
Consultant. Business Intelligence Projects
TERN Company
mailto:alexs@tern.ru

Hi there! just for information, Ive replicated exactly your error by accident re-nameing the "projects" directory on the server. So maybe the problem is that your projects directory isnt foundble by DataStage where youve declared during the installation. Check the projects directory, maybe somethink...

Thanks for the reply, Datastage system management is done in UK, so I forwarded this mail to them and maybe they will contact you . regards Luc -----Original Message----- From: John Campbell [mailto:john@jcbase.freeserve.co.uk] Sent: Thursday, November 22, 2001 10:08 PM To: datastage-users@oliver.co...

Hi, In order between trying to start DateStage 1, Check that all the settings are correct in the login box: Host System, Username and Password 2, Check caps lock is not on 3, Check the UV/DS serves are running 4, Check you have used the correct login when starting the computer for whether you are wo...

Hi, when trying to logon to Datstage we receive the following error message Failed to connect to host: hostname project : projectname The directory you are connecting to is either no a UV account or does not exist (39125) Has anybody experienced this problem before and has a solution for it. thanks ...

Peter, We use Oracle and I feel pretty much the same way about ODBC. However, the flexibility available through job control code with BCI is very useful. As a result, we only use ORAOCI8 stages when accessing Oracle from transform stages, but use ODBC extensively within job control. We have adopted ...

Be careful that there may be licensing issues with the Merant ODBC drivers. The ones supplied with DataStage are licensed to be used by DataStage itself. This is, for example, why the DS_CONNECT utility has to be used to test a connection rather than the CONNECT utility. -----Original Message----- F...

Thanks for that.... My preference is not to use ODBC as all our work currently uses the Sybase Open Client drivers directly through the Syabse plugin. After looking at this document, ODBC seems a requirement. -----Original Message----- From: Ray Wurlod [mailto:ray.wurlod@Informix.Com] Sent: Thursday...

This is a topic for an orphaned message.

Why not enrol in "Programming with DataStage BASIC" class, where BASIC SQL Client Interface is among the topics taught?

Hi, It can be possible by writing a routine to execute SQL statements and the routine can be called in Before/After job subroutine or Job control. Name of Stored procedure would be passed as parameter to the routine. Regards Saravanan Peter Oates cc: Subject: Calling Sybase Stored Procedures from a ...

(continued) - hit Send too quickly To send SQL from a routine, you need to use the paradigm of the ODBC API, which is manifested in a set of functions collectively called the BASIC SQL Client Interface. Complete information about this interface is in the BASIC SQL Client Interface manual, which may ...