DB2 Command Parameters

DB2 command parameter description-a displays sqlca off-c automatically implements ON-d retrieval and displays XML declaration OFF-e displays SQLCODE/sqlstate off-f reads input file OFF-I display XML data with indentation OFF-l command record to history file OFF-m show affected lines OFF-n remove line feed character OFF-o show output ON-p display db2 interactive prompt ON-q reserved space and line feed OFF-r Save the output report to the file OFF-s stop executing OFF-t set statement stop character OFF-v Return Current command OFF -w: Display FETCH/SELECT warning message ON-x: do not print column title OFF-z: Save all output to output file OFF