Transaction Isolation

[alanmcd]

How do I specify that I want my connection and ibec_comparetables to use a ready-only read committed transaction?
Alan

[AVX]

Code: Select all

...
dbc1 = ibec_CreateConnection(...);
ibec_SetConnectionProp(dbc1, 'TRPARAMS', 'isc_tpb_read, isc_tpb_consistency');

dbc2 = ibec_CreateConnection(...);
ibec_SetConnectionProp(dbc2, 'TRPARAMS', 'isc_tpb_read, isc_tpb_consistency');

ibec_CompareTables(...);
...


[alanmcd]

Thanks I couldn't find those functions in my book.
Alan

[alanmcd]

Actually - isn't isc_tpb_consistency table locking?
I want read commited so there's no locking and there's no garbage collection impact.
Alan

[AVX]

It was just an example, you can use your own parameters.

[alanmcd]

What's the difference between
create connection MasterDB dbname 'localhost:alias' password 'pword' user 'myuser' names ISO8859_1;
and
ibec_CreateConnection( etc
?
Can the former (CREATE CONNECTION) then use ibec_SetConnectionProp command?
I've tried it and there's no error but setting props to 'isc_tpb_read, isc_tpb_committed'
shows up as a concurrency transaction in the monitor (MON$ tables).
Alan

[AVX]

CREATE CONNECTION and ibec_CreateConnection do the same work, ibec_CreateConnection just is more handy.
You can use ibec_SetConnectionProp after any of them.

As of transaction parameters... Sorry, I forgot that ibec_CompareTables uses its own transactions inside so you cannot change their properties.
I should think on this.