美文网首页
(DB2)解决SQL3035N The tablename p

(DB2)解决SQL3035N The tablename p

作者: 三叉戟渔民 | 来源:发表于2018-05-15 19:56 被阅读0次
    场景:
    #db2
    #list db directory
    #connect to test
    #import from /home/db2inst1/ixf/test.IXF of ixf create into test;
    
    警示:

    SQL3035N The tablename parameter in the target specification is not valid.

    官网解释:

    https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.messages.sql.doc/doc/msql03035n.html

    For IMPORT, the tablename in the Action String (for example, "REPLACE into ...") is not valid. For LOAD, the tablename or the exception tablename in the Action String is not valid.The command cannot be processed.

    大致翻译:目标规范中的表名参数无效

    解决:
    #import from /home/db2inst1/ixf/test.IXF of ixf create into test
    #把分号去掉

    相关文章

      网友评论

          本文标题:(DB2)解决SQL3035N The tablename p

          本文链接:https://www.haomeiwen.com/subject/lomydftx.html