[janekow]

I am facing a problem on SELECT operation not running when data IMPORT.

I am using DB2 UDB V7.1 in Winnt platform. My problem is when I perform large number of data IMPORT in DB2 Command Window, during IMPORT I issued a
SELECT operation in DB2 Command Center, but the SELECT operation not processed during data IMPORT. The SELECT operation only worked after all
the IMPORT operation finished.

From what I know, the SELECT operation should be able to perform during data IMPORT.

[wongpcl]

You can't specify SELECT operation in a IMPORT statement. You can sepcify SELECT operation in a EXPORT statement or in a INSERT statement.

Please check with the SQL Reference and DB2 Command Reference.

Regards,

[sathyaram_s]

IMPORT takes an exclusive lock on the table and hence a 'clean' read is not possible to a table being imported ...

HTH

Cheers

Sathyaram

Originally posted by janekow
I am facing a problem on SELECT operation not running when data IMPORT.

I am using DB2 UDB V7.1 in Winnt platform. My problem is when I perform large number of data IMPORT in DB2 Command Window, during IMPORT I issued a
SELECT operation in DB2 Command Center, but the SELECT operation not processed during data IMPORT. The SELECT operation only worked after all
the IMPORT operation finished.

From what I know, the SELECT operation should be able to perform during data IMPORT.

[bbg]

I am not sure if an uncommited read 'select' will work,
'SELECT ... WITH UR". If you have result, please post it here. Thanks.

Originally posted by janekow
I am facing a problem on SELECT operation not running when data IMPORT.

I am using DB2 UDB V7.1 in Winnt platform. My problem is when I perform large number of data IMPORT in DB2 Command Window, during IMPORT I issued a
SELECT operation in DB2 Command Center, but the SELECT operation not processed during data IMPORT. The SELECT operation only worked after all
the IMPORT operation finished.

From what I know, the SELECT operation should be able to perform during data IMPORT.