hostcode
Differences
This shows you the differences between two versions of the page.
|
hostcode [2015/09/23 20:27] 127.0.0.1 external edit |
hostcode [2016/04/20 07:42] dmtolpeko |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== HOSTCODE - PL/HQL Reference ====== | + | ====== HOSTCODE ====== |
| HOSTCODE built-in variable contains the return code of the last OS command. | HOSTCODE built-in variable contains the return code of the last OS command. | ||
| <code language=sql> | <code language=sql> | ||
| - | SET plhql.onerror = SETERROR; | + | SET hplsql.onerror = SETERROR; |
| HOST 'echo hello, world'; | HOST 'echo hello, world'; | ||
| Line 15: | Line 15: | ||
| * Typically HOSTCODE is 0 when the process terminated successfully, and 1 if it terminated with an error. | * Typically HOSTCODE is 0 when the process terminated successfully, and 1 if it terminated with an error. | ||
| - | * By default [[configuration#plhqlonerror|plhql.onerror]] is set to EXCEPTION, so if the OS command cannot be executed (the process does not exist, no permissions i.e.) the exception is raised and you are not be able to check HOSTCODE in IF statement. | + | * By default [[configuration#hplsqlonerror|hplsql.onerror]] is set to EXCEPTION, so if the OS command cannot be executed (the process does not exist, no permissions i.e.) the exception is raised and you are not be able to check HOSTCODE in IF statement. |
| For more information, see [[error-handling|Error Handling]]. | For more information, see [[error-handling|Error Handling]]. | ||
| - | **Compatibility:** PL/HQL Extension. | + | **Compatibility:** HPL/SQL Extension. |
| **See also:** | **See also:** | ||
| * [[sqlcode|SQLCODE]] | * [[sqlcode|SQLCODE]] | ||
| + | * [[errorcode|ERRORCODE]] | ||
Page Tools
