echo Begin of Upgrade 7.0.441
echo Title: A
DBI <<\EOF
FOR TABLE GENERALLOAD
DELETE FSPS_TEXT ;
EOF
BRING << \EOF
18 11 GENERALLOAD0 
56 11 GENERALLOAD16 תיללכ תניעט תלבט0 
19 11 GENERALLOAD1 10 RECORDTYPE4 CHAR3 3 9 המושר גוס
19 11 GENERALLOAD2 4 LINE3 INT17 4 4 הרוש
33 11 GENERALLOAD4 LINE0 48 0 
19 11 GENERALLOAD3 6 LOADED4 CHAR1 1 5 ?ןעטנ
19 11 GENERALLOAD4 4 KEY14 CHAR20 20 6 1 חתפמ
19 11 GENERALLOAD5 4 KEY24 CHAR20 20 6 2 חתפמ
19 11 GENERALLOAD6 4 KEY34 CHAR20 20 6 3 חתפמ
19 11 GENERALLOAD7 5 TEXT14 CHAR56 56 5 TEXT1
19 11 GENERALLOAD8 5 TEXT24 CHAR68 68 5 TEXT2
19 11 GENERALLOAD9 5 TEXT34 CHAR68 68 5 TEXT3
19 11 GENERALLOAD10 4 INT13 INT17 4 4 INT1
33 11 GENERALLOAD4 INT10 48 0 
19 11 GENERALLOAD11 4 INT23 INT17 4 4 INT2
33 11 GENERALLOAD4 INT20 48 0 
19 11 GENERALLOAD12 4 INT33 INT17 4 4 INT3
33 11 GENERALLOAD4 INT30 48 0 
19 11 GENERALLOAD13 5 CHAR14 CHAR1 1 5 CHAR1
19 11 GENERALLOAD14 5 CHAR24 CHAR1 1 5 CHAR2
19 11 GENERALLOAD15 5 CHAR34 CHAR1 1 5 CHAR3
19 11 GENERALLOAD16 5 CHAR44 CHAR1 1 5 CHAR4
19 11 GENERALLOAD17 4 TEXT5 RCHAR100 100 10 ישפוח טסקט
19 11 GENERALLOAD18 4 INT43 INT17 4 4 INT4
33 11 GENERALLOAD4 INT40 48 0 
19 11 GENERALLOAD19 4 INT53 INT17 4 4 INT5
33 11 GENERALLOAD4 INT50 48 0 
19 11 GENERALLOAD20 4 INT63 INT17 4 4 INT6
33 11 GENERALLOAD4 INT60 48 0 
19 11 GENERALLOAD21 4 INT73 INT17 4 4 INT7
33 11 GENERALLOAD4 INT70 48 0 
19 11 GENERALLOAD22 4 INT83 INT17 4 4 INT8
33 11 GENERALLOAD4 INT80 48 0 
19 11 GENERALLOAD23 5 REAL14 REAL16 8 5 REAL1
33 11 GENERALLOAD5 REAL15 53 0 
19 11 GENERALLOAD24 5 REAL24 REAL16 8 5 REAL2
33 11 GENERALLOAD5 REAL22 50 0 
19 11 GENERALLOAD25 5 REAL34 REAL22 8 5 REAL3
33 11 GENERALLOAD5 REAL35 53 0 
19 11 GENERALLOAD26 5 REAL44 REAL22 8 5 REAL4
33 11 GENERALLOAD5 REAL45 53 0 
19 11 GENERALLOAD27 5 REAL54 REAL16 8 5 REAL5
33 11 GENERALLOAD5 REAL52 50 0 
19 11 GENERALLOAD28 5 REAL64 REAL16 8 5 REAL6
33 11 GENERALLOAD5 REAL62 50 0 
19 11 GENERALLOAD29 5 TEXT44 CHAR48 48 5 TEXT4
19 11 GENERALLOAD30 5 TEXT54 CHAR30 30 5 TEXT5
19 11 GENERALLOAD31 5 TEXT64 CHAR48 48 5 TEXT6
19 11 GENERALLOAD32 5 DATE14 DATE14 4 5 DATE1
19 11 GENERALLOAD33 5 DATE24 DATE14 4 5 DATE2
19 11 GENERALLOAD34 5 DATE34 DATE14 4 5 DATE3
19 11 GENERALLOAD35 5 DATE44 DATE14 4 5 DATE4
19 11 GENERALLOAD36 5 TEXT74 CHAR100 100 5 TEXT7
19 11 GENERALLOAD37 5 TEXT94 CHAR80 80 5 TEXT9
19 11 GENERALLOAD38 5 TEXT84 CHAR80 80 5 TEXT8
19 11 GENERALLOAD39 4 KEY44 CHAR20 20 6 4 חתפמ
19 11 GENERALLOAD40 5 CHAR54 CHAR1 1 5 CHAR5
19 11 GENERALLOAD41 5 CHAR64 CHAR1 1 5 CHAR6
19 11 GENERALLOAD42 5 CHAR74 CHAR1 1 5 CHAR7
19 11 GENERALLOAD43 5 CHAR84 CHAR1 1 5 CHAR8
19 11 GENERALLOAD44 4 INT93 INT17 4 4 INT9
33 11 GENERALLOAD4 INT90 48 0 
19 11 GENERALLOAD45 5 INT103 INT17 4 5 INT10
33 11 GENERALLOAD5 INT100 48 0 
19 11 GENERALLOAD46 5 CHAR94 CHAR1 1 5 CHAR9
19 11 GENERALLOAD47 6 CHAR104 CHAR1 1 6 CHAR10
19 11 GENERALLOAD48 6 CHAR114 CHAR1 1 6 CHAR11
19 11 GENERALLOAD49 6 CHAR124 CHAR1 1 6 CHAR12
19 11 GENERALLOAD50 6 CHAR134 CHAR1 1 6 CHAR13
19 11 GENERALLOAD51 6 CHAR144 CHAR1 1 6 CHAR14
19 11 GENERALLOAD52 6 CHAR154 CHAR1 1 6 CHAR15
19 11 GENERALLOAD53 6 CHAR164 CHAR1 1 6 CHAR16
19 11 GENERALLOAD54 6 CHAR174 CHAR1 1 6 CHAR17
19 11 GENERALLOAD55 6 CHAR184 CHAR1 1 6 CHAR18
19 11 GENERALLOAD56 6 CHAR194 CHAR1 1 6 CHAR19
19 11 GENERALLOAD57 6 CHAR204 CHAR1 1 6 CHAR20
19 11 GENERALLOAD58 5 REAL74 REAL17 8 5 REAL7
33 11 GENERALLOAD5 REAL79 57 0 
19 11 GENERALLOAD59 5 INT113 INT17 8 5 INT11
33 11 GENERALLOAD5 INT110 48 0 
19 11 GENERALLOAD60 5 INT123 INT17 8 5 INT12
33 11 GENERALLOAD5 INT120 48 0 
19 11 GENERALLOAD61 5 INT133 INT17 8 5 INT13
33 11 GENERALLOAD5 INT130 48 0 
19 11 GENERALLOAD62 5 INT143 INT17 8 5 INT14
33 11 GENERALLOAD5 INT140 48 0 
19 11 GENERALLOAD63 5 INT153 INT17 8 5 INT15
33 11 GENERALLOAD5 INT150 48 0 
19 11 GENERALLOAD64 6 TEXT104 CHAR30 30 6 TEXT10
19 11 GENERALLOAD65 6 TEXT114 CHAR20 20 6 TEXT11
19 11 GENERALLOAD66 6 TEXT124 CHAR20 20 6 TEXT12
19 11 GENERALLOAD67 6 TEXT134 CHAR20 20 6 TEXT13
19 11 GENERALLOAD68 6 TEXT144 CHAR24 24 6 TEXT14
19 11 GENERALLOAD69 6 TEXT154 CHAR24 24 6 TEXT15
19 11 GENERALLOAD70 6 TEXT165 RCHAR30 30 6 TEXT16
19 11 GENERALLOAD71 6 TEXT174 CHAR20 20 6 TEXT17
19 11 GENERALLOAD72 5 REAL84 REAL16 8 5 REAL8
33 11 GENERALLOAD5 REAL82 50 0 
19 11 GENERALLOAD73 5 REAL94 REAL16 8 5 REAL9
33 11 GENERALLOAD5 REAL92 50 0 
19 11 GENERALLOAD74 6 REAL104 REAL16 8 6 REAL10
33 11 GENERALLOAD6 REAL102 50 0 
19 11 GENERALLOAD75 6 REAL114 REAL16 8 6 REAL11
33 11 GENERALLOAD6 REAL112 50 0 
19 11 GENERALLOAD76 6 TEXT184 CHAR20 20 6 TEXT18
19 11 GENERALLOAD77 6 CHAR214 CHAR1 1 6 CHAR21
19 11 GENERALLOAD78 6 CHAR224 CHAR1 1 6 CHAR22
19 11 GENERALLOAD79 6 CHAR234 CHAR1 1 6 CHAR23
19 11 GENERALLOAD80 6 CHAR244 CHAR1 1 6 CHAR24
19 11 GENERALLOAD81 6 CHAR254 CHAR1 1 6 CHAR25
19 11 GENERALLOAD82 10 YRES_DATE54 DATE8 8 5 DATE5
19 11 GENERALLOAD83 10 YRES_DATE64 DATE8 8 5 DATE6
19 11 GENERALLOAD84 10 YRES_DATE74 DATE8 8 5 DATE7
19 11 GENERALLOAD85 10 YRES_INT163 INT17 8 5 INT16
33 11 GENERALLOAD10 YRES_INT160 48 0 
19 11 GENERALLOAD86 10 YRES_INT173 INT17 8 5 INT17
33 11 GENERALLOAD10 YRES_INT170 48 0 
19 11 GENERALLOAD87 10 YRES_INT183 INT18 8 5 INT18
33 11 GENERALLOAD10 YRES_INT180 48 0 
19 11 GENERALLOAD88 12 YRES_TEXT1004 CHAR120 120 12 YRES_TEXT100
19 11 GENERALLOAD89 12 YRES_TEXT1014 CHAR120 120 12 YRES_TEXT101
19 11 GENERALLOAD90 12 YRES_TEXT1024 CHAR120 120 12 YRES_TEXT102
19 11 GENERALLOAD91 12 YRES_TEXT1034 CHAR120 120 12 YRES_TEXT103
19 11 GENERALLOAD92 11 YRES_REAL124 REAL16 8 6 REAL12
33 11 GENERALLOAD11 YRES_REAL122 50 0 
19 11 GENERALLOAD93 11 YRES_REAL144 REAL16 8 6 REAL14
33 11 GENERALLOAD11 YRES_REAL144 52 0 
19 11 GENERALLOAD94 11 YRES_REAL154 REAL16 8 6 REAL15
33 11 GENERALLOAD11 YRES_REAL154 52 0 
19 11 GENERALLOAD95 10 YRES_DATE84 DATE8 8 5 DATE8
19 11 GENERALLOAD96 11 YRES_REAL164 REAL16 8 6 REAL16
33 11 GENERALLOAD11 YRES_REAL164 52 0 
19 11 GENERALLOAD97 10 YRES_DATE94 DATE14 8 5 DATE9
19 11 GENERALLOAD98 10 YRES_INT203 INT17 8 5 INT20
33 11 GENERALLOAD10 YRES_INT200 48 0 
19 11 GENERALLOAD99 11 YRES_TEXT104 CHAR20 20 11 YRES_TEXT10
19 11 GENERALLOAD100 10 YRES_INT213 INT17 8 10 YRES_INT21
33 11 GENERALLOAD10 YRES_INT210 48 0 
19 11 GENERALLOAD101 15 FBCV_XMLTAGLOAD4 CHAR110 110 13 הניעטל XML גת
19 11 GENERALLOAD102 14 FBCV_ATTR_LOAD4 CHAR80 80 19 XML Attributes LOAD
19 11 GENERALLOAD103 10 MPIS_QUANT3 INT17 8 4 תומכ
33 11 GENERALLOAD10 MPIS_QUANT3 51 0 
19 11 GENERALLOAD104 11 MPIS_REAL184 REAL18 8 6 REAL18
33 11 GENERALLOAD11 MPIS_REAL182 50 0 
19 11 GENERALLOAD105 13 MPIS_REAL18_24 REAL18 8 8 REAL18_2
33 11 GENERALLOAD13 MPIS_REAL18_22 50 0 
19 11 GENERALLOAD106 10 MPIS_RCHAR5 RCHAR20 20 7 RCHAR20
19 11 GENERALLOAD107 11 MPIS_RCHAR15 RCHAR16 16 7 RCHAR16
19 11 GENERALLOAD108 9 MPIS_TEXT5 RCHAR120 120 12 2 ישפוח טסקט
20 11 GENERALLOAD85 1 
21 11 GENERALLOAD1 4 LINE1 
20 11 GENERALLOAD78 2 
21 11 GENERALLOAD2 4 INT11 
20 11 GENERALLOAD78 3 
21 11 GENERALLOAD3 5 INT101 
20 11 GENERALLOAD78 4 
21 11 GENERALLOAD4 5 INT111 
17 12 FSPS_LOADCSV14 CSVמ המישר ןעט11 GENERALLOAD76 89 0 0 0 3 LOG0 0 
57 10 יטרפ חותיפ1 
58 1 12 FSPS_LOADCSV76 
29 12 FSPS_LOADCSV76 11 GENERALLOAD14 CSVמ המישר ןעט
30 12 FSPS_LOADCSV76 4 user4 CHAR2 2 0 0 
30 12 FSPS_LOADCSV76 11 windowsuser4 CHAR1 1 0 0 
31 12 FSPS_LOADCSV76 18 :LINE = :LINE + 1;1 1 
31 12 FSPS_LOADCSV76 14 :NEW_USER = 0;2 2 
31 12 FSPS_LOADCSV76 24 :NEW_USER = ATOI(:user);3 3 
31 12 FSPS_LOADCSV76 68 /******************************************************************/8 4 
31 12 FSPS_LOADCSV76 34 INSERT INTO GENERALLOAD(LINE,INT1)5 5 
31 12 FSPS_LOADCSV76 23 VALUES(:LINE,:NEW_USER)6 6 
31 12 FSPS_LOADCSV76 1 ;7 7 
EOF
echo End of Upgrade 7.0.441
