Thread: mixed case column names
07-31-13, 03:20 #1Registered User
Provided Answers: 11
- Join Date
- Apr 2006
Unanswered: mixed case column names
db2 ese 9.7 fp 4 on windows 2008
this customer has nicknames to sql/server-oracle and db2/I
they have columns that have been created in a target system with mixed case names
no problem with this when doing select "colname" from table from a script file
but I do not remember how to do this in the command window of db2
same issue with a column named user in a target table
when doing select "USER" from table from script we get the correct data, but from command window User is translated to connect user and not data
thanks for refreshing my memory... (that is what happens when getting older)Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified
07-31-13, 07:45 #2:-)
Provided Answers: 1
- Join Date
- Jun 2003
- Toronto, Canada
Try escaping double quotes with backslashes:
$ db2 select \"User\" from \"theTable\"
$ db2 ' select "User" from "theTable" '---
"It does not work" is not a valid problem statement.