Skip to content

Tag Archives: sql

Ingres 10.0 – “sql -history_recall” now enabled by default

Friday, April 30, 2010

History what? For some time the Ingres terminal monitor has had the, slightly cryptic (to me at least), flag “-history_recall”. This flag allows you to use the cursor keys within a terminal monitor session to scroll through previous queries and edit them in-line. Users of Ingres on Windows have been able to do this by [...]

  • Share/Bookmark
Filed in ingres | Also tagged , , | View Comments

Ingres 10.0 – Escaping from the Ingres terminal monitor

Thursday, April 29, 2010

For new users to Ingres quitting from the Ingres terminal monitor, tm or sql, just got easier. With change 2901 the terminal monitor has gone from this: $ sql iidbdb INGRES TERMINAL MONITOR Copyright 2010 Ingres Corporation Ingres Linux Version II 10.0.0 (int.lnx/2863)NPTL login Thu Apr 29 08:46:38 2010 continue * to: $ sql iidbdb [...]

  • Share/Bookmark
Filed in ingres | Also tagged , , , | View Comments

What BLOB tables do I have?

Tuesday, February 23, 2010

The following is SQL code was published in the #ingres IRC channel on freenode in response to a question about the best method to determine which iietab_xx_yy table belongs to which table: select r1.relid as base_table, c.attname as column_name, r2.relid as extend_table from iirelation r1,iirelation r2,iiattribute c,iiextended_relation e where r1.reltid=e.etab_base and r2.reltid=e.etab_extension and r1.reltid=c.attrelid and [...]

  • Share/Bookmark
Filed in ingres, sql | Also tagged , , , | View Comments

Logging Ingres JDBC connections under tomcat

Tuesday, July 8, 2008

The Ingres JDBC driver, iijdbc.jar, has the capability to log the queries that pass through it. This is extremely useful for obtaining query timings as well as working out what goes between an application and the DBMS server. For example, below is a snippet of a trace obtained from Jira: 2008-07-08 10:04:12.319: Ingres-ResultSet[40296].next() 2008-07-08 10:04:12.319: [...]

  • Share/Bookmark
Filed in drivers, ingres, jdbc | Also tagged , , , , , | View Comments