SQL Error "SQL3040N" when execute DB2import under DB2 version 7.2

[szechi]

Greetings,
I am facing the following error when trying to use DB2 import
command under DB2 version 7.2.

SQL3040N Unable to use the lobpath/lobfile parameters as specified.
Reason code: "1"

My db2 command is as followed:

DB2 CONNECT TO TESTDB USER db2admin USING db2admin
DB2 IMPORT FROM "D:\TestData\import.out" OF DEL LOBS FROM "D:\TestData"
MODIFIED BY COLDEL"|" DATEFORMAT=\"DD/MM/YYYY\" LOBSINFILE METHOD P
(1,2,3,4,5,6,7) messages "D:\TestData\import.msg" INSERT INTO
TEST.TABLEQ ( QGNGID, QGNID, QVERSEQ, QPAGE, QIMG, QDATE, QTIME )
DB2 COMMIT WORK
DB2 CONNECT RESET

This is the content of my "import.out" file:

1|33547|1|1|996962FBS|18/01/2006|22:45
1|33548|1|1|996962FRU|18/01/2006|22:45
1|33549|1|1|996963RBS|18/01/2006|22:45

and my image files ( "996962FBS", "996962FRU", "996963RBS") are located
under "D:\TestData".

I have been using the same way to import data under DB2 version 8.2
and there is no such error. What would be the correct DB2import syntax
to use for version 7.2? Your quick feedback is very much appreciated.

[Knut Stolze]

sz****@gmail.com wrote:

Greetings,
I am facing the following error when trying to use DB2 import
command under DB2 version 7.2.

SQL3040N Unable to use the lobpath/lobfile parameters as specified.
Reason code: "1"

Read the explanation of the error message and act accordingly:

$ db2 "? sql3040"

The last part of the explanation for reason code 1 is something you ignored.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[szechi]

Hi,
Thanks for your prompt reply. Finally I managed to solve this problem
and noticed the following differences in DB2 "import" syntax between
version 7 and version 8.

In DB2 version 7:
1) There is no double quote (") between the path specified.
2) There must be a slash (\) after you specify the LOB path.
3) There are two double quotes("") for DATAFORMAT

For example:
Import script in Version 8:

DB2 IMPORT FROM "D:\TestData\import.out" OF DEL LOBS FROM "D:\TestData"

MODIFIED BY COLDEL"|" DATEFORMAT=\"DD/MM/YYYY\" LOBSINFILE METHOD P
(1,2,3,4,5,6,7) messages "D:\TestData\import.msg" INSERT INTO
TEST.TABLEQ ( QGNGID, QGNID, QVERSEQ, QPAGE, QIMG, QDATE, QTIME )

and the workable script in version 7 should be:

DB2 IMPORT FROM D:\TestData\import.out OF DEL LOBS FROM D:\TestData\
MODIFIED BY COLDEL"|" DATEFORMAT="\"DD/MM/YYYY\"" LOBSINFILE METHOD P
(1,2,3,4,5,6,7) messages D:\TestData\import.msg INSERT INTO
TEST.TABLEQ ( QGNGID, QGNID, QVERSEQ, QPAGE, QIMG, QDATE, QTIME )
Best regards,
TAN

Knut Stolze wrote:

sz****@gmail.com wrote:

Greetings,
I am facing the following error when trying to use DB2 import
command under DB2 version 7.2.

SQL3040N Unable to use the lobpath/lobfile parameters as specified.
Reason code: "1"

Read the explanation of the error message and act accordingly:

$ db2 "? sql3040"

The last part of the explanation for reason code 1 is something you ignored.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany