Specifies which and how database errors are written to the application log file.
Syntax
QX_LOGNATIVESQLERRORS={1, 2, 3, 4, 5, 6, 7}
Possible values
These values - {1, 2, 4} - are basic for QX_LOGNATIVESQLERRORS:
1 |
writes to the application log file:
|
2 |
writes to the application log file:
|
4 |
writes to the application log file:
|
The other values - {3, 5, 6, 7} - are obtained as a combination of the basic QX_LOGNATIVESQLERRORS values:
3 |
3(011) = 2(010) + 1(001) |
writes to the application log file:
|
5 |
5(101) = 4(100) + 1(001) |
writes to the application log file:
|
6 |
6(110) = 4(100) + 2(010) |
writes to the application log file:
|
7 |
7(111) = 4(100) + 2(010) + 1(001) |
writes to the application log file:
|
Usage and examples
QX_LOGNATIVESQLERRORS takes an INTEGER from the above list as a parameter to specify which database errors are written to the application log file:
QX_LOGNATIVESQLERRORS=3
In this case, the application log file will get both error code and the text of the error message from the native RDBMS for the last SQL statement executed.
If QX_LOGNATIVESQLERRORS is not defined, database errors will not be logged.
QX_LOGNATIVESQLERRORS applies at runtime and is set in inet.env.
Log files for the running applications are stored in these folders: