HP (Hewlett-Packard) 544530-001 Manuale Utente

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