IBM Support

LI74993: DB2 CLP DOES NOT SUPPORT THE <CR> CHARACTER (0X0D) AT THE LAST AND SECOND LAST POSITION OF CLP STATEMENT.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 1) To input the carriage return character, press (Ctrl+V+M) or
    (Ctrl+V)+(Ctrl+M) or (Ctrl+V)+Enter. (In vi editor or on prompt)
    2) In db2 prompt mode, create and drop a table which contains
    the carriage return character. The table name should be quoted.
       db2 => create table "tab1^M" (c1 int)
       DB20000I  The SQL command completed successfully.
       db2 => drop table "tab1^M"
       DB21034E  The command was processed as an SQL statement
       because it was not a valid Command Line Processor command.
       During SQL processing it returned:
       SQL0010N  The string constant beginning with ""tab1" does not
       have an ending string delimiter.  SQLSTATE=42603
    3) The table can't be dropped in shell command prompt
       => db2 'drop table "tab1^M"'
       DB21034E  The command was processed as an SQL statement
       because it was not a valid Command LIne Processor command.
       During SQL processing it returned:
       SQL0204N  "IIDEV22.tab1^M" is an undefined name.
       SQLSTATE=42704
       [1192] [iidev22@db2esv39] /home2/iidev22/sqllib/db2dump
    
       => db2 "drop table \"tab1^M\""
       DB21034E  The command was processed as an SQL statement
       because it was not a valid Command Line Processor command.
       During SQL processing it returned:
       SQL0010N  The string constant beginning with ""tab1" does not
       have an ending string delimiter.  SQLSTATE=42603
    
    4) This issue is not reproducible on Windows, because we can't
       type ^M(ctrl+V+M) on windows.
    

Local fix

  • Local Fix: Put the commands in a script and execute
      db2 -tvf <script_name>
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of the DB2 CLP                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The DB2 Command Line Processor (CLP) does not support the    *
    * 'carriage return' character (x'0D') in the last or second    *
    * last position of a CLP statement. The command will fail with *
    * a DB21034E and SQL0100N errors.                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Workaround is to put the commands in a script and execute:   *
    * db2 -tvf <script_name>                                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 v9.5 FP6
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI74993

  • Reported component name

    DB2 UDE ESE LIN

  • Reported component ID

    5765F4104

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-11-04

  • Closed date

    2010-07-19

  • Last modified date

    2010-07-19

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    IC64812 IC64819 IC65662 IC65663 IC65690 IC65777 IC65821 IC71171
    IC71173

Fix information

  • Fixed component name

    DB2 UDE ESE LIN

  • Fixed component ID

    5765F4104

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
19 July 2010