File Name:

DC@FBL, LX_FBL

Description:

This table stores BLOB (Binary Large Object) information associated with some special types of components (e.g.: Bitmaps).
Note that the sequence number is required because a blob's item data can be much longer than the 250 bytes allocated to store it. No binary data is allowed in this table. Where data is binary (eg: content of a bitmap) it must be converted to a character hex representation.
The relatively short 250 bytes has been specifically chosen to avoid problems with SQL/Server. 

Implemented in:

7.50 / H4

LANSA for i Library:

<<dtalib>>

Visual LANSA Collection:

LX_DTA

Field Name Prefix

FBL, XBL

Required for Run Only System?

Yes

LANSA for i Logical Views

Name

Use

Keys/Description/Comments

DC@FBLV1

Read

FBLP#I, FBLCID, FBLCTX, FBLBI1, FBLBI2, FBLITM, FBLSEQ

DC@FBLV2

Update

Same as DC@FBLV1.

Visual LANSA Database Index

Name

Unique?

Columns

LX_FBL_PRIM

Y

XBLP_I, XBLCID, XBLCTX, XBLBI1, XBLBI2, XBLITM, XBLSEQ

Record Layout

Key

Field Name

Description

LANSA for i Type

Visual LANSA Type

Comments

1

P_I

Partition Identifier

A 3

CHAR(3)


2

CID

Component Class Identifier

A 10

CHAR(10)


3

CTX

Context Identifier

P 7,0

LONG


4

BI1

Blob Identifier 1

A 10

CHAR(10)


5

BI2

Blob Identifier 2

A 10

CHAR(10)


6

ITM

Item Identifier

P 7,0

LONG


7

SEQ

Sequence for item continuation

P 7,0

LONG



LEN

Length of data in this storage row

P 7,0

LONG



HEX

Item data in character hex format

A 250

STRING(250)