Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2009
    Posts
    6

    Exclamation Unanswered: ERROR while using VARCHAR2

    hi i tried using VARCHAR2 and this is the error i got:

    Code:
    create table tst (name VARCHAR2(30));
    
    DB21034E  The command was processed as an SQL statement because it was not a
    valid Command Line Processor command.  During SQL processing it returned:
    SQL0104N  An unexpected token "VARCHAR2" was found following "eate table TST
    (name".  Expected tokens may include:  "VARCHAR".  SQLSTATE=42601
    Have any of you'll got similar errors?

    im am currently using Db2 version 9.1.2 on an AIX server

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    VARCHAR2 is not a valid data type in standard SQL and DB2's dialect.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    VARCHAR2 is supported in V9.7, but not before then.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    I stand corrected. I just checked V9.1 and V9.5 manuals...
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Version 9.7 has a wide variety of Oracle compatibility features, including CLP Plus, that would be helpful to Oracle DBA's not familar with DB2.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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