Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    General Deheza, Cba, Arg.

    Lightbulb Unanswered: error SQL0104N in db federated

    Is this my problem:

    I´ve a db federated (as/400 v5.1) on db2 7.2 linux

    intent to realize the following:

    select cast(col1 as character(3) ccsid 37) as col1 from tab1

    appears me the following error:

    SQL0104N An unexpected token "abac01 as characer(" was found following
    "select (". Expected tokens may include: "<space>". SQLSTATE=42601

    thanks and excuse by my english.
    Last edited by achiola; 05-03-02 at 10:37.

  2. #2
    Join Date
    Apr 2002
    The syntax isn't quite what I'm used to. I ran the following 2 queries to confirm in my mind that is is the brackets "(", causing you the problem.

    db2 => select ibmreqd from sysibm.sysdummy1


    1 record(s) selected.

    db2 => select (ibmreqd from sysibm.sysdummy1)

    SQL0104N An unexpected token "sysibm" was found following "select (ibmreqd from". Expected tokens may include: "(". SQLSTATE=42601
    db2 =>

Posting Permissions

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