Monday

SQL0104N An unexpected token "." was found following "v1012_linuxia32_expc".Expected tokens may include: ",". SQLSTATE

   Are you getting this error in DB2 .Follow this post to solve this error
SQL0104N An unexpected token "." was found ... SQLSTATE=1402454


          Recently i faced this error while executing  a DB2 command like below

                    $    su db2inst1
                    $   connect to database <database name>
                    $   create table <table name> ( name varchar(20) , sub varchar(20) )
  error :
          SQL0104N An unexpected token "." was found following "v1012_linuxia32_expc".Expected tokens may include: ",". SQLSTATE

To solve : 

   I solved this error by removing some gaps in between the query
    for instance :      $    db2 select * from tablename     (if you get error )
     
              try                  $    db2 select *from tablename
              try                  $    db2 "select * from tblnme"

other error related to DB2

     SQL0104N An unexpected token "." was found END OF Statements 




  DB2 Basic commands List 

0 comments:

Post a Comment

Don't Forget To Join US Our Community
×
blogger