DSXchange

Hi Mark, i dont think it is a plugin problem, ive used OLEDB to connect to SQL Server 2000. Which MDAC (Microsoft Data Access) version is on your Datastage server?? OLEDB Plug-in requires MDAC 2.1.1 or later. Regards, Riccardo ----- Original Message ----- From: "Ewart-Phipps,Mark" To: Sent: Tuesday,...

Thanks Himansu and Hendrik. I have however tried all you have suggested and still get the same problem. Is it perhaps an version problem i.e. DataStage 4.2 OLEDB plugin is for Sql 7 and not for Sql 2000? If this is the case, where can I download the latest plugin version from? Mark Ewart-Phipps Data...

Weve been experiencing the same error intermittently when using the dsjob -jobinfo command from Solaris 8 /DS 5.1 It seems to occur when there are multiple jobs running on the server. Under instructions from Ascential support, we are running the unirpcd as a foreground process to a log file to trap ...

Hello Rui, Have you contacted Ascential Software Support? Error 39202 is an error that comes from the connectivity layer of DataStage... documentation details it as follows: 39202 IE_SR_GA_FAIL Slave failed to give server the Go Ahead message The "Slave" is on the DataStage Server end which for some...

Richard, Unfortunately, as far as I know you are stuck with the pat answer of "thats the way it works". The Scheduler portion of the Director reads the crontab entries (on a Unix server, anyways) for the user you are *logged in* as. If you allow multiple users to log into a project and schedule thin...

Hi We have, DS 4.2.1, and now it occur an error ( 39202 ), when we try to logon to the project.We cant access to any project. We check space, premission, check environment variable settings in dsenv and check uvrpc port status, but everiting are OK . What could be ? best regards Rui Soares Rui Soare...

Since youre in a routine, why not read the last line of the file? Assuming youre on UNIX: Command = "tail -1 /dir/File.log" Call DSExecute("UNIX", Command, Result, ExitStatus) If ExitStatus = 0 Then LinesLoaded = Oconv(Result, "MCN") Ray Wurlod Trainer - Asia Pacific Region IBM Informix Training Dep...

i can second that. Ive worked on site with customers using the 8i plugin/libs to talk with 9i, seems to work transparently as if its talking with 8, although talking with 9i at the other side. Id also be tempted to check using the 9i libs, I dont remember us actually putting 8 libs onto the box (it ...

Id suggest that you load *both* clients so that you have the normal 9i client for working with the database, and the 8i client for use strictly by DataStage. Do this by setting your ORACLE_HOME to the location of the 8i client in your dsenv file, and dont forget $ORACLE_HOME/lib in your LD_LIBRARY_P...

You may want to go into MS Sql Server Client Network Utility and see if the server you are trying to connect to is defined there. In one of my jobs, the server i need to connect to had to be defined by ODBC and via the client network utility. himanshu patel -----Original Message----- From: Ewart-Phi...

Hi Guys Im getting the following error when I try to run a job that contains an OLE DB connection (DataStage 4.2): OLE DB provider error HRESULT=0x80040e4d when using Microsoft OLE DB provider for SQL Server. In designer, the Test Connection works. Designer can also see the database. However, when t...

We use a shell script, launch with the DSExecute routine. In the shell we do a connection to the Oracle database and then call the procedure. Before the command line for the connexion we put : whenever sqlerror exit failure rollback whenever oserror exit failure rollback If the procedure fails we ha...

Perhaps you have a Call DSLogInfo in your routine, taking the sql*loader command being executed ? We have one in our ExecOraLoad routine, and the best way is to omit it (with *) Kasia At 10:52 18/03/2002, you wrote: >The output of my job goes to an Oracle Bulk load stage. As you know >this will crea...

Thanks -----Original Message----- From: Kasia Lewicka [mailto:katarzyna.lewicka@cgey.com] Sent: 18 March 2002 11:44 To: datastage-users@oliver.com Subject: Re: Password passed to log Perhaps you have a Call DSLogInfo in your routine, taking the sql*loader command being executed ? We have one in our ...

The output of my job goes to an Oracle Bulk load stage. As you know this will create the control file and the data file needed for loading into an Oracle table via sqlldr. I am invoking sqlldr in the after-stage subroutine of the same BulkLoad stage by running the ExecDOS routine with the input valu...