RE: [DB-SIG] Re: May we get an actual ANSWER to the F.A.Q...How can I construct a dictionary???
Magnus Lycka
magnus at thinkware.se
Thu Sep 25 09:52:35 EDT 2003
From: "Dittmar, Daniel" <daniel.dittmar at sap.com>
> - there are those nitpickers who say that column names aren't
> necessarily unique and that the uppercase/lowercase issues make it worse
Heh, that's funny. Never thought of that, but it is
certainly true for DB2. I just tried
Select CURRENT DATE AS A, 45 AS A from SYSIBM.SYSDUMMY1
I got
A |A
----------+--
2003-09-25|45
How odd! I had assumed that this would be an error. On the
other hand, I don't really see why anyone would like to do
that, and I could accept that a tuple -> dict tool would
fail silently on something like this. I haven't tried this
with db_row etc...
--
Magnus Lycka, Thinkware AB
Alvans vag 99, SE-907 50 UMEA, SWEDEN
phone: int+46 70 582 80 65, fax: int+46 70 612 80 65
http://www.thinkware.se/ mailto:magnus at thinkware.se
More information about the DB-SIG
mailing list