SET TERM - change statement terminator string SET TIME - toggle display of timestamp with DATE values SET STATs - toggle display of performance statistics SET PLANONLY - toggle display of query plan without executing SET PLAN - toggle display of query access plan SET NAMES - set name of runtime character set SET LIST - toggle column or table display format SET HEADING - toggle display of query column titles SET EXPLAIN - toggle display of query access plan in the explained form SET MAXROWS - limit select stmt to rows, zero is no limit SET COUNT - toggle count of selected rows on/off SET BLOB - display BLOBS of subtype or ALL SET BAIL - toggle bailing out on errors in non-interactive mode SET AUTOddl - toggle autocommit of DDL statements t(erminator) command terminator (set term) s(qldialect) SQL dialect (set sql dialect) q(uiet) do not show the message "Use CONNECT." nod(btriggers) do not run database triggers n(oautocommit) no autocommit DDL (set autoddl off) f(etch_password) fetch password from file d(atabase) database name to put in script creation ch(arset) connection charset (set names)
Setting The ISC_USER And ISC_PASSWORD Environment Variables
0 kommentar(er)
