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

Output Generated By +1Copybook From +1 Software Engineering LLC.
Created on: 23-MAY-2020 11:22 AM