Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2012
    Posts
    2

    Question Unanswered: Help Required:Unable to import csv files into table in IBM DB2 V8.1.9

    Hi ,

    Im unable to import data present in CSV file into a table in IBM Db2 though the table has been successfully created and data matches the columns. it gives the below message


    SQL3304N The table does not exist.

    Explanation:

    The parameters specified on the command require that the table
    exists.

    The utility stops processing. No data is loaded.


    The exporting works fine .
    The query related to this is given below

    CONNECT TO WLPTAPDB USER "db2admin" USING ;
    IMPORT FROM "D:\DB\Data In CSV\TRAN.csv" OF DEL METHOD P (1, 2, 3, 4, 5, 6, 7, 8, 9) MESSAGES "tran" INSERT INTO MQSIADM.TFRMTN_PRPTY (SRVC_TYP, SRVC_VER, SRC_PYLD_FMT, MSG_TYP, SRC_MSG_SET_ID, SRC_WIRE_FMT, TRGT_PYLD_FMT, TRGT_MSG_SET_ID, TRGT_WIRE_FMT);
    CONNECT RESET;

    Kindly suggest me on this .


    Deepa

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    try : connect
    describe table MQSIADM.TFRMTN_PRPTY
    or db2 list tables for schema MQSIADM
    or select creator,name from sysibm.ssytables where upper(creator) like 'MQSIADM%'
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Jan 2012
    Posts
    2
    Hi przytula_guy,

    Thanks a lot for the suggestion but Im unable to import csv files and I get the below error only when I try to load the table with .csv file data

    SQL3304N The table does not exist.

    Explanation:

    The parameters specified on the command require that the table
    exists.

    The utility stops processing. No data is loaded.


    Im getting the table listed when I tried to run the commands you suggested below .Please let me know how to import the data in .csv files.

    Thanks

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if the error persists : this must be a user error
    - or connected to wrong db - is the connect succesfull
    - miss spelled tablename/schema
    verify a bit closer..
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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