SQLCMD – A Better DBACCESS?. Utility by Jonathan Leffler Presented by Joe Kennedy (email@example.com) (301-803-1974). Sqlcmd as a SQL Command Interpreter. DDL DML Select, Execute Procedure. What is it?.
Utility by Jonathan Leffler
Presented by Joe Kennedy
SQLCMD is an SQL Command Interpreter for Informix databases. It is analogous to the Query-Language option of DB-Access or ISQL, but it is designed to work better in shell scripts.
SQLCMD is written in ESQL/C. It works with any version of ESQL/C from 5.00 (circa 1990) upwards.
SQLCMD has a history mechanism that allows you to review, edit and rerun commands you ran previously.
-F from the command line!
automatically initiates transactions, groups the inserts, groups the inserts into smaller transactions if there are many rows to be loaded
Unix/Linux redirection applies
echo “select * from customer” | sqlcmd -d stores_demo -F XML
Try “sqlcmd -help”
-e 'SQL Statements'
The International Informix User Group!
www.iiug.org – check the software repository...
distributed as a gzipped tar file with the extension ".tgz"
SQLCMD is written in ESQL/C, you must have ESQL/C or ClientSDK on your machine before installing SQLCMD.
On Unix systems (including Linux), the normal sequence of events is: