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

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%'

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

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..