cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding log file

ancys
Occasional Contributor

Regarding log file

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
2 REPLIES
GIRAUD Fabien
Regular Advisor

Re: Regarding log file

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.
ancys
Occasional Contributor

Re: Regarding log file

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