HP NEOVIEW 544530-001 manual Table of Contents

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

4Table of Contents