Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2016
    Posts
    4

    Unanswered: create table with char(64)

    Hi all,
    i would create a table with column char(100) into a BLU DB. The error message is "...or global variable "char(100)" is not valid.. ".
    It's a migration from 10.2 to BLU. How i can migrate a char column greater then char(63)?
    Thanks

  2. #2
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    post the code (the DDL for the create table that is failing) and the full error message, including the error code and sqlstate and the method (interface used) for executing the DDL (via CLP, via JDBC, odbc , cli other).

  3. #3
    Join Date
    Apr 2016
    Posts
    4
    create table test (test_feld char(64))

    06:10:57 [CREATE - 0 row(s), 0.025 secs] [Error Code: -604, SQL State: 42611] The length, precision, or scale attribute for column, distinct type, structured type, array type, attribute of structured type, routine, cast target type, type mapping, or global variable "char(64)" is not valid.. SQLCODE=-604, SQLSTATE=42611, DRIVER=4.18.60
    ... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.025/0.000 sec [0 successful, 0 warnings, 1 errors]

  4. #4
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    It works with db2 10.5.5 at least.
    What's your db2level command output?
    Regards,
    Mark.

  5. #5
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    The reported JDBC version is V10.5.4. But many facts are omitted from the problem description

Posting Permissions

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