error while reading the table data

[Former Member]

Hi,

I extracted the table data to the file .csv , after when I tried to query that table its giving the above error.

the output of sp_iqlocks

I am not able to read the table data after giving commit to unlock the lock.

In which isolation level the Sybase iq works? How to check the isolation level it is working?

Please any suggestion.......

[tayeb_hadjou · Accepted solution]

Hi Santosh,

If you keep Temp_Extract_Name1 set to a file name, then any select query will attempt to export data to that file.

thus, once data extract completed, you have to reset the option temp_extract_name1 to its default value to be able execute normal queries:

set temporary option Temp_Extract_Name1='' ;

Regards,

Tayeb.

[Former Member · Accepted solution]

Thanks Tayeb, Now it is working

On which Isolation level Sybase IQ works. How to check that ?

[tayeb_hadjou · Accepted solution]

IQ always works table-level snapshot versioning.

This ensures that only one user can modify a table at any given time, keeps the changes invisible to other users until the changes are complete, maintains timestamped snapshots of data objects in use at any time and allow any user to read data being modified.

Changing isolation_level parameter has no effect on IQ transactions.

It can has effect only on tables stored in catalog store (managed by Sql anywhere engine).

However User can manually lock a table to influence a particular transaction. See Lock Table statement.

Regards,

Tayeb.

[Former Member · Accepted solution]

Thanks Tayeb.