Neoview Script Guide (R2.2)

Showing the Session Attributes.......................................................................................................56
Setting and Showing the Idle Timeout Value for the Session.........................................................57
Customizing the Standard Prompt..................................................................................................57
Setting and Showing the SQL Terminator.......................................................................................58
Displaying the Elapsed Time...........................................................................................................58
Setting and Showing the Current Schema.......................................................................................59
Limiting the Result Set of a Query..................................................................................................59
Showing Information About SQL Database Objects.......................................................................59
Displaying Executed Commands....................................................................................................62
Editing and Reexecuting a Command.............................................................................................62
Clearing the Interface Window.......................................................................................................62
Obtaining Help................................................................................................................................62
Running SQL Statements......................................................................................................................63
Executing an SQL Statement...........................................................................................................63
Repeating an SQL Statement...........................................................................................................63
Preparing and Executing SQL Statements......................................................................................64
Executing CREATE TRIGGER Statements............................................................................................67
Logging Output....................................................................................................................................68
Starting the Logging Process...........................................................................................................68
Stopping the Logging Process.........................................................................................................69
Viewing the Contents of a Log File.................................................................................................69
5 Running Scripts in the Neoview Script Interface.......................................................71
Creating a Script File.............................................................................................................................71
Supported SQL Statements in Script Files.......................................................................................71
Permitted Neoview Script Interface Commands in Script Files......................................................71
Comments........................................................................................................................................71
Section Headers...............................................................................................................................71
Example of a Script File...................................................................................................................72
Running a Script File.............................................................................................................................72
Logging Output....................................................................................................................................73
Running Scripts in Parallel...................................................................................................................73
6 Running Neoview Script From Perl or Python............................................................75
Setting the Login Environment Variables.............................................................................................75
Setting the Login Environment Variables on Windows..................................................................75
Setting the Login Environment Variables on Linux or UNIX.........................................................77
Perl and Python Wrapper Scripts.........................................................................................................78
Launching Neoview Script From the Perl or Python Command Line.................................................78
Perl and Python Commands on Windows......................................................................................79
Perl and Python Commands on Linux or UNIX.............................................................................79
Launching Neoview Script From a Perl or Python Program...............................................................80
Setting the Login Environment Variables........................................................................................80
Using SQL Statements in a Perl or Python Program.......................................................................80
Running the Perl or Python Program..............................................................................................81
A Neoview Script Interface Commands........................................................................83
@ Command..........................................................................................................................................86
Syntax..............................................................................................................................................86
Considerations.................................................................................................................................86
Examples..........................................................................................................................................86
/ Command...........................................................................................................................................86
Syntax..............................................................................................................................................86
4 Table of Contents