Neoview Command Interface (NCI) Guide (R2.3)

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