From Ingres Community Wiki

Contents 1 Overview 2 Scope 2.1 Update 'ingres' Script 2.2 Add Simple Usage Message to TM 'dayfile' 2.3 Enable --history_recall by Default on Unix 3 Details 3.1 Ingres Update 3.1.1 Change Info 3.1.2 QA 3.1.3 Documentation 3.2 TM Dayfile 3.2.1 Change Info 3.2.2 QA 3.2.3 Documentation 3.3 --history_recall 3.3.1 Change Info 3.3.2 QA 3.3.3 Documentation

Overview

The Ingres Terminal Monitor (TM) and wrapper scripts (sql, quel, ingres) can be confusing for first time users, even if they are familiar with RDBMSs more generally. This project aims to address some of these with a few simple changes. These changes are targeted for the Ingres 10 release.

Scope

Update 'ingres' Script

Running:

ingres dbname

connects the user to the named database with a QUEL session. As this is not the most friendly environment for new users (who are quite likely to run 'ingres' after installing for the first time), the script will be changed to invoke an SQL session instead.

This change will affect Unix, Linux, Windows and VMS

Add Simple Usage Message to TM 'dayfile'

TM supports the use of a 'dayfile' to display a message to the user when they first initiate a TM session. Ingres currently ships and empty dayfile as:

$II_SYSTEM/ingres/files/dayfile.dst

This will be updated to include a simple message describing how to execute queries, get more help and quit the application. The text is still to be finalized but it will look something like this:

$ sql iidbdb
INGRES TERMINAL MONITOR Copyright 2010 Ingres Corporation
Ingres Linux Version II 10.0.0 (int.lnx/00)NPTL login
Thu Apr 22 06:24:54 2010
Enter \g to execute commands, "help help\g" for help, \q to quit

continue
* 

The message will be quieted by use of the '-s' flag as the contents of the dayfile usually would be.

This change will affect Unix, Linux, Window and VMS.

Enable --history_recall by Default on Unix

The TM flag '-history_recall' on Linux enables the storing and recall of entered text on a line by line basis. Previous entries can be recalled by use of the up and down arrows which is common in Linux terminal applications (usually via the readline library). There have been a number of issues with batch processing which prevent this functionality from being enabled by default.

These issues will be addressed and the functionality enabled by default for Unix and Linux platforms. In addition to this an new flag

-nohistory_recall

will be added to disable the functionality on a session basis and a new config parameter

ii.*.tm.history_recall

will allow it to be enabled or disabled instance wide.

This change will affect Unix and Linux platforms only

Details

Ingres Update

Change Info

Bug# : 123608

IP : http://reviewboard.ingres.prv/r/3188

SVN Rev :

QA

Documentation

TM Dayfile

Change Info

Bug# : 123609

IP : http://reviewboard.ingres.prv/r/3195

SVN Rev :

QA

Documentation

--history_recall

Change Info

Bug# : b123622

IP : http://reviewboard.ingres.prv/r/3196

SVN Rev :

QA

Documentation