#931 Table Sourcecode not visable

3.2
closed
DB2 Plugin (16)
7
2011-05-16
2010-12-15
Claus
No

If I try to show me the sourceCode of our Tables I allways get this error in DB2 v9.5 LUW

It happens to all Tables having a default Value.

Error: An unexpected token "C" was found following "TA char(1) DEFAULT '". Expected tokens may include: "CONCAT".. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.52.95
SQLState: 42601
ErrorCode: -104
Error: An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-104", SQLSTATE "42601" and message tokens "C|TA char(1) DEFAULT '|CONCAT".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.52.95
SQLState: 56098
ErrorCode: -727
Error: An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-104", SQLSTATE "42601" and message tokens "C|TA char(1) DEFAULT '|CONCAT".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.52.95
SQLState: 56098
ErrorCode: -727

Discussion

  • Claus

    Claus - 2011-05-11

    Problem still exists:

    For Table Source Code (z/OS):
    Create Table MB_NOMIG_MITGLIED
    (
    -- Mitgliedsnummer
    MIT_NR Char ( 10 ) not Null with Default
    -- Versart
    , VERS_ART Char ( 3 ) not Null with Default
    -- Zustand
    , ZUSTAND Char ( 3 ) not Null with Default
    -- Text
    , TEXT Char ( 40 ) not Null with Default
    , Primary Key (
    MIT_NR
    )
    )

    This Tables are transfered from z/OS-Host to AIX-Host
    In my AIX I got this error while I try to open Sourcecode-Page

    Error: An unexpected token "' NOT NULL,
    VERS_ART char(3) DEFAULT '" was found following "R char(10) DEFAULT '". Expected tokens may include: "<space>".. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.52.95
    SQLState: 42601
    ErrorCode: -104
    Error: An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-104", SQLSTATE "42601" and message tokens "' NOT NULL,
    VERS_ART char(3) DEFAULT '|R char(10) DEFA".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.52.95
    SQLState: 56098
    ErrorCode: -727
    Error: An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-104", SQLSTATE "42601" and message tokens "' NOT NULL,
    VERS_ART char(3) DEFAULT '|R char(10) DEFA".. SQLCODE=-727, SQLSTATE=56098, DRIVER=3.52.95
    SQLState: 56098
    ErrorCode: -727

    ******** If you provide me with a SQL how you get this Info out of DB2 - > I will help you to catch the error!!! **********

     
  • Claus

    Claus - 2011-05-11
    • priority: 5 --> 7
     
  • Stefan Willinger

    • assigned_to: colbell --> wis775
    • labels: 404491 --> DB2 Plugin
     
  • Stefan Willinger

    Thanks for providing the sample create table statement. I can reproduce it.
    Stefan

     
  • Stefan Willinger

    Fixed in Subversion. The change will be available in the next snapshot and/or stable release.

     
  • Stefan Willinger

    • status: open --> closed
     

Log in to post a comment.