Vector 7.0 | sql Examples

User Guide > User Guide > A. Command Reference > sql Command--Start the Line-based SQL Terminal Monitor > sql Examples

Was this helpful?

sql Examples

This command opens the line-based Terminal Monitor for SQL for working in the empdata database:

sql empdata

This command opens empdata and does not print the dayfile:

sql empdata -d

This command opens empdata, suppressing the dayfile message and the terminal monitor prompts and messages, and reads into the workspace the contents of the batchfile:

sql empdata -s <batchfile

This command opens empdata, displays float4 columns in G format with two decimal places and integer1 columns with three spaces:

sql empdata -f4g12.2 -I13

This command opens the inventory database on a remote node using dynamic vnode syntax, connects to the node as user johnny, and prompts for the password:

sql +user=johnny @machine01,tcp_ip,II::inventory

Last modified date: 12/19/2024