There is in MS Access SQL function SUBSTR?
SELECT SUBSTR(381, 2, 10) AS G_381, G382, COUNT(G382) AS CNT
FROM TBL
WHERE G382 IS NOT NULL AND G381 IS NOT NULL AND LENGTH(G381) >= 10
GROUP BY SUBSTR(G381, 2, 10), G382
In a high volume transaction environment I have a servlet
read/write operations on a database for each time that it is called. When using a low transaction rate everything works just fine. However, when stressing the system DB2 comes back with the following message:
IBM][CLI Driver] CLI0129E...
Hi, i have been trying to write an java application (with prepared statements) on win2000. How can I set the "cursor with hold" / "cursor without hold" in the java (1.4) code ?
I try load the table.
But the system DB2 comes back with the following message in file db2diag.log:
2002-10-22-13.25.14.312000 Instance:DB2 Node:000
PID:988(db2syscs.exe) TID:2224 Appid:*LOCAL.DB2.021022082547
database_utilities call_sqluvload Probe:40 Database:BD
Load Error...
In a high volume transaction environment I have a servlet
read/write operations on a database for each time that it is called. When using a low transaction rate everything works just fine. However, when stressing the system DB2 comes back with the following message:
IBM][CLI Driver] CLI0129E...
I want to make backup of tablespace TTT (database BBB).
Wrote:
"db2 backup database BBB tablespace (TTT) online to C:\backup without prompting"
I receive the message:
"DBA1136
A backup at the tablespace level cannot be perfomed because the datebase is not enable for forward...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.