syntax of, 127

SHOW TIME command, 128 SHOW TIMING command, 129 SHOW VIEWS command

example of, 57 syntax of, 129 SPOOL command examples of, 64 syntax of, 130

Spooling (see Logging output) SQL mode, 92

SQL parameters displaying, 61 resetting, 61 setting, 61

SQL statement breaking across lines, 52 displaying the elapsed time, 54 editing, 87

preparing and executing, 60 repeating, 59, 98

running in a Perl or Python program, 76 running in the Neoview Script interface, 59 running on a Perl or Python command line, 75 running when launching Neoview Script, 48 terminating, 52

SQL statements, supported in Neoview Script ALTER MVGROUP statement, 133 ALTER SYNONYM statement, 133 ALTER TABLE statement, 133

ALTER TRIGGER statement, 133 ALTER VIEW statement, 133 BEGIN WORK statement, 133 COMMIT WORK statement, 133 CREATE INDEX statement, 133

CREATE MATERIALIZED VIEW statement, 133 CREATE MVGROUP statement, 133 CREATE SCHEMA, 133

CREATE SYNONYM statement, 133 CREATE TABLE, 133

CREATE TRIGGER statement, 133 CREATE VIEW statement, 133 DELETE statement, 133

DROP INDEX statement, 133

DROP MATERIALIZED VIEW statement, 133 DROP MVGROUP statement, 133

DROP SCHEMA statement, 133 DROP SYNONYM statement, 133 DROP TABLE statement, 133 DROP TRIGGER statement, 133 DROP VIEW statement, 133 EXECUTE statement, 133 GRANT statement, 133 INSERT statement, 134

LOCK TABLE statement, 134 MAINTAIN command, 134 POPULATE INDEX utility, 134 PREPARE statement, 134 PURGEDATA utility, 134

REORG command, 134 REVOKE statement, 134 ROLLBACK WORK statement, 134 SELECT statement, 134

SET SCHEMA, 134

SET TABLE TIMEOUT statement, 134 SET TRANSACTION statement, 134 UPDATE statement, 134

UPDATE STATISTICS statement, 134 SQL terminator

setting, 54 showing, 54 SQL utilities, 133

SQLPlus look and feel, 36 Standard prompt

customizing, 53 description of, 51 displaying the current time, 53

Synonyms

showing all synonyms in a schema, 57 wild-card search, 124

T

Tables

showing all tables in a schema, 56 wild-card search, 128

TDM_Default_DataSource, 46 Teradata look and feel, 36 Timeout, idle session, 53 Transaction, example of, 64 Type 4 driver

See JDBC driver, 26

U

UNIX launch file, location of, 34 UPDATE STATISTICS statement

description of, 134 example of, 76

User profile

setting _JAVA_OPTIONS, 39

setting login environment variables, 74 setting the PATH, 26, 44

Utilities, 133

V

VERSION command, syntax of, 131 Views

showing all views in a schema, 57 wild-card search, 129

W

Wild-card characters, 116 Wild-card search

materialized views, 117 schemas, 121 synonyms, 124 tables, 128

views, 129

Windows launch file, location of, 34

140 Index