Re: DBCS issues revisited

Some parts of it are there.

Create index rob.midrangel on gdidivf.iim
(char(ivend) as CharacterVendorNumber for column CHARVEND, iprod as
ItemNumber)
rcdfmt midrangelR
- comment - Index columns are added first automatically
add
iven2,
idesc,
iclas;

- comment - Wish list
Create index rob.midrangel on gdidivf.iim
(char(ivend) as CharacterVendorNumber for column CHARVEND, iprod as
ItemNumber)
rcdfmt midrangelR
- comment - Index columns are added first automatically
add
char(iven2,5) as CharacterVendorNumberTwo for column CHARVEND2,
idesc as DescriptionOfItem for column ItemDesc,
iclas as ItemClass;


DSPFFD ROB/MIDRANGEL
File Information
File . . . . . . . . . . . . . . . . . . . : MIDRANGEL
Library . . . . . . . . . . . . . . . . . : ROB
File location . . . . . . . . . . . . . . . : *LCL
Externally described . . . . . . . . . . . : Yes
Number of record formats . . . . . . . . . : 1
Type of file . . . . . . . . . . . . . . . : Logical
SQL file type . . . . . . . . . . . . . . . : INDEX
File creation date . . . . . . . . . . . . : 10/22/09
Record Format Information
Record format . . . . . . . . . . . . . . . : MIDRANGELR
Format level identifier . . . . . . . . . . : 424BB69185AED
Number of fields . . . . . . . . . . . . . : 5
Record length . . . . . . . . . . . . . . . : 57
Format text . . . . . . . . . . . . . . . . : FORMAT0001
Field Level Information
Data Field Buffer Buffer Field Column

Field Type Length Length Position Usage Heading

CHARVEND CHAR 7 7 1 Input
CHARACTERVENDORNUMBE
R
Alternative name . . . . . . . . . . . . :
CHARACTERVENDORNUMBER
Coded Character Set Identifier . . . . . : 37
Derived field text . . . . . . . . . . . :
CHAR ( IVEND )
Data Field Buffer Buffer Field Column

Field Type Length Length Position Usage Heading

ITEMNUMBER CHAR 15 15 8 Both Item
Number
Field text . . . . . . . . . . . . . . . : Item Number
Renamed field . . . . . . . . . . . . . . : IPROD
Coded Character Set Identifier . . . . . : 37
IVEN2 PACKED 5 0 3 23 Both Alt Vndr

No
Field text . . . . . . . . . . . . . . . : Alternate Vendor Number

Editing Information
Edit code . . . . . . . . . . . . . . . : Z
IDESC CHAR 30 30 26 Both Item
Description
Field text . . . . . . . . . . . . . . . : Item Description
Coded Character Set Identifier . . . . . : 37
ICLAS CHAR 2 2 56 Both Itm
Cls
Field text . . . . . . . . . . . . . . . : Item Class
Coded Character Set Identifier . . . . . : 37

Rob Berendt