DB2 for Z/os Statement prepare
The PREPARE statement creates an executable SQL statement from a string form of the statement. The character-string form is called a statement string. The executable form is called a prepared statement.
Invocation
This statement can only be embedded in an application program. It is an executable statement that cannot be dynamically prepared. It must not be specified in Java.
Authorization
The authorization rules are those defined for the dynamic preparation of the SQL statement specified by the PREPARE statement. For example, see Queries for the authorization rules that apply when a SELECT statement is prepared.
The statement that is prepared using only the EXPLAIN privilege cannot be executed, and only the descriptive information can be obtained for that statement.
Syntax
Read syntax diagram
>>-PREPARE--statement-name--------------------------------------> >--+----------------------------------------------+------------->
'-INTO--descriptor-name--+-------------------+-'
| .-NAMES--. |
'-USING--+-LABELS-+-'
+-ANY----+
'-BOTH---' >--+-+------------------------------------+--FROM--host-variable-+-><
| | (1) | |
| '-ATTRIBUTES--attr-host-variable-----' |
| (2) |
'-FROM--string-expression-------------------------------------'
https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sql_prepare.html
最新文章
- 【Linux】重定向与管道
- mysql锁SELECT FOR UPDATE【转】
- 关于iOS开发证书的一些总结(很有用)
- KVM 介绍(8):使用 libvirt 迁移 QEMU/KVM 虚机和 Nova 虚机 [Nova Libvirt QEMU/KVM Live Migration]
- Linux System Account SSH Weak Password Detection Automatic By System API
- struts2校验总结
- java出错
- JavaScript之表单验证讲解
- 支持IE6以上阴影效果纯CSS
- Copy-VMFile
- 解构控制反转(IoC)和依赖注入(DI)
- HDOJ/HDU 2549 壮志难酬(取小数点后几位~)
- Centos 下安装MongoDB
- Boost库安装与使用
- spring mvc框架 遇到的问题
- Docker镜像压缩
- shell脚本中字符串的常见操作及";command not found";报错处理(附源码)
- ADB——连接手机的三种方式
- linux(Redhat7)安装Apache
- 136.137.260. Single Number &;&; 位运算