IIUG Software Repository Files

Newsgroups: comp.databases.informix
Subject: Cursor Name Mangling -- clashes

From: johnl@informix.com (Jonathan Leffler)
Date: 2 Aug 1995 14:13:04 -0400

Hi,

The 6.0x versions of I4GL try to preserve the local cursor and statement
name semantics of 4.1x ESQL/C, even though 6.0x ESQL/C does not provide
such support.  (Don't point out the '-localcurs' option to ESQL/C -- it
doesn't work adequately.)  To do so, the I4GL compiler hashes the cursor
names using an arcane algorithm which is documented in the release notes.

Unfortunately, the algorithm is such that if two statement names are the
same apart from the last two characters, and if the last two characters of
the two names are one of the 240 pairs listed below, then the names will
hash to the same value, leading to compilation problems.  I attach the
program used to generate this listing so you can reproduce it if you need
to.  Note that it does not test '_' or the digits, so the list is not 100%
complete.

Advice: make cursor and statement names differ with the early parts of the
names rather than the later parts of the name.  Make the names differ by
more than two trailing characters.

Yours,
Jonathan Leffler (johnl@godzilla)

===========================================================================