BBC.SHARED.VARA@SEC_SQLI.GET-OBJECT-SUBTYPE

Summary

Description

 Retrieves the sub-type of a given object 

Input

&BBCS_OBJECT_I#
name of the object for which the sub-type should be retrieved
Object type
VARA
Object Folder
PACKAGES/BEST-BLU/BBC.SHARED/SOURCE/DATA
Title
Retrieves the sub-type of an object
Archive Key 1
-
Archive Key 2
-
Created
Andreas Büsching am: 2022-07-03 16:24:07
Last Modified
Andreas Büsching am: 2022-07-03 16:24:29 2 x
Last Used
-

SQL

Statement (MS SQL)
SELECT OH_Name “Name”, OH_OType As “Type”, OH_SubType AS “Sub Type” FROM OH WHERE OH_Client = ? AND OH_Name = ? AND OH_DeleteFlag = 0
Statement (Oracle)
SELECT OH_Name “Name”, OH_OType As “Type”, OH_SubType AS “Sub Type” FROM OH WHERE OH_Client = ? AND OH_Name = ? AND OH_DeleteFlag = 0
Result Format

Bind Parameters

Number Parameter
1 &$CLIENT#
2 &BBCF_OBJECT_I#

Attributes

Data & Formatting

Data Type
TEXT
Force Upper Case

Script Access

If key not found
INITIAL_VALUES