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

Showing the Session Attributes.......................................................................................................46
Setting and Showing the Idle Timeout Value for the Session.........................................................47
Customizing the Standard Prompt..................................................................................................47
Setting and Showing the SQL Terminator.......................................................................................48
Displaying the Elapsed Time...........................................................................................................48
Setting and Showing the Current Schema.......................................................................................49
Limiting the Result Set of a Query..................................................................................................49
Showing Information About SQL Database Objects.......................................................................49
Displaying Executed Commands....................................................................................................52
Editing and Reexecuting a Command.............................................................................................52
Clearing the Interface Window.......................................................................................................52
Obtaining Help................................................................................................................................52
Running SQL Statements......................................................................................................................53
Executing an SQL Statement...........................................................................................................53
Repeating an SQL Statement...........................................................................................................53
Preparing and Executing SQL Statements......................................................................................54
Executing CREATE TRIGGER Statements............................................................................................57
Logging Output....................................................................................................................................58
Starting the Logging Process...........................................................................................................58
Stopping the Logging Process.........................................................................................................59
Viewing the Contents of a Log File.................................................................................................59
5 Running Scripts in NCI................................................................................................61
Creating a Script File.............................................................................................................................61
SQL Statements or Other Commands.............................................................................................61
NCI Commands...............................................................................................................................61
Comments........................................................................................................................................61
Section Headers...............................................................................................................................62
Example of a Script File...................................................................................................................62
Running a Script File.............................................................................................................................62
Logging Output....................................................................................................................................63
Running Scripts in Parallel...................................................................................................................63
6 Running NCI From Perl or Python...............................................................................65
Setting the Login Environment Variables.............................................................................................65
Setting the Login Environment Variables on Windows..................................................................65
Setting the Login Environment Variables on Linux or UNIX.........................................................67
Perl and Python Wrapper Scripts.........................................................................................................68
Launching NCI From the Perl or Python Command Line...................................................................68
Example of a Perl Program (example.pl).........................................................................................69
A NCI Commands...........................................................................................................71
@ Command..........................................................................................................................................75
Syntax..............................................................................................................................................75
Considerations.................................................................................................................................75
Examples..........................................................................................................................................75
/ Command...........................................................................................................................................76
Syntax..............................................................................................................................................76
Considerations.................................................................................................................................76
Example...........................................................................................................................................76
ALIAS Command.................................................................................................................................76
Syntax..............................................................................................................................................76
Considerations.................................................................................................................................77
4 Table of Contents