Problem with DSExecute

Post by **admin** » Tue Aug 28, 2001 3:56 pm

Hi all,

I have the following problem:
i have a routine that executes the instuction:

CALL DSExecute(UNIX,sqlldr,strResult,ReturnCode)

But it gives me:

Result = SH: sqlldr: not found

Why i can execute sqlldr in shell and when i use DSExecute i cant? Does anyone have some ideas about this problem?

Thanks in Advance,

NP

Post by **admin** » Tue Aug 28, 2001 4:23 pm

Nuno...

The obvious answer would be that your path would not be set up correctly.

Try doing a "which sqlldr" and seeing where the file exists, and then make sure its in your search path for the account in question.

Dave

>Hi all,
>
>I have the following problem:
>i have a routine that executes the instuction:
>
> CALL DSExecute(UNIX,sqlldr,strResult,ReturnCode)
>
>But it gives me:
>
> Result = SH: sqlldr: not found
>
>
>Why i can execute sqlldr in shell and when i use DSExecute i cant?
>Does anyone have some ideas about this problem?

========================================================================
David T. Meeks || "All my life Im taken by surprise
Development Engineer, DataStage || Im someones waste of time
Ascential Software || Now I walk a balanced line
dave.meeks@ascentialsoftware.com || and step into tomorrow" - IQ
========================================================================

Post by **admin** » Tue Aug 28, 2001 4:59 pm

Give yourself a break and write a shell script. Put
status messages into a logfile as the shell script
reaches milestones. DataStage will return screen
output only when the shell script terminates. You
cant track internal progress of a script easily
unless you take my recommendation.

Put env into the shell script and you will see that
the environment of DataStage is that of the dsenv
file in the engine directory. If programs are not in
that path, you wont path to them. REMEMBER: The
dsenv is environment file for DataStage, not the
individual user.

--- "David T. Meeks"
wrote:
> Nuno...
>
> The obvious answer would be that your path would not
> be set up
> correctly.
>
> Try doing a "which sqlldr" and seeing where the file
> exists, and
> then make sure its in your search path for the
> account in question.
>
> Dave
>
>
>
> >Hi all,
> >
> >I have the following problem:
> >i have a routine that executes the instuction:
> >
> > CALL
> DSExecute(UNIX,sqlldr,strResult,ReturnCode)
> >
> >But it gives me:
> >
> > Result = SH: sqlldr: not found
> >
> >
> >Why i can execute sqlldr in shell and when i use
> DSExecute i cant?
> >Does anyone have some ideas about this problem?
>
>
>
>
========================================================================
> David T. Meeks || "All my life
> Im taken by surprise
> Development Engineer, DataStage || Im someones
> waste of time
> Ascential Software || Now I walk a
> balanced line
> dave.meeks@ascentialsoftware.com || and step into
> tomorrow" - IQ
>
========================================================================
>

__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/