Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006
    Provided Answers: 11

    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

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Try escaping double quotes with backslashes:
    $ db2 select \"User\" from \"theTable\"
    or enclose the entire statement in single quotes:
    $ db2 ' select "User" from "theTable" '
    "It does not work" is not a valid problem statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts