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
calling sqlplus from a basic script in datastage
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
>
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
>