by: leecho |
last post by:
Hi,
recently, i was assigned as a new dba for our system. I found that my
statistic keep change from time to table. To look for the cause, i
wanna to lock a table, means only allow user to...
|
by: Alex |
last post by:
Hello everybody
I have table T1 with 10000000 rows.
I want to import 1000000 rows(takes 2 hrs ) and while import is
running
run select like
select T1.* from T1 where TA = 10 by more then...
|
by: Colleyville Alan |
last post by:
My app is giving me this error.
Run-time error 3211:
The database engine could not lock table 'Sorted_Template' because it is
already in use by another person or process.
When I run the app...
|
by: Sandy |
last post by:
Hi
I want to lock a table using JDBC as I want to perform some query's (read
and write) in exclusive mode. Different threads will be executing the same
code simultaneously. I am using the...
|
by: simonZ |
last post by:
I create a transaction:
sqlTran=sqlConn.BeginTransaction(IsolationLevel.Serializable);
Then, I insert some data into report table with sqlCommand object:
oCmd = new...
|
by: sang |
last post by:
Hi
I want to lock the table with both read and write there is no action held after lock the table.
I know how to lock the table with read and write,
lock table mytable read;
lock table...
|
by: Himmel |
last post by:
I have added a section of code to a function that is designed to copy data from several tables and place them into a single table. The new table already contains a unique ID and name, and I am...
|
by: ewarts |
last post by:
Hey Guys,
I have an access database with a few tables and forms. I was trying to add a new combo box to one of my forms and to do so i needed to add the referenced data to my reference data table....
|
by: tembil |
last post by:
Hi,
can anyone plz help me, I'm trying to insert data into a table from another table and I'm getting this error:
The total number of locks exceeds the lock table size, how can I fix this.
thanx
|
by: Frederick Tant |
last post by:
DB2 V9.7
The DB is used by 1 application with no concurrent applications.
I got the problem that large update/insert cause lock escalation, to solve the issue I set a lock on the table so...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|