informix SQL语句断点定义
存储过程中断点定义语句:
ON EXCEPTION SET __OK
if __ErrorID<>0 then
RETURN __ErrorID;
else
RETURN __OK;
end if
END EXCEPTION
let __ok=100;
SQL 语句;
或者为:
ON EXCEPTION SET ERR,ERR2,MSG
raise exception -746,0,'ERR:'||ERR||',()MSG:'||__ErrorID||'-'||MSG;
END EXCEPTION
let __errorid=100;
SQL 语句;
ON EXCEPTION SET __OK
if __ErrorID<>0 then
RETURN __ErrorID;
else
RETURN __OK;
end if
END EXCEPTION
let __ok=100;
SQL 语句;
或者为:
ON EXCEPTION SET ERR,ERR2,MSG
raise exception -746,0,'ERR:'||ERR||',()MSG:'||__ErrorID||'-'||MSG;
END EXCEPTION
let __errorid=100;
SQL 语句;