topic Regarding log file in Operating System - Linux

Regarding log file

ancys — Thu, 07 Sep 2006 01:16:04 GMT

hi all

I am calling a procedure within script.Even if the prcoedure is not executed successfully. In log file it is recorded as procedure successfully executed .How to capture errors in log file

$SQP $clf_user_name/$clf_password@$db_server < file_out_before.log
exec BatchImportCursor('$criteriano','$filename')

commit;

EOF

but when i execute procedure in backend it gives me an error invalid sql statemetns or numeric or value error.These error has to be recorded in log file.

Help please

Re: Regarding log file

GIRAUD Fabien — Thu, 07 Sep 2006 02:46:06 GMT

To redirect the error messages of a command line, you just have to add " 2> your_file " at the end of this line.

Hope this helps.

Re: Regarding log file

ancys — Thu, 07 Sep 2006 03:42:06 GMT

if i include 2 also
$SQP $clf_user_name/$clf_password@$db_server < file_out_before.log

the error msgs of procedure are not recorded.
But hte procedure shows error in backend like

returns more than one value of subquery
missing equal sign

Error msgs are got by exception handler in procedure.How to redirect these error msg to log file