../E14406-01.epub /> ../E14406-01.mobi />

OMBCREATE QUEUE_TABLE

Purpose

To create a Queue Table.

Prerequisites

Should be in the context of an Oracle Module. The Object Type can exist in any Oracle Module.

Syntax

createQTCommand =  OMBCREATE ( QUEUE_TABLE "QUOTED_STRING" [ SET 
          "setQTPropertiesClause" ] )
     setQTPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

createQTCommand

Creates a Queue Table with the given name.

setQTPropertiesClause

Sets properties (core, logical, physical, user-defined) for Queue Table. Valid properties are shown below:

getQTPropertiesClause

Basic properties for QUEUE_TABLE: 

Name: BUSINESS_NAME
Type: STRING(200)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Business name of the Queue Table

Name: DESCRIPTION
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Description of the Queue Table

Name: PAYLOAD_TYPE
Type: STRING(4000)
Valid Values: Any valid character string in supported character set.
Default: Empty string
Object Type for the Queue Table. This has to be the name of an Object Type  (OBJECT_TYPE) existing in any Oracle Module.

propertyNameList

The list of properties.

propertyValueList

The list of property values.

propertyValue

This clause adds the property values.

QUEUE_TABLE Object

Table 9-52 QUEUE_TABLE Object

Property Type Choices Min Max Default Description

DEPLOYABLE

BOOLEAN

true, false

none

none

true

Warehouse Builder generates a set of scripts to create an object only for those objects marked as Deployable = true.

GENERATE_QUEUE_TABLE

BOOLEAN

true, false

none

none

true

Generate code to create the queue table that will persist the messages of this Advanced Queue.

GENERATION_COMMENTS

STRING

none

none

none

empty string

Enter additional comments for the generated code.

TABLESPACE

STRING(30)

none

none

none

empty string