SQL statementto retrieve Entity (type) information from the backingstore.

SQL statementto retrieve Entity (type) information from the backingstore.

book

Article ID: KB0089859

calendar_today

Updated On:

Products Versions
TIBCO BusinessEvents Enterprise Edition -
Not Applicable -

Description

Resolution:
Description:
===========
Creating database queries using Oracle data types in backingstore.

Environment:
===========
TIBCO BusinessEvents 3.x/4.x
All Operating Systems

Resolution:
========
Table and column names are included in double quotes (“) and they are case sensitive in the SQL statement.

There are some special settings required for nested tables (e.g. concept references), but the syntax is straightforward Oracle. For datetime types use t.ENTITY."myDatetimeProperty"."tm" because this is a structured type.


select t."ENTITY"."xYzconceptproperty",t."ENTITY"."conceptproperty" from d_concepttable t where t.ENTITY."aBc"='anyvalue'

-- based on the BackingStore example (FraudDetection)
select t.ENTITY."EXTID$",t.ENTITY."Debits"
from d_account t
where t.ENTITY."AvgMonthlyBalance"='10000';

Issue/Introduction

SQL statementto retrieve Entity (type) information from the backingstore.