DSXchange

Posted: **Tue Mar 13, 2001 1:39 pm**

Good morning,

Im trying to perform some modifications in a Oracle database and the only way i have found to do it is to call sqlplus from a script in datastage.I develop under Windows NT but the call to sqlplus is done from a call to UNIX. What happens is that my job becomes not responding after a few seconds and though i cant perform the task i want it to do.

Is there anybody who has some information about the use of sqlplus from a datastage script.

Tanks a lot for your response.

Stephane Beaudoin

Posted: **Tue Mar 13, 2001 2:04 pm**

Why cant you use ODBC through UniVerse BASIC?
May be (I dont know) its slower but works fine.

-----Original Message-----
From: "Beaudoin, Stephane-DWH"
To: informix-datastage@oliver.com
Date: Tue, 13 Mar 2001 08:39:40 -0500
Subject: calling sqlplus from a basic script in datastage

>
> Good morning,
>
> Im trying to perform some modifications in a Oracle database and the
> only way i have found to do it is to call sqlplus from a script in datastage.I develop under Windows NT but the call to sqlplus is done from a call to UNIX. What happens is that my job becomes not responding after a few seconds and though i cant perform the task i want it to do.
>
> Is there anybody who has some information about the use of sqlplus
> from a datastage script.
>
> Tanks a lot for your response.
>
> Stephane Beaudoin
>