Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
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