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

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
Title
Retrieves the sub-type of an object
Archive Key 1
-
Archive Key 2
-
Created
Andreas Büsching am: 2021-04-22 08:52:51
Last Modified
Andreas Büsching am: 2021-04-22 09:21:38 5 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