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/