Installation and Configuration Guide : A. OpenROAD Command Window (Windows Only) : OpenROAD Command Window Usage Syntax : sql Command--Run SQL Queries
 
Share this page          
sql Command--Run SQL Queries
You can use the Ingres Terminal Monitor, sql.exe, to run SQL queries interactively or in batch mode. The sql command takes a single argument: the Ingres or Enterprise Access database name. You may pass a script using stdin, and the output can be directed to stdout.
This command has the following syntax:
sql database
sql database < inputfile
sql database < inputfile > outputfile
The database name must be passed in order for Terminal Monitor to connect to the server. The database name consists of an optional vnodename, a required dbname and an optional serverclass. You specify this name as follows:
[vnodename::]dbname[/serverclass]
The vnodename can be either a static or dynamic vnode. For more information, see the Ingres Connectivity Guide.