For example use native SQL functions where available.
例如,尽可能使用原生s QL函数。
This must be transformed to the native SQL date datatype.
必须将其转化成原生SQL日期数据类型。
This can be seen by examining the native SQL of such a query.
这一点可以通过查看这样一个查询的原生SQL看出。
Supports binary deploy of native SQL stored procedures in DB2 for z/OS.
支持DB2for z/OS中的本地SQL存储过程的二进制部署。
Ensure that the Cognos SQL is being turned into efficient Native SQL.
保证CognosSQL被转换成有效的原生sQL。
You may also express queries in the native SQL dialect of your database.
你也可以直接使用你的数据库方言表达查询。
An interface that directly exposes the capabilities of the underlying database (Native SQL).
直接公开底层数据库功能的接口(原生sql)。
This stitching is done locally in this case and can be determined by examining the Native SQL.
本例中此连接在本地完成,可以通过检查Native SQL确定。
We already have a linked server that we are using to call native sql stored procedures on DB2 from a SQL server.
我们已经有了一个链接服务器,我们使用的是调用本地SQL的SQL服务器存储过程在DB2。
JPA also enables you to use native SQL queries against the underlying tables, and provides the ability to map back the results.
JPA还使您能够对基础表使用本机SQL查询,并提供映射回结果的能力。
The federated server communicates a remote request for data to the remote relational data source through an SQL statement in the native SQL dialect of the data source.
联邦服务器通过数据源本地SQL方言中的 SQL语句将对数据的远程请求发送到远程关系数据源。
For V9 native SQL stored procedures, the Packages folder is under the Versions folder and the package node is displayed as spname: pkgid: collid: versionid (see Figure 2).
对于v 9本机s QL存储过程,Packages文件夹在Versions文件夹下面,包节点显示为spname:pkgid:collid:versionid(见图2)。
Now, when the same query is run, the native SQL that is generated is a single select statement joining the two tables from the different catalogs at the database tier as shown in Illustration 10.
现在,当同一个查询运行时,生成的原生sQL是单个选择语句,在语句在数据库层联接来自不同目录的两个表,如图10所示。
This is particularly useful if you'd like to present your SQL application programmers with a relational model of your native XML data.
如果要为SQL应用程序的程序员提供本地XML 数据的关系模型,那么这种功能特别有用。
Incrementally move developers to an SQL Relay connection and away from reliance on personal accounts with the native database.
逐渐将开发人员移动到SQLRelay连接并远离对本地数据库的个人帐户的依赖。
Use of native DB2-like operator, where possible, for Sybase and SQL Server translations for improved performance.
尽可能为Sybase和SQLServer转换使用本地类DB 2操作符,以提高性能。
SQL procedures (external and native).
SQL过程(外部和本机)。
I used this tag to create a new function that maps types specified in the abstract model (the original input file) into SQL native types for the output file (Listing 6).
我使用该标签创建了一个新的函数,将抽象模型(原始输入文件)中指定的类型映射到输出文件中的SQL原生类型(清单6)。
SQL PL developers should use the corresponding function provided by the DB2 native compound SQL statements.
SQLPL开发人员应该使用DB 2原生复合sql语句提供的对应函数。
Caching data in the final native application form (objects) reduces path length, compared with accessing SQL-based data.
与访问基于SQL的数据相比,以最终的本机应用程序形式(对象)缓存数据可减小路径长度。
In these cases, it strongly recommend that the reader USES the native CLRPFM command rather than the SQL DELETE statement.
这种情况下,强烈建议读者使用原生的CLRPFM命令,而不是SQLdelete语句。
One big advantage of a native XML database is that it can run queries that combine (or join, in SQL parlance) information contained in multiple XML documents.
原生XML数据库一个很大的优点是,可以运行能够将包含在多个 XML 文档中的信息组合在一起的查询(或者按SQL 的说法称为联结)。
A common misconception about XQuery is that it is the SQL version of native XML databases.
关于XQuery的一个常见误解是:它是原生xml数据库的一个SQL版本。
The Embedded SQL approach for DB2 data access involves the use of an application preprocessor to translate and replace all of the SQL references with native access interfaces to the DB2 server.
用于DB 2数据访问的EmbeddedSQL方式需要使用应用程序预处理器,将所有SQL引用转换为DB 2服务器的本机访问接口。
SQL Editor - The built-in Visual Studio text editor has been extended to provide native support for DB2 SQL scripts having "intelisense" and syntax colorization as well as advanced script options.
SQL编辑器(SQLEditor)-这个内建的VisualStudio文本编辑器已经扩展为提供对DB2 SQL脚本的本机支持,具有“智能感知(intelisense)”和语法的彩色化显示(colorization)以及高级脚本选项。
Its native XML data type is easy to query with SQL and W3C-standard XQuery.
使用SQL和W3C标准的XQuery对其原生xml数据类型进行查询非常简单。
Most important, many problems are much easier to solve with a native XML database and XQuery than with a relational database and Structured Query Language (SQL).
最重要的是,和关系数据库以及结构化查询语言(SQL)相比,使用原生xml数据库和XQuery将更容易解决众多问题。
These examples highlight the power of integrating XQuery and SQL, essentially that the relational data accessed through a nickname can be used with the native XML store.
以上这些示例突出展示了XQuery和SQL集成后的强大功能,尤其是,经由昵称访问的关系数据可与原生xml存储一同使用。
I also read you can make a client app connect to the database through SQL Server Native client but then I need it installed on every PC. So I guess my question is, what is the proper way to do this?
我也读到了你可以做一个客户端应用程序连接到数据库通过SQL服务器的本地客户端但我需要安装在每一个PC所以我想我的问题是,要做到这一点的正确方法是什么?
I also read you can make a client app connect to the database through SQL Server Native client but then I need it installed on every PC. So I guess my question is, what is the proper way to do this?
我也读到了你可以做一个客户端应用程序连接到数据库通过SQL服务器的本地客户端但我需要安装在每一个PC所以我想我的问题是,要做到这一点的正确方法是什么?
应用推荐