Solved Error Level in Batchfile

March 8, 2018 at 20:49:35
Specs: WIndows 2008R2, Intel E5-2634
Hi,

Need help in batch script.I have sqlplus in my batch file.

sqlplus user/password@%ODSHYP% @"%SQL_Query%" >> %BScriptLog%

and my sql query is INSERT INTO IN_EPM SELECT * FROM IN_EPM_ext;.

So when my query throws any error to log we need to check if any error in log file and based on that if error it has to exit the script.


See More: Error Level in Batchfile

Report •

#1
March 10, 2018 at 00:19:47
Wrong forum, should be posted here: https://www.computing.net/forum/pro...

Report •

#2
March 13, 2018 at 00:08:06
Need sample of logfile tail after failed attempt,, and make sure logfile is not Unicode, or otherwise account for that.

message edited by nbrane


Report •

#3
March 14, 2018 at 04:57:12
✔ Best Answer
sqlplus user/password@%ODSHYP% @"%SQL_Query%" >> %BScriptLog%&if %errorlevel% GTR 0 exit/b

try that, but im not sure if it will output the last error >> %BscriptLog% or exit on last error

i5-6600K[delid]@4.814GHz/4.613GHz cache@1.385v | 2x4GB Crucial-DDR4-2133@14-14-14-28 1T 2808MHz@1.35v
ASUS Z170K
Samsung 250GB SSD 850 EVO
MSI Armor RX 570 4GB@1375c/1910m BiosMod
VS450


Report •
Related Solutions


Ask Question