Neoview Command Interface (NCI) Guide (R2.3)

SHOW SQLPROMPT command, 144
SHOW SQLTERMINATOR command, 144
SHOW STATISTICS command, 145
SHOW SYNONYMS command
example of, 67
syntax of, 145
SHOW TABLE command
example of, 66
syntax of, 146
SHOW TABLES command
example of, 66
syntax of, 148
SHOW TIME command, 150
SHOW TIMING command, 150
SHOW VIEWS command
example of, 67
syntax of, 150
SPOOL command
examples of, 74
syntax of, 151
Spooling (see Logging output)
SQL mode, 106
SQL parameters
displaying, 71
resetting, 71
setting, 71
SQL statement
breaking across lines, 61
displaying the elapsed time, 64
editing, 98, 101
preparing and executing, 70
repeating, 69, 114
running in a Perl or Python program, 86
running in the Neoview Command Interface, 69
running on a Perl or Python command line, 85
running when launching Neoview Command Interface,
57
terminating, 62
SQL statements, supported in NCI
ALTER MVGROUP statement, 155
ALTER SYNONYM statement, 155
ALTER TABLE statement, 155
ALTER TRIGGER statement, 155
ALTER VIEW statement, 155
BEGIN WORK statement, 155
CALL statement, 155
COMMIT WORK statement, 155
CREATE INDEX statement, 155
CREATE MATERIALIZED VIEW statement, 155
CREATE MULT SET TABLE statement, 155
CREATE MVGROUP statement, 155
CREATE SCHEMA, 155
CREATE SET TABLE statement, 155
CREATE SYNONYM statement, 155
CREATE TABLE, 155
CREATE TRIGGER statement, 155
CREATE VIEW statement, 155
DELETE statement, 155
DROP INDEX statement, 155
DROP MATERIALIZED VIEW statement, 155
DROP MVGROUP statement, 155
DROP SCHEMA statement, 155
DROP SYNONYM statement, 155
DROP TABLE statement, 155
DROP TRIGGER statement, 155
DROP VIEW statement, 155
EXECUTE statement, 156
EXPLAIN statement, 156
GRANT EXECUTE statement, 156
GRANT SCHEMA statement, 156
GRANT statement, 156
INSERT statement, 156
LOCK TABLE statement, 156
MAINTAIN command, 156
MERGE INTO command, 156
POPULATE INDEX utility, 156
PREPARE statement, 156
PURGEDATA utility, 156
REORG command, 156
REVOKE EXECUTE statement, 156
REVOKE statement, 156
ROLLBACK WORK statement, 156
SELECT statement, 156
SET SCHEMA, 156
SET SERVICE statement, 156
SET TABLE TIMEOUT statement, 156
SET TRANSACTION statement, 156
SHOW SERVICE statement, 156
UPDATE statement, 156
UPDATE STATISTICS statement, 156
SQL terminator
setting, 64
showing, 64
SQL utilities, 155
SQLPlus look and feel, 43
Standard prompt
customizing, 63
description of, 61
displaying the current time, 63
Synonyms
showing all synonyms in a schema, 67
wild-card search, 145
T
Tables
showing all tables in a schema, 66
wild-card search, 148
TDM_Default_DataSource, 54
Teradata look and feel, 43
Timeout, idle session, 63
Transaction, example of, 75
Type 4 driver
See JDBC driver, 26
U
UNIX launch file, location of, 41
UPDATE STATISTICS statement
description of, 156
164 Index