Template:SQWareProduction sqwmsq ExecSQL.ksh help: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
m Updated by BatchUser
m Updated by BatchUser
Line 1: Line 1:
<pre>
<pre>
Can't find if env is 'SqlCmd' or 'FreeTds' !
Can't find if env is 'SqlCmd' or 'FreeTds' !
Sourcing sqwmsq_Global.lib v2024.08 SQWareProduction for MsSql (dbSQWare) ...  
Sourcing sqwmsq_Global.lib v2025.01 SQWareProduction for MsSql (dbSQWare) ...  


Run sqwmsq_ExecSQL.ksh -h : 2024-12-24 08:36:36
Usage: sqwmsq_ExecSQL.ksh [-h] -I <instance> [+ options]


__________________________________________________________________
DESCRIPTION
Program informations
  sqwmsq_ExecSQL.ksh execute SQL file on instance
SqwVersion=2024.08 / 2024.08
SUPPORT
2024-12-24 08:36:36
  All rdbms type and version
Copyright 2010-2024, dbSQWare (www.dbsqware.com)
Linux dbsqware02 4.15.18-21-pve #1 SMP PVE 4.15.18-48 (Fri, 20 Sep 2019 11:28:30 +0200) x86_64 GNU/Linux
gvsqw_GenPath=/home/dbsqware/dbSQWare/SQWareProduction/mssql/bin
Path=/home/dbsqware/dbSQWare/SQWareProduction/mssql/bin
./sqwmsq_ExecSQL.ksh -h
dbsqware@dbsqware02


sqwmsq_ExecSQL.,dbsqware ./sqwmsq_ExecSQL.ksh -h
PARAMETERS
  `-pstree -aul 21395
    -I  instance      : Target instance.
    -F  FileName      : Filename to execute.
OPTIONS
    -h                : Display the full usage.
    -s                : Display samples of usage.
    -Opt  option      : Additional options for sql connection.
    -FRT      code    : Force return code value on error.
    -NoMail            : Deactivate sendmail on error pmexpdba@gmail.com (by default, send on error).
    -Locale    locale  : Force Locale for help display (fr,en).
    -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 commands (by default, display generated commands).


__________________________________________________________________
Not sending mail because you are in connected mode !!!
Error, ExecEnvType='LinuxKO' ...
Begining    : 2024-12-24 08:36:36
End          : 2024-12-24 08:36:36
Duration    : 00:00:00
</pre>
</pre>

Revision as of 16:07, 23 February 2025

Can't find if env is 'SqlCmd' or 'FreeTds' !
Sourcing sqwmsq_Global.lib v2025.01 SQWareProduction for MsSql (dbSQWare) ... 

Usage: sqwmsq_ExecSQL.ksh [-h] -I <instance> [+ options]

DESCRIPTION
   sqwmsq_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                 : Display the full usage.
     -s                 : Display samples of usage.
     -Opt  option       : Additional options for sql connection.
     -FRT       code    : Force return code value on error.
     -NoMail            : Deactivate sendmail on error pmexpdba@gmail.com (by default, send on error).
     -Locale    locale  : Force Locale for help display (fr,en).
     -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 commands (by default, display generated commands).