Application Programming Interface Guide > Built-in Procedures > SQL Definition Sets > ResourceDefs SQL Definition Set
 
ResourceDefs SQL Definition Set
The ResourceDefs SQL definition set defines data types and constants for use with resource procedures.
Location
/lib/resource/ResourceDefs
Types Tab
The Types tab contains definitions for resource procedure data types.
Data Type Name
Base Type
CopyMode
VARCHAR(255)
ParameterValues
VARCHAR(4096)
ReintrospectID
VARCHAR(255)
ReintrospectReport
VARCHAR(255)
ResourceName
VARCHAR(32767)
ResourcePath
VARCHAR(4096)
ResourceType
VARCHAR(40)
ResourceVersion
VARCHAR(255)
Constants Tab
The Constants tab contains definitions of resource procedure constants.
Constant Name
Type
ALTER NAME IF EXISTS
VARCHAR(255)
CSV ATTACH
VARCHAR(255)
FAIL IF EXISTS
VARCHAR(255)
OVERWRITE MERGE IF EXISTS
VARCHAR(40)
OVERWRITE REPLACE IF EXISTS
VARCHAR(40)
RESOURCE SUBTYPE BASIC TRANSFORM PROCEDURE
VARCHAR(40)
RESOURCE SUBTYPE CATALOG
VARCHAR(40)
RESOURCE SUBTYPE COMPOSITE WEB SERVICE
VARCHAR(40)
RESOURCE SUBTYPE DATABASE PROCEDURE
VARCHAR(40)
RESOURCE SUBTYPE DATABASE TABLE
VARCHAR(40)
RESOURCE SUBTYPE DELIMITED FILE
VARCHAR(40)
RESOURCE SUBTYPE DIRECTORY
VARCHAR(40)
RESOURCE SUBTYPE EXCEL NON ODBC POI DATA SOURCE
VARCHAR(40)
RESOURCE SUBTYPE EXTERNAL SQL PROCEDURE
VARCHAR(40)
RESOURCE SUBTYPE FILE DATA SOURCE
VARCHAR(40)
RESOURCE SUBTYPE FOLDER
VARCHAR(40)
RESOURCE SUBTYPE JAVA PROCEDURE
VARCHAR(40)
RESOURCE SUBTYPE NATIVE FUNCTION
VARCHAR(40)
RESOURCE SUBTYPE NONE
VARCHAR(40)
RESOURCE SUBTYPE OPERATION
VARCHAR(40)
RESOURCE SUBTYPE PORT
VARCHAR(40)
RESOURCE SUBTYPE RELATIONAL DATA SOURCE
VARCHAR(40)
RESOURCE SUBTYPE REST DATA SOURCE
VARCHAR(40)
RESOURCE SUBTYPE SCHEMA
VARCHAR(40)
RESOURCE SUBTYPE SERVICE
VARCHAR(40)
RESOURCE SUBTYPE SQL SCRIPT PROCEDURE
VARCHAR(40)
RESOURCE SUBTYPE SQL TABLE
VARCHAR(40)
RESOURCE SUBTYPE STREAM TRANSFORM PROCEDURE
VARCHAR(40)
RESOURCE SUBTYPE TRANSFORM PROCEDURE
VARCHAR(40)
RESOURCE SUBTYPE WSDL DATA SOURCE
VARCHAR(40)
RESOURCE SUBTYPE XML FILE
VARCHAR(40)
RESOURCE SUBTYPE XML FILE DATA SOURCE
VARCHAR(40)
RESOURCE SUBTYPE XML HTTP DATA SOURCE
VARCHAR(40)
RESOURCE SUBTYPE XQUERY TRANSFORM PROCEDURE
VARCHAR(40)
RESOURCE SUBTYPE XSLT TRANSFORM PROCEDURE
VARCHAR(40)
RESOURCE TYPE CONTAINER
VARCHAR(40)
RESOURCE TYPE DATA SOURCE
VARCHAR(40)
RESOURCE TYPE DEFINITION SET
VARCHAR(40)
RESOURCE TYPE LINK
VARCHAR(40)
RESOURCE TYPE PROCEDURE
VARCHAR(40)
RESOURCE TYPE TABLE
VARCHAR(40)
RESOURCE TYPE TREE
VARCHAR(40)
RESOURCE TYPE TRIGGER
VARCHAR(40)
SEND ERROR
VARCHAR(4096)
SKIP IF NO RESULTS
VARCHAR(4096)
SUMMARY
VARCHAR(4096)