File Name:

DC@FFD, LX_FFD

Description

This table defines the defaults for each field type.  

Implemented in:

11 / i3

LANSA for i Library:

<<dtalib>>

Visual LANSA Collection:

LX_DTA

Field Name Prefix:

FFD, XFD

Required for Run Only System?

No

LANSA for i Logical Views

Name

Use

Keys/Description/Comments

DC@FFDV1

Read

FFDP#I, FFDTYP

DC@FFDV2

Update

Same as DC@FFDV1.

Visual LANSA Database Index

Name

Unique?

Columns

LX_FFD_PRIM

Y

XFDP_I, XFDTYP,

Record Layout

Key

Field Name

Description

LANSA for i Type

Visual LANSA Type

Comments

1

P_I

Partition Identifier

A 3

CHAR(3)


2

TYP

Field type

P 7,0

CHAR(1)



DEF

Data Dictionary Level

P 5,0

CHAR(1)

Y means can define new field of this type


FIL

File Level

A 1

CHAR(1)

Y means can add fields of this type to files 


DFT

Default default value

A 20

CHAR(20)

Default for Default value


KSH

Default Keyboard Shift

A 40

CHAR(1)



LEN

Default length


LONG



DEC

Default # of decimals


SMALLINT



EDC

Default Edit Code


CHAR(1)



IAT

Default Input Attribs


STRING(40)



OAT

Default Output Attribs


STRING(40)



SP1

Spare field


STRING(256)