Re: iSeries SQL and identity columns

On 2/1/11 10:16 AM, terry_bullard@xxxxxxxxxxxx wrote:

Have been having some performance issues with web pages hitting our
iSeries. Set up SQL Exit program to be able to capture/log odbc sql
statements. Looking in my log file - the overwhelming log entries
have the following sql statement.

SELECT identity_generation FROM QSYS2/SYSCOLUMNS
WHERE identity_generation is not null
AND column_name = ?
AND table_name = ?
AND table_schema = ?

<<SNIP>> is this a system generated statement? I ask because the
developers who have written most of our web pages are telling me they
don't recognize this either???

<<SNIP>>

The database would have no need to perform such a query, so the
statement is very _unlikely_ to have been "system-generated" by\at the
server. Every TABLE has a "record format" that defines whether the file
has an IDENTITY column, thus there is no reason for the database to
query if\which column has that attribute, since that information is
available directly from the TABLE itself. Some client application might
have some "need" to perform such a query, but I could not guess why.

Regards, Chuck
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.