>>-PREPARE--statement-name--------------------------------------> >--+-----------------------------------------------------------------+--> | .-SQL-. .-LOCAL--. | '-+-USING--+-----+--DESCRIPTOR--+--------+--SQL-descriptor-name-+-' | '-GLOBAL-' | '-INTO----descriptor-name----+-------------------------+------' '-USING--+-NAMES--------+-' +-SYSTEM NAMES-+ +-LABELS-------+ +-ANY----------+ +-BOTH---------+ '-ALL----------' >--+-FROM--string-expression-----------------------+----------->< '-+---------------------------+--FROM--variable-' '-ATTRIBUTES--attr-variable-'
attribute-string: .------------------------------------. V | (1) |----+--------------------------------+-+-----------------------| +-+-ASENSITIVE-------------+-----+ | +-INSENSITIVE------------+ | | | .-DYNAMIC-. | | | '-SENSITIVE--+---------+-' | +-+-NO SCROLL-+------------------+ | '-SCROLL----' | +-+-WITHOUT HOLD-+---------------+ | '-WITH HOLD----' | +-+-WITHOUT RETURN-------------+-+ | | .-TO CALLER-. | | | '-WITH RETURN--+-----------+-' | | '-TO CLIENT-' | +-fetch-first-clause-------------+ +-+-read-only-clause-+-----------+ | '-update-clause----' | +-optimize-clause----------------+ '-isolation-clause---------------'
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.