Logging OWB mapping execution in Shell script

Shell Programming and Scripting
1

Hi,

I am executing a OWB mapping from a shell script like this

$OWB_SQLPLUS MY_WAREHOUSE plsql MY_MAPPING "," ","

I want to log this mapping execution process into a file.

Please let me know if this will work:
$OWB_SQLPLUS MY_WAREHOUSE plsql MY_MAPPING "," "," >> LOGFIL.log

I will just be using this log file to track all the execution and use it for logging purpose.

If this wont work, please tell me the proper way to do this...

Thanks.

2

The syntax is correct: stdout is logged into the file (append mode) but not stderr.

To log stdout and stderr :

$OWB_SQLPLUS MY_WAREHOUSE plsql MY_MAPPING "," "," >> LOGFIL.log 2>&1

Jean-Pierre.