Difference between revisions of "Template:SQWareProduction sqwter ExecSQL.ksh help"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
Line 1: | Line 1: | ||
<pre> | <pre> | ||
− | Sourcing sqwter_Global.lib v4.0. | + | Sourcing sqwter_Global.lib v4.0.09 SQWareProduction for Teradata (dbSQWare) ... |
Usage: sqwter_ExecSQL.ksh [-h] -I <instance> [+ options] | Usage: sqwter_ExecSQL.ksh [-h] -I <instance> [+ options] |
Revision as of 21:42, 9 September 2018
Sourcing sqwter_Global.lib v4.0.09 SQWareProduction for Teradata (dbSQWare) ... Usage: sqwter_ExecSQL.ksh [-h] -I <instance> [+ options] DESCRIPTION sqwter_ExecSQL.ksh execute SQL file on instance SUPPORT All rdbms type and version PARAMETERS -I instance : Target instance. -F FileName : Filename to execute. OPTIONS -h help : Display the full usage. -s : Display samples of usage. -Opt option : Additional option for sql connection. -FRT return_code : Force return code value on error. -NoMail : Desactivate sendmail on error pmexpdba@gmail.com (by default, send on error). -AddMail email : Email Address to add at 'pmexpdba@gmail.com'. -SendReport : Send execution log report. -Dist : For distant connection to database (change $gvsqw_ConnectString to $gvsqw_DistConnectString ). -Exec : Run rsync (default, display generated commands).