DISC

Contents | What's New | Quick Links

 

ODXSQL Commands

Introduction

Software Installation

Concepts and Design

Designing Applications

Omnidex Environments

SQL Reference

Omnidex API's

Utilities

Interfaces

Performance Guide

Troubleshooting Guide

Appendix

 

 

DESCRIBE

 

DESCRIBE [ON [CURSOR] cursor] [WITH options]

Describe the last executed statement.

See Also:

EXPLAIN

 

Syntax

Example

Options

Commands

ODXSQL

SQL Reference

 

Syntax

DESCRIBE [ON [CURSOR] cursor] [WITH options]

DESCRIBE

Required.

ON [CURSOR]

Both the ON and CURSOR keywords are optional.

cursor

Optional. Indicates the cursor number that the statement to be described was executed on. If omitted, the last statement executed on the current cursor in the status array will be described.

WITH options

Optional.

top

 

Example

>select count(*) from customers
count('*')
--------------
999

1 row returned

>describe
------------------------------------------------------------
Expr. (1) : count('*')
Occurrences : 1
Actual 0 : INTEGER 4
Request 0 : C STRING 12 VALUE EXP OVRFL
------------------------------------------------------------

top

 

Options

The following options can be applied to the DESCRIBE command in a WITH options clause of the DESCRIBE statement.

FETCH

FETCHKEYS

 

 

top

Dynamic Information Systems Corporation - Omnidex Version 3.8 Build 6 J15.03-Copyright © 2003

DISC | Documentation Home