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.

......
CallableStateme nt stmt = _dbConnection.p repareCall("CAL L
SYSPROC.ADMIN_C MD(?)");
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.executeUpd ate();
.....

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]

Re: What is SQLCODE=-3196?

Erwin Leonardi wrote:

Hi all,
>
I am writing a Java code for importing data to DB2. The following
lines are the code.
>
.....
CallableStateme nt stmt = _dbConnection.p repareCall("CAL L
SYSPROC.ADMIN_C MD(?)");
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.executeUpd ate();
....
>
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?=]

Re: What is SQLCODE=-3196?

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.
>
.....
CallableStateme nt stmt = _dbConnection.p repareCall("CAL L
SYSPROC.ADMIN_C MD(?)");
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.executeUpd ate();
....
>
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. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-