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

SHOW SCHEMA command
example of, 63
syntax of, 144
SHOW SCHEMAS command
example of, 63
syntax of, 145
SHOW SESSION command, 146
SHOW SQLPROMPT command, 148
SHOW SQLTERMINATOR command, 148
SHOW STATISTICS command, 149
SHOW SYNONYMS command
example of, 65
syntax of, 149
SHOW TABLE command
example of, 64
syntax of, 150
SHOW TABLES command
example of, 64
syntax of, 152
SHOW TIME command, 153
SHOW TIMING command, 154
SHOW VIEWS command
example of, 65
syntax of, 154
Signature, verifying, 40
SPOOL command
examples of, 72
syntax of, 155
Spooling (see Logging output)
SQL mode, 107
SQL parameters
displaying, 69
resetting, 69
setting, 69
SQL statement
breaking across lines, 59
displaying the elapsed time, 62
editing, 96, 99
preparing and executing, 68
repeating, 67, 115
running in the Neoview Command Interface, 67
running when launching Neoview Command Interface,
55
terminating, 60
SQL statements, supported in NCI
ALTER MVGROUP statement, 159
ALTER SYNONYM statement, 159
ALTER TABLE statement, 159
ALTER TRIGGER statement, 159
ALTER VIEW statement, 159
BEGIN WORK statement, 159
CALL statement, 159
COMMIT WORK statement, 159
CREATE INDEX statement, 159
CREATE MATERIALIZED VIEW statement, 159
CREATE MULT SET TABLE statement, 159
CREATE MVGROUP statement, 159
CREATE SCHEMA, 159
CREATE SET TABLE statement, 159
CREATE SYNONYM statement, 159
CREATE TABLE, 159
CREATE TRIGGER statement, 159
CREATE VIEW statement, 159
DELETE statement, 159
DROP INDEX statement, 159
DROP MATERIALIZED VIEW statement, 159
DROP MVGROUP statement, 159
DROP SCHEMA statement, 159
DROP SYNONYM statement, 159
DROP TABLE statement, 159
DROP TRIGGER statement, 159
DROP VIEW statement, 159
EXECUTE statement, 160
EXPLAIN statement, 160
GRANT EXECUTE statement, 160
GRANT SCHEMA statement, 160
GRANT statement, 160
INSERT statement, 160
LOCK TABLE statement, 160
MAINTAIN command, 160
MERGE INTO command, 160
POPULATE INDEX utility, 160
PREPARE statement, 160
PURGEDATA utility, 160
REORG command, 160
REVOKE EXECUTE statement, 160
REVOKE statement, 160
ROLLBACK WORK statement, 160
SELECT statement, 160
SET SCHEMA, 160
SET TABLE TIMEOUT statement, 160
SET TRANSACTION statement, 160
SHOW SERVICE statement, 160
UPDATE statement, 160
UPDATE STATISTICS statement, 160
SQL terminator
setting, 62
showing, 62
SQL utilities, 159
SQLPlus look and feel, 41
Standard prompt
customizing, 61
description of, 59
displaying the current time, 61
Synonyms
showing all synonyms in a schema, 65
wild-card search, 149
T
Tables
showing all tables in a schema, 64
wild-card search, 152
TDM_Default_DataSource, 52
Teradata look and feel, 41
Timeout, idle session, 61
Transaction, example of, 73
Type 4 driver
See JDBC driver, 24
168 Index