What is SQLCODE=-3196?

[Erwin Leonardi]

Hi all,

I am writing a Java code for importing data to DB2. The following
lines are the code.

......
CallableStatement stmt = _dbConnection.prepareCall("CALL
SYSPROC.ADMIN_CMD(?)");
sql = "IMPORT FROM \"c:/data.tbl\" OF DEL MODIFIED BY COLDEL0x09
METHOD P (1, 2) " +
"INSERT INTO MyTable (ID, NAME) ";
stmt.setString(1, sql);
stmt.executeUpdate();
.....

The above codes will raise the following DB2 SQL Error

DB2 SQL Error: SQLCODE=-3196, SQLSTATE= , SQLERRMC=null,
DRIVER=3.50.152

I have tried to search what the error code means. I could not find the
information on SQLCODE=-3196. Do you know what it means?

Thanks
Erwin

[Jan M. Nelken]

Erwin Leonardi wrote:

Hi all,

I am writing a Java code for importing data to DB2. The following
lines are the code.

.....
CallableStatement stmt = _dbConnection.prepareCall("CALL
SYSPROC.ADMIN_CMD(?)");
sql = "IMPORT FROM \"c:/data.tbl\" OF DEL MODIFIED BY COLDEL0x09
METHOD P (1, 2) " +
"INSERT INTO MyTable (ID, NAME) ";
stmt.setString(1, sql);
stmt.executeUpdate();
....

The above codes will raise the following DB2 SQL Error

DB2 SQL Error: SQLCODE=-3196, SQLSTATE= , SQLERRMC=null,
DRIVER=3.50.152

I have tried to search what the error code means. I could not find the
information on SQLCODE=-3196. Do you know what it means?

Thanks
Erwin

DB2 is your friend (and also authoritative authority) - just ask the
question:

D:\>db2 ? sql3196
SQL3196N The input file was not found.

Explanation:

The source file to be loaded into a database could not be found in the
path indicated by the datafile parameter.

The command cannot be processed.

User response:

Verify that the input file does exist and that the path to it is
correct.

Jan M. Nelken

[=?ISO-8859-1?Q?Gregor_Kovac=28?=]

Hi!

If you want to use IMPRO from ADMIN_CMD the file from where you import
has to be located on the same machine as your instance.

Best regards,
Kovi

Erwin Leonardi pravi:

Hi all,

I am writing a Java code for importing data to DB2. The following
lines are the code.

.....
CallableStatement stmt = _dbConnection.prepareCall("CALL
SYSPROC.ADMIN_CMD(?)");
sql = "IMPORT FROM \"c:/data.tbl\" OF DEL MODIFIED BY COLDEL0x09
METHOD P (1, 2) " +
"INSERT INTO MyTable (ID, NAME) ";
stmt.setString(1, sql);
stmt.executeUpdate();
....

The above codes will raise the following DB2 SQL Error

DB2 SQL Error: SQLCODE=-3196, SQLSTATE= , SQLERRMC=null,
DRIVER=3.50.152

I have tried to search what the error code means. I could not find the
information on SQLCODE=-3196. Do you know what it means?

Thanks
Erwin

--
____________________________
|http://kovica.blogspot.com|
-----------------------------~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-