Dynamic SQL

Skip to end of metadata

Created by OO_SeHwan Lim, last modified by OO_heerock on Sep 17, 2012

Go to start of metadata

Dynamic SQL
Method-1
Method-2
Method-3
Method-4

Dynamic SQL

ALTIBASE HDB supports method-1, 2, 3 except method-4 like oracle.

Method-1

This method can process only DML-statement except SELECT-statment.

Method-2

This method can process only DML-statement except SELECT-statment.

Method-3

ALTIBASE HDB doesn't support a "Fetch Across Commit".
Therefore, If you execute a commit while fetching records, your cursor will be closed.

Method-4

ALTIBASE HDB doesn't support this type.

No labels

Icon

Icon

Copyright ⓒ 2000~2012 ALTIBASE Corporation. All Rights Reserved.
This document is provided for information purposes only and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. ALTIBASE is a registered trademark of ALTIBASE Corporation and/or its affiliates. Other names may be trademarks of their respective owners.