Showing posts with label DB2. Show all posts
Showing posts with label DB2. Show all posts

Sunday

SQL0668N Operation not allowed for reason code "7" on table. SQLSTATE=57016

0 comments
Database error db2 error while insert,update, select sql queries.
Error:
SQL0668N Operation not allowed for reason code "7" on table. SQLSTATE=57016

Solution:
Execute the following code to solve this issue:
  
    1. Switch to your db2 acc (su db2inst1).
    2. Connect to database - db2 connect to dbnme


    3. Execute the following commands in the terminal.

           
         



Monday

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

0 comments
   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 

Don't Forget To Join US Our Community
×
blogger