You can also explicitly specify the code page in the CREATE DATABASE statement with the USING CODESET clause.
还可以在CREATEdatabase语句中使用USING codeset子句显式地指定编码页。
If your JDBC program USES prepared statements and parameter markers, queries are processed faster if they are found in the database statement cache.
如果您的JDBC程序使用已经准备好的语句和参数标志,并且如果在数据库语句缓存中找到了它们的话,查询过程将处理地更快。
When you create a database using the create database statement, the code page for the database will be derived from the operating system locale setting.
在使用CREATEdatabase语句创建数据库时,将从操作系统的地区设置推导出数据库的编码页。
Notice in Listing 1 that the autoCommit value is set to true, indicating to the DBMS that the local transaction should be committed after each database statement.
注意,在清单1中,autocommit值设置为true,这将指示DBMS应该在各数据库语句之后提交本地事务。
With this solution, exposing a database statement as Web service operation is as simple as dragging and dropping an SQL statement or stored procedure into a Web service folder.
通过这个解决方案,将数据库语句公布为Web服务操作非常简单,只需将sql语句或存储过程拖放到一个Web服务文件夹中。
In order to use the procedure, it must be registered in the database with the following SQL statement.
为了使用这个存储过程,必须用下面的sql语句将该过程注册到数据库中。
Use the RENAME statement to rename a column, table, or database on every participant in the replicate.
使用RENAME语句重新命名执行复制的每个成员的列、表或数据库。
Even though the program runs on the application server, it will use the database clock in the SQL statement.
尽管程序在应用服务器上运行,但是它将使用sql语句中的数据库时钟。
The database server automatically issues the prepare statement to update any prepared objects that reference the table.
数据库服务器自动发出PREPARE命令,更新引用该表的任何编译过的对象。
Once you have set up the plug-in on both the client and database server, issue a connect statement to test the plug-in.
在客户机和数据库服务器上都设置好插件之后,发出一条连接语句以测试插件。
First, you should turn off autocommit mode so the results of each SQL statement aren't automatically committed to the database.
首先,应当关闭自动提交模式,这样,每条sql语句的结果不会被自动提交给数据库。
Issuing a COMMIT records all the work since the last COMMIT statement "for keeps" in the database.
发出commit会将自上一个commit语句之后的所有工作“永远”记录到数据库中。
For example, the statement, process, and database instance failures don't require administrator intervention.
例如,语句、流程和数据库实例故障就不需要管理员干预。
The database server automatically issues the UPDATE statistics statement to recalculate routine statistics for all SPL routines that reference the table.
数据库服务器自动发出UPDATESTATISTICS语句,为引用该表的所有SPL例程重新计算例程统计信息。
Another important factor that affects SQL statement performance is database statistics.
影响sql语句性能的另一个重要因素是数据库统计。
The activation of dynamic statement caching will vary with database and operating system.
在不同的数据库和操作系统中,动态语句高速缓存的激活是不同的。
If not, you likely get a PHP stack trace, informing you that the database connection failed or the INSERT statement did not work.
否则,您可能会得到一个php堆栈跟踪,告诉您数据库连接失败或者insert语句不工作。
This program executes a dynamically prepared DB2 SQL statement to retrieve CURRENT DATE from the database.
这个程序执行一条动态生成的DB2SQL语句,从数据库中获取CURRENTDATE。
Finally, we retrieve the results of our SQL statement and close the connection to the database.
最后,我们将检索sql语句的结果并关闭数据库连接。
This avoids recompiling the statement in the database server for each execution.
这样就可以避免在每次执行时都在数据库服务器中重新编译语句。
In this case, the only parsing is copying the data values from the message's mapped data structure to the database table's INSERT SQL statement.
这种情况下,解析之需要将数据值从消息的映射数据结构复制到数据库表的INSERTsql语句。
The GRANT statement syntax for other database objects is similar and is available in the DB2 UDB documentation.
其他数据库对象的grant语句语法是相似的,请参考db 2UD b文档。
The access plan is created by the database engine based on the SQL statement that is submitted.
访问计划是由数据库引擎根据提交的sql语句创建的。
The function of AIO is to perform disk I/O when SQL statement accessing or updating database data.
AIO的功能是在SQL语句访问或更新数据库数据时,执行磁盘I/O。
A client connects to the database using the connect statement specifying the database name and optionally the userid and password.
客户机使用connect语句连接数据库,这时要指定数据库名,还可以指定用户id和密码。
Database Connection a client connects to the database using the connect or the use statement specifying the database name and optionally the userid and password.
数据库连接客户机使用CONNECT或use语句连接数据库,这时要指定数据库名,还可以指定用户id和密码。
The federated database simply takes the SQL statement, translates it into valid Oracle syntax and passes it onto the Oracle database for processing.
联邦数据库提取sql语句,将它转换成有效的oracle语法,并传递到Oracle数据库上进行处理。
After the above statement is executed, the database mydb appears in the instance directory.
执行了以上语句之后,数据库mydb将出现在实例目录中。
If we issued the following statement on a two-partition database.
如果在一个由两个分区组成的数据库上发出以下语句。
You may get a warning message when you issue the connect statement if the test database already exists.
如果test数据库已经存在,在发出connect语句时,会得到警告消息。
应用推荐