OMBALTER QUEUE_TABLE

Purpose

Alter the Queue Table by resetting its properties.

Prerequisites

Should be in the context of an Oracle Module. The target Queue should exist in any Oracle Module.

Syntax

alterQTCommand =  OMBALTER ( QUEUE_TABLE "QUOTED_STRING" ( "renameClause" [
           SET "setQTPropertiesClause" ] | SET "setQTPropertiesClause" ) )
     renameClause =  RENAME TO "QUOTED_STRING"
     setQTPropertiesClause =  PROPERTIES "(" "propertyNameList" ")" VALUES "(" 
          "propertyValueList" ")"
     propertyNameList =  "UNQUOTED_STRING" { "," "UNQUOTED_STRING" }
     propertyValueList =  "propertyValue" { "," "propertyValue" }
     propertyValue =  ( "QUOTED_STRING" | "INTEGER_LITERAL" | 
          "FLOATING_POINT_LITERAL" )

Parameters

alterQTCommand

Alters the Queue Table with the given name by either renaming it or by setting it's properties or both.

renameClause

Renames the Queue Table to 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 4-7 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