HOMES Format File
Table -
Sorted Table -
Copybook -
Create Table -
Format File -
Bulk Insert -
Row Size -
Back To Table Index
10.0
32
1 SQLCHAR 0 13 "^" 1 HOMES_KEY SQL_Latin1_General_CP1_CI_AS
2 SQLCHAR 0 2 "^" 2 HOMES_GRPCD SQL_Latin1_General_CP1_CI_AS
3 SQLCHAR 0 2 "^" 3 HOME_A_NUMBER SQL_Latin1_General_CP1_CI_AS
4 SQLCHAR 0 2 "^" 4 HOME_B_KEY SQL_Latin1_General_CP1_CI_AS
5 SQLCHAR 0 1 "^" 5 HOME_A_CHANGE_FLAG SQL_Latin1_General_CP1_CI_AS
6 SQLCHAR 0 1 "^" 6 HOME_A_SITE_FLAG SQL_Latin1_General_CP1_CI_AS
7 SQLCHAR 0 4 "^" 7 HOME_A_SITE_VALUE_CODER SQL_Latin1_General_CP1_CI_AS
8 SQLCHAR 0 9 "^" 8 HOME_A_SITE_VALUE SQL_Latin1_General_CP1_CI_AS
9 SQLCHAR 0 9 "^" 9 HOME_A_CURR_VALUE SQL_Latin1_General_CP1_CI_AS
10 SQLCHAR 0 9 "^" 10 HOME_A_XFEA_VALUE SQL_Latin1_General_CP1_CI_AS
11 SQLCHAR 0 9 "^" 11 HOME_A_TOTAL_SQFTG SQL_Latin1_General_CP1_CI_AS
12 SQLCHAR 0 7 "^" 12 HOME_A_BEDROOMS SQL_Latin1_General_CP1_CI_AS
13 SQLCHAR 0 5 "^" 13 HOME_A_BATHS SQL_Latin1_General_CP1_CI_AS
14 SQLCHAR 0 5 "^" 14 HOME_A_HALF_BATHS SQL_Latin1_General_CP1_CI_AS
15 SQLCHAR 0 5 "^" 15 HOME_A_UNITS SQL_Latin1_General_CP1_CI_AS
16 SQLCHAR 0 2 "^" 16 HOME_A_FLOORS SQL_Latin1_General_CP1_CI_AS
17 SQLCHAR 0 1 "^" 17 HOME_B_CHANGE_FLAG SQL_Latin1_General_CP1_CI_AS
18 SQLCHAR 0 1 "^" 18 HOME_B_CODE SQL_Latin1_General_CP1_CI_AS
19 SQLCHAR 0 1 "^" 19 HOME_B_ADD_SQFTG_FLAG SQL_Latin1_General_CP1_CI_AS
20 SQLCHAR 0 9 "^" 20 HOME_B_VALUE SQL_Latin1_General_CP1_CI_AS
21 SQLCHAR 0 5 "^" 21 HOME_B_ITEMS SQL_Latin1_General_CP1_CI_AS
22 SQLCHAR 0 7 "^" 22 HOME_B_SPECIAL SQL_Latin1_General_CP1_CI_AS
23 SQLCHAR 0 9 "^" 23 HOME_B_TOTAL_SQFTG SQL_Latin1_General_CP1_CI_AS
24 SQLCHAR 0 3 "^" 24 HOME_B_PTS_GRADE SQL_Latin1_General_CP1_CI_AS
25 SQLCHAR 0 3 "^" 25 HOME_B_GRADE SQL_Latin1_General_CP1_CI_AS
26 SQLCHAR 0 10 "^" 26 HOME_B_ADDITION SQL_Latin1_General_CP1_CI_AS
27 SQLCHAR 0 2 "^" 27 HOMES_X_DISTRICT SQL_Latin1_General_CP1_CI_AS
28 SQLCHAR 0 1 "^" 28 HOME_B_NC_FLAG SQL_Latin1_General_CP1_CI_AS
29 SQLCHAR 0 9 "^" 29 HOME_B_NC_NEW SQL_Latin1_General_CP1_CI_AS
30 SQLCHAR 0 9 "^" 30 HOME_B_NC_ADD SQL_Latin1_General_CP1_CI_AS
31 SQLCHAR 0 9 "^" 31 HOME_B_NC_DEMO SQL_Latin1_General_CP1_CI_AS
32 SQLCHAR 0 9 "^\n" 32 HOME_B_REAPPRAISAL SQL_Latin1_General_CP1_CI_AS
To Top -
copybook.txt