Filter
Top Products
Presetting the Optional Launch Parameters....................................................................................45
Logging In to the Database Platform....................................................................................................45
Default Login...................................................................................................................................45
Login Parameters.............................................................................................................................46
Using Optional Launch Parameters................................................................................................46
Logging In When Launching Neoview Script...........................................................................47
Running a Command When Launching Neoview Script..........................................................47
Example of Running an SQL Statement With -q or -sql.......................................................48
Example of Running a Neoview Script Interface Command With -q or -sql.......................48
Running a Script File When Launching Neoview Script...........................................................48
Example of a Script File........................................................................................................49
Example of Running a Script File With -s or -script.............................................................49
Launching Neoview Script Without Connecting to the Database.............................................49
Example of Launching Neoview Script File With -noconnect..............................................50
Exiting the Neoview Script Interface....................................................................................................50
4 Running Commands Interactively in the Neoview Script Interface.........................51
Neoview Script Interface......................................................................................................................51
Product Banner................................................................................................................................51
Interface Prompts............................................................................................................................51
Breaking the Command Line...........................................................................................................51
Case Sensitivity................................................................................................................................52
Using Neoview Script Interface Commands........................................................................................52
Showing the Session Attributes.......................................................................................................52
Setting and Showing the Idle Timeout Value for the Session.........................................................53
Customizing the Standard Prompt..................................................................................................53
SET PROMPT Command...........................................................................................................53
SET TIME Command.................................................................................................................53
Setting and Showing the SQL Terminator.......................................................................................54
Displaying the Elapsed Time...........................................................................................................54
Setting and Showing the Current Schema.......................................................................................55
Limiting the Result Set of a Query..................................................................................................55
Showing Information About SQL Database Objects.......................................................................55
Showing the Schemas.................................................................................................................56
Showing the Tables in a Schema................................................................................................56
Showing the Dependent Objects of a Table................................................................................56
Showing the Views in a Schema.................................................................................................57
Showing the Synonyms in a Schema.........................................................................................57
Displaying Executed Commands....................................................................................................58
Editing and Reexecuting a Command.............................................................................................58
Clearing the Interface Window.......................................................................................................58
Obtaining Help................................................................................................................................58
Running SQL Statements......................................................................................................................59
Executing an SQL Statement...........................................................................................................59
Repeating an SQL Statement...........................................................................................................59
Preparing and Executing SQL Statements......................................................................................60
Preparing an SQL Statement......................................................................................................60
Setting Parameters......................................................................................................................61
Displaying the Parameters of the Session..................................................................................61
Resetting the Parameters............................................................................................................61
Executing a Prepared SQL Statement........................................................................................62
Logging Output....................................................................................................................................63
Starting the Logging Process...........................................................................................................63
SPOOL ON or LOG ON Command...........................................................................................63
4 Table of Contents