Now let's use inline SQL PL to achieve the same effect.
现在,让我们使用内联sQL PL来取得相同的效果。
To address the first issue, DB2 supports the concept of inline SQL PL.
为了解决第一个问题,DB 2支持内联sQL PL的概念。
CREATE with errors support has been added for the views and inline SQL functions.
为视图和内联s QL函数添加了带有错误支持的CREATE。
Previous to DB2 9.7, they only supported inline SQL PL, which is a small subset of SQL PL.
在DB2 9.7之前,它们仅支持内联SQLPL,这只是 SQL PL的一个小子集。
In the context of inline SQL PL UNIONs are used to drive statements in a sequential fashion.
在内联sQL PL的上下文中,UNION用于以一种连续的方式派生出语句。
Without their work in Starburst, inline SQL PL and data-change-operations in the FROM clause could not exist.
如果没有他们在Starburst的工作,就不存在from子句中的内联sQL PL和数据更改操作。
For those truly interested in the internal workings of inline SQL PL, more details can be found in the patents referenced in the resources section of this article.
对于那些对内联s QLPL的内部原理真正感兴趣的读者,可以在本文参考资料一节中给出的参考资料中发现更详细的信息。
Previously, performance metrics were only available for inline style applications and for those for which SQL was captured using client optimization.
此前,性能指标只适用内联风格应用程序,以及使用客户端优化为其捕获SQL的应用程序。
When using inline methods, you can invoke methods defined in the data interface and pass the SQL statement as a parameter in the invocation of a method.
当使用内联方法编程风格时,用户可以调用Data接口中定义的方法,将sql语句作为方法调用中的一个参数。
As with inline methods, annotated methods are rooted in the way SQL statements are defined in the application.
与内联编程风格一样,带注释的方法也起源于应用程序定义sql语句的方式。
Error handling: the new stored procedure now returns SQLCA with proper SQLCODE and SQLSTATE that is more inline with the error handling framework when using SQL.
错误处理:新的存储过程现在返回带有适当SQLCODE和SQLSTATE的SQLCA,在使用SQL时与错误处理框架更加内联。
With inline methods, SQL statements are declared or constructed at runtime, and passed as instances of String to common Data interface methods.
在内联风格中,sql语句是在运行时声明或构造的,并作为String的实例传递给公共的Data接口方法。
If your Hibernate application USES JPA V2.0 Criteria API or your application USES inline queries, you can use incremental capture to get the SQL from these queries and convert to static SQL.
如果您的Hibernate应用程序使用Criteria查询,那么可以使用增量捕捉模式获取Criteria查询的sql语句,并将其转化为静态SQL。
If your Hibernate application USES JPA V2.0 Criteria API or your application USES inline queries, you can use incremental capture to get the SQL from these queries and convert to static SQL.
如果您的Hibernate应用程序使用Criteria查询,那么可以使用增量捕捉模式获取Criteria查询的sql语句,并将其转化为静态SQL。
应用推荐