Difference between revisions of "SYSPROCEDURECOLUMNS"

From Recital Documentation Wiki
Jump to: navigation, search
(Products)
Line 52: Line 52:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL]]
 
[[Category:SQL]]
 
[[Category:System Tables]]
 
[[Category:System Tables]]

Revision as of 16:41, 9 December 2009

Purpose

Description of the input, output and results associated with certain stored procedures available


See Also

DATA TYPES, SELECT, SYSTEM TABLES


Description

System Tables are system defined read-only tables. You can query these tables using the SELECT statement.


Column Data Type Width Description
PROCEDURE_CAT C 100 Procedure catalog
PROCEDURE_SCHEM C 30 Procedure schema
PROCEDURE_NAME C 30 Procedure name
COLUMN_NAME C 30 Column/parameter name
COLUMN_TYPE N 1 Kind of column/parameter
DATA_TYPE N 2 SQL data type
TYPE_NAME C 30 SQL type name
PRECISION N 2 Precision
LENGTH N 4 Length in bytes of data
SCALE N 2 Scale
RADIX N 1 Radix
NULLABLE N 1 Can it contain NULL
REMARKS C 30 Comment describing parameter/column


Example

EXEC SQL
SELECT *
FROM sysprocedurecolumns;


Products

Recital, Recital Server