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

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