×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.