DB2 query isuue

Discussion in 'Databases' started by madura99, Feb 24, 2008.

0
  1. #1
    Please tell me if you have any idea regarding following error



    ------------------------------ Commands Entered ------------------------------
    select * from 'ec1481df.c862f974.bd8abdb.20310320-437c-4cf4.8944.03b02f0344c0_FD';
    ------------------------------------------------------------------------------
    select * from 'ec1481df.c862f974.bd8abdb.20310320-437c-4cf4.8944.03b02f0344c0_FD'
    SQL0104N An unexpected token "'ec1481df.c862f974.bd8abdb.20310320-43" was
    found following "select * from ". Expected tokens may include:
    "<table_ref_list>". SQLSTATE=42601

    SQL0104N An unexpected token "'ec1481df.c862f974.bd8abdb.20310320-43" was found following "select * from ". Expected tokens may include: "<table_ref_list>".
     
    madura99, Feb 24, 2008 IP
  2. juust

    juust Peon

    Messages:
    214
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #2
    the tabel_ref_list means only defined table-names are allowed

    are you trying to use a variable as table name ?
     
    juust, Mar 1, 2008 IP