forked from docs/doc-exports
Lu, Huayi
27019c2991
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com> Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: Lu, Huayi <luhuayi@huawei.com> Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
4.2 KiB
4.2 KiB
ACCESS LOCK
ACCESS LOCK allows you to read the data from a table that may have been locked for the READ or WRITE.
Use the tdMigrateLOCKoption configuration parameter to configure migration of query containing the LOCK keyword. If tdMigrateLOCKOption is set to false, the tool will skip migration of the query and will log a message.
Input - ACCESS LOCK (tdMigrateLOCKOption=True)
1 2 3 4 5 | LOCKING TABLE tab1 FOR ACCESS INSERT INTO tab2 SELECT … FROM … WHERE ...; |
Output
1 2 3 4 5 | /* LOCKING TABLE tab1 FOR ACCESS */ INSERT INTO tab2 SELECT … FROM … WHERE ...; |
Parent topic: Schema Objects and Data Definition Language (DDL)