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