Thema:

Kommentar:
: Hi. : Versuch mal: : ************* : db2batch -- version 2.0 : db2batch -d dbname -f file_name [-a userid/passwd] [-t delcol] [-r outfile,[outfile2]] : [-c on/off] [-i short/long/complete] [-o options] [-v on/off] : [-s on/off] [-q on/off/del] [-l x] [-cli [cache size]] [-h] : where: -f Input file containing SQL statements. : -d Database name. Default dbname set in $DB2DBDFT. : -t Single character column separator, except for tab column delimiter. : Specify -t TAB for tab column delimiter. : -a Authentication Host user id/password. : -r Output file containing query results. If is specified, it : will contain the summary table. Default is screen. : -c Automatically commit after each SQL statement. Default is on. : -i Elapsed time interval measurement. : short - time to open, fetch, and close cursor. : long - time up to start of next query (includes db2batch overhead). : complete - time prepare, execute, and fetch separately. : Default is short. : -o Control options. The possible options are: : r (see details below). : f (see details below). : p (see details below). : o (see DB2 ADMIN GUIDE). : e . The possible values for are: : 0 - execute only. : 1 - explain only. : 2 - explain & execute query. : Default is 0. : -v Verbose. Sends information to stderr during query processing. : Default is off. : -s Summary Table. Provides summary of elapsed and cpu times with : arithmetic and geometric means for those values collected and : # of rows returned. Default is on. : -q Query output only option, prints the following to output. Default is off. : off - db2batch info, headings, and query results. : on - query results only in non-delimited format. : del - query results only in delimited format(| and ,). : -l Delimiter option. Changes the SQL delimiter from default of ;. : -cli forces db2batch to run in CLI mode. The default is Embedded Dynamic : mode. The default mode is somewhat faster. The statement memory can : be set manually as follows : -cli cache (Default=25). : -p Run db2batch in Parallel Mode - Only on MPP systems. : s - single table or collocated join query. : t tablename - specifies table to use for insert into statement. : d - db2batch creates table for insert into statement. : Default is s. : -h Display this help screen. : ************** : db2sql92 -- version 1.1 : Syntax is: : db2sql92 [-d dbname] [-f file_name] [-a userid/passwd] : [-r outfile,[outfile2]] [-c on/off] [-i none/short/long/complete] : [-o options] [-v on/off] [-s on/off] [-h] : where: -d Database name : Default - dbname set in $DB2DBDFT : -f Input file containing SQL statements : Default - stdin : -a Authentication Host user id/password : -r Output file containing query results. : will contain just the summary, but is optional. : Default - stdout : -c Automatically commit at end of each SQL statement : Default - on : -i Elapsed time interval measurement : none - do not collect time info : (default) short - run time for query + db2sql92 overhead : long - time up to start of next query : complete- time prepare, execute, and fetch separately. : -o Control options: (see details below) : r f : -v Verbose. Sends information to stderr during : query processing. Default - off : -s Summary Table. Provides summary of elapsed times. : Default is off unless is specified. : -h Display this help screen : Note: 1. all SQL statements must be terminated by a semicolon! : 2. db2sql92 issues its own connect and connect reset : 3. All statements executed with isolation level RR : 4. The maximum SQL statement size is 65535 characters. : 5. PAUSE & SLEEP are timed when in short timing mode. : ************** : Oder : cat filename.sql |db2 +o -t : HTH Markus

Optionale Link URL:   
Link Titel:                  
Optionale Image URL: