Hello,
can any one help me to debug the following command.
db2 -stec +pc ;
Regards,
SM
It might be this:
Option Description Default Setting
------ ---------------------------------------- ---------------
-a Display SQLCA OFF
-c Auto-commit ON
-e Display SQLCODE/SQLSTATE OFF
-f Read from input file OFF
-l Log commands in history file OFF
-n Remove new line character OFF
-o Display output ON
-p Display db2 interactive prompt ON
-r Save output report to file OFF
-s Stop execution on command error OFF
-t Set statement termination character OFF
-v Echo current command OFF
-w Display FETCH/SELECT warning messages ON
-x Suppress printing of column headings OFF
-z Save all output to output file OFF
Notes:
Use the DB2OPTIONS environment variable to customize option defaults.
An option takes on the opposite value if the minus sign (-) is changed to a
plus (+).
Use UPDATE COMMAND OPTIONS to change option settings in interactive or
file input mode.
I did a db2 ? options to get the above.
Thanks for the update, it was much more informative,
the command I have shown to you has +c and -c with in the same command so just thought it nullifies the function all together. My question here is that it is of now use to use + and - in the same command isn't?
If you have some back ground on SQLCA then through this we can get access to different elements namely sqlcode.
How to activate the SQLCA hope the answer is +a, but once I enable that how to i get access to the sqlcode value that is existing with in the SQL communication Area.
Regrds,
SM