Kbase P117803: What storage area does a CLOB or BLOB field reside in?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
What storage area does a CLOB or BLOB field reside in ?
GOAL:
How to determine what storage area a LOB field resides in?
GOAL:
How can one obtain a list that shows the storage areas for all LOB fields?
GOAL:
How to determine which areas large objects are stored in?
FACT(s) (Environment):
OpenEdge 10.x
FIX:
The storage area that a LOB field resides in can be obtained by querying the VST's.
Here is a sample 4GL code:
FOR EACH _StorageObject WHERE _StorageObject._Object-Type = 3 NO-LOCK:
FIND _Field WHERE (_Field._Data-Type = "clob" OR _Field._Data-Type = "blob")
AND _Field._Fld-stlen = _StorageObject._Object-Number NO-LOCK NO-ERROR.
FIND _Area WHERE _Area._Area-Number = _StorageObject._Area-Number NO-LOCK NO-ERROR.
DISPLAY _Field._Field-Name FORMAT "x(25)" _Area._Area-Name FORMAT "x(25)".
END.
The _Object-Type is returned as 3 for LOB fields.