| ij> AUTOCOMMIT OFF; |
| ij> -- MODULE DML178 |
| |
| -- SQL Test Suite, V6.0, Interactive SQL, dml178.sql |
| -- 59-byte ID |
| -- TEd Version # |
| |
| -- AUTHORIZATION FLATER |
| set schema FLATER; |
| 0 rows inserted/updated/deleted |
| ij> --O SELECT USER FROM HU.ECCO; |
| VALUES USER; |
| 1 |
| -------------------------------------------------------------------------------------------------------------------------------- |
| FLATER |
| ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment |
| ROLLBACK WORK; |
| ij> -- date_time print |
| |
| -- TEST:0891 FIPS sizing, 250 columns, 4000 char data statement! |
| |
| CREATE TABLE L1 ( |
| C1 INT, C2 INT, C3 INT, C4 INT, C5 INT, C6 INT, |
| C7 INT, C8 INT, C9 INT, C10 INT, C11 INT, C12 INT, |
| C13 INT, C14 INT, C15 INT, C16 INT, C17 INT, C18 INT, |
| C19 INT, C20 INT, C21 INT, C22 INT, C23 INT, C24 INT, |
| C25 INT, C26 INT, C27 INT, C28 INT, C29 INT, C30 INT, |
| C31 INT, C32 INT, C33 INT, C34 INT, C35 INT, C36 INT, |
| C37 INT, C38 INT, C39 INT, C40 INT, C41 INT, C42 INT, |
| C43 INT, C44 INT, C45 INT, C46 INT, C47 INT, C48 INT, |
| C49 INT, C50 INT, C51 INT, C52 INT, C53 INT, C54 INT, |
| C55 INT, C56 INT, C57 INT, C58 INT, C59 INT, C60 INT, |
| C61 INT, C62 INT, C63 INT, C64 INT, C65 INT, C66 INT, |
| C67 INT, C68 INT, C69 INT, C70 INT, C71 INT, C72 INT, |
| C73 INT, C74 INT, C75 INT, C76 INT, C77 INT, C78 INT, |
| C79 INT, C80 INT, C81 INT, C82 INT, C83 INT, C84 INT, |
| C85 INT, C86 INT, C87 INT, C88 INT, C89 INT, C90 INT, |
| C91 INT, C92 INT, C93 INT, C94 INT, C95 INT, C96 INT, |
| C97 INT, C98 INT, C99 INT, C100 INT, C101 INT, C102 INT, |
| C103 INT, C104 INT, C105 INT, C106 INT, C107 INT, C108 INT, |
| C109 INT, C110 INT, C111 INT, C112 INT, C113 INT, C114 INT, |
| C115 INT, C116 INT, C117 INT, C118 INT, C119 INT, C120 INT, |
| C121 INT, C122 INT, C123 INT, C124 INT, C125 INT, C126 INT, |
| C127 INT, C128 INT, C129 INT, C130 INT, C131 INT, C132 INT, |
| C133 INT, C134 INT, C135 INT, C136 INT, C137 INT, C138 INT, |
| C139 INT, C140 INT, C141 INT, C142 INT, C143 INT, C144 INT, |
| C145 INT, C146 INT, C147 INT, C148 INT, C149 INT, C150 INT, |
| C151 INT, C152 INT, C153 INT, C154 INT, C155 INT, C156 INT, |
| C157 INT, C158 INT, C159 INT, C160 INT, C161 INT, C162 INT, |
| C163 INT, C164 INT, C165 INT, C166 INT, C167 INT, C168 INT, |
| C169 INT, C170 INT, C171 INT, C172 INT, C173 INT, C174 INT, |
| C175 INT, C176 INT, C177 INT, C178 INT, C179 INT, C180 INT, |
| C181 INT, C182 INT, C183 INT, C184 INT, C185 INT, C186 INT, |
| C187 INT, C188 INT, C189 INT, C190 INT, C191 INT, C192 INT, |
| C193 INT, C194 INT, C195 INT, C196 INT, C197 INT, C198 INT, |
| C199 INT, C200 INT, C201 INT, C202 INT, C203 INT, C204 INT, |
| C205 INT, C206 INT, C207 INT, C208 INT, C209 INT, C210 INT, |
| C211 INT, C212 INT, C213 INT, C214 INT, C215 INT, C216 INT, |
| C217 INT, C218 INT, C219 INT, C220 INT, C221 INT, C222 INT, |
| C223 INT, C224 INT, C225 INT, C226 INT, C227 INT, C228 INT, |
| C229 INT, C230 INT, C231 INT, C232 INT, C233 INT, C234 INT, |
| C235 INT, C236 INT, C237 INT, C238 INT, C239 INT, C240 INT, |
| C241 INT, C242 INT, C243 INT, C244 INT, C245 INT, C246 INT, |
| C247 INT, C248 INT, C249 INT, C250 INT); |
| 0 rows inserted/updated/deleted |
| ij> -- PASS:0891 If table created successfully? |
| |
| COMMIT WORK; |
| ij> INSERT INTO L1 VALUES ( |
| 1, 2, 3, 4, 5, 6, |
| 7, 8, 9, 10, 11, 12, |
| 13, 14, 15, 16, 17, 18, |
| 19, 20, 21, 22, 23, 24, |
| 25, 26, 27, 28, 29, 30, |
| 31, 32, 33, 34, 35, 36, |
| 37, 38, 39, 40, 41, 42, |
| 43, 44, 45, 46, 47, 48, |
| 49, 50, 51, 52, 53, 54, |
| 55, 56, 57, 58, 59, 60, |
| 61, 62, 63, 64, 65, 66, |
| 67, 68, 69, 70, 71, 72, |
| 73, 74, 75, 76, 77, 78, |
| 79, 80, 81, 82, 83, 84, |
| 85, 86, 87, 88, 89, 90, |
| 91, 92, 93, 94, 95, 96, |
| 97, 98, 99, 100, 101, 102, |
| 103, 104, 105, 106, 107, 108, |
| 109, 110, 111, 112, 113, 114, |
| 115, 116, 117, 118, 119, 120, |
| 121, 122, 123, 124, 125, 126, |
| 127, 128, 129, 130, 131, 132, |
| 133, 134, 135, 136, 137, 138, |
| 139, 140, 141, 142, 143, 144, |
| 145, 146, 147, 148, 149, 150, |
| 151, 152, 153, 154, 155, 156, |
| 157, 158, 159, 160, 161, 162, |
| 163, 164, 165, 166, 167, 168, |
| 169, 170, 171, 172, 173, 174, |
| 175, 176, 177, 178, 179, 180, |
| 181, 182, 183, 184, 185, 186, |
| 187, 188, 189, 190, 191, 192, |
| 193, 194, 195, 196, 197, 198, |
| 199, 200, 201, 202, 203, 204, |
| 205, 206, 207, 208, 209, 210, |
| 211, 212, 213, 214, 215, 216, |
| 217, 218, 219, 220, 221, 222, |
| 223, 224, 225, 226, 227, 228, |
| 229, 230, 231, 232, 233, 234, |
| 235, 236, 237, 238, 239, 240, |
| 241, 242, 243, 244, 245, 246, |
| 247, 248, 249, 250); |
| 1 row inserted/updated/deleted |
| ij> -- PASS:0891 If 1 row inserted successfully? |
| |
| UPDATE L1 SET |
| C1 = C1 + 1, C2 = C2 + 1, C3 = C3 + 1, |
| C4 = C4 + 1, C5 = C5 + 1, C6 = C6 + 1, |
| C7 = C7 + 1, C8 = C8 + 1, C9 = C9 + 1, |
| C10 = C10 + 1, C11 = C11 + 1, C12 = C12 + 1, |
| C13 = C13 + 1, C14 = C14 + 1, C15 = C15 + 1, |
| C16 = C16 + 1, C17 = C17 + 1, C18 = C18 + 1, |
| C19 = C19 + 1, C20 = C20 + 1, C21 = C21 + 1, |
| C22 = C22 + 1, C23 = C23 + 1, C24 = C24 + 1, |
| C25 = C25 + 1, C26 = C26 + 1, C27 = C27 + 1, |
| C28 = C28 + 1, C29 = C29 + 1, C30 = C30 + 1, |
| C31 = C31 + 1, C32 = C32 + 1, C33 = C33 + 1, |
| C34 = C34 + 1, C35 = C35 + 1, C36 = C36 + 1, |
| C37 = C37 + 1, C38 = C38 + 1, C39 = C39 + 1, |
| C40 = C40 + 1, C41 = C41 + 1, C42 = C42 + 1, |
| C43 = C43 + 1, C44 = C44 + 1, C45 = C45 + 1, |
| C46 = C46 + 1, C47 = C47 + 1, C48 = C48 + 1, |
| C49 = C49 + 1, C50 = C50 + 1, C51 = C51 + 1, |
| C52 = C52 + 1, C53 = C53 + 1, C54 = C54 + 1, |
| C55 = C55 + 1, C56 = C56 + 1, C57 = C57 + 1, |
| C58 = C58 + 1, C59 = C59 + 1, C60 = C60 + 1, |
| C61 = C61 + 1, C62 = C62 + 1, C63 = C63 + 1, |
| C64 = C64 + 1, C65 = C65 + 1, C66 = C66 + 1, |
| C67 = C67 + 1, C68 = C68 + 1, C69 = C69 + 1, |
| C70 = C70 + 1, C71 = C71 + 1, C72 = C72 + 1, |
| C73 = C73 + 1, C74 = C74 + 1, C75 = C75 + 1, |
| C76 = C76 + 1, C77 = C77 + 1, C78 = C78 + 1, |
| C79 = C79 + 1, C80 = C80 + 1, C81 = C81 + 1, |
| C82 = C82 + 1, C83 = C83 + 1, C84 = C84 + 1, |
| C85 = C85 + 1, C86 = C86 + 1, C87 = C87 + 1, |
| C88 = C88 + 1, C89 = C89 + 1, C90 = C90 + 1, |
| C91 = C91 + 1, C92 = C92 + 1, C93 = C93 + 1, |
| C94 = C94 + 1, C95 = C95 + 1, C96 = C96 + 1, |
| C97 = C97 + 1, C98 = C98 + 1, C99 = C99 + 1, |
| C100 = C100 + 1, C101 = C101 + 1, C102 = C102 + 1, |
| C103 = C103 + 1, C104 = C104 + 1, C105 = C105 + 1, |
| C106 = C106 + 1, C107 = C107 + 1, C108 = C108 + 1, |
| C109 = C109 + 1, C110 = C110 + 1, C111 = C111 +1, |
| C112 = C112 +1, C113 = C113 +1, C114 = C114 +1, |
| C115 = C115 +1, C116 = C116 +1, C117 = C117 +1, |
| C118 = C118 +1, C119 = C119 +1, C120 = C120 +1, |
| C121 = C121 +1, C122 = C122 +1, C123 = C123 +1, |
| C124 = C124 +1, C125 = C125 +1, C126 = C126 +1, |
| C127 = C127 +1, C128 = C128 +1, C129 = C129 +1, |
| C130 = C130 +1, C131 = C131 +1, C132 = C132 +1, |
| C133 = C133 +1, C134 = C134 +1, C135 = C135 +1, |
| C136 = C136 +1, C137 = C137 +1, C138 = C138 +1, |
| C139 = C139 +1, C140 = C140 +1, C141 = C141 +1, |
| C142 = C142 +1, C143 = C143 +1, C144 = C144 +1, |
| C145 = C145 +1, C146 = C146 +1, C147 = C147 +1, |
| C148 = C148 +1, C149 = C149 +1, C150 = C150 +1, |
| C151 = C151 +1, C152 = C152 +1, C153 = C153 +1, |
| C154 = C154 +1, C155 = C155 +1, C156 = C156 +1, |
| C157 = C157 +1, C158 = C158 +1, C159 = C159 +1, |
| C160 = C160 +1, C161 = C161 +1, C162 = C162 +1, |
| C163 = C163 +1, C164 = C164 +1, C165 = C165 +1, |
| C166 = C166 +1, C167 = C167 +1, C168 = C168 +1, |
| C169 = C169 +1, C170 = C170 +1, C171 = C171 +1, |
| C172 = C172 +1, C173 = C173 +1, C174 = C174 +1, |
| C175 = C175 +1, C176 = C176 +1, C177 = C177 +1, |
| C178 = C178 +1, C179 = C179 +1, C180 = C180 +1, |
| C181 = C181 +1, C182 = C182 +1, C183 = C183 +1, |
| C184 = C184 +1, C185 = C185 +1, C186 = C186 +1, |
| C187 = C187 +1, C188 = C188 +1, C189 = C189 +1, |
| C190 = C190 +1, C191 = C191 +1, C192 = C192 +1, |
| C193 = C193 +1, C194 = C194 +1, C195 = C195 +1, |
| C196 = C196 +1, C197 = C197 +1, C198 = C198 +1, |
| C199 = C199 +1, C200 = C200 +1, C201 = C201 +1, |
| C202 = C202 +1, C203 = C203 +1, C204 = C204 +1, |
| C205 = C205 +1, C206 = C206 +1, C207 = C207 +1, |
| C208 = C208 +1, C209 = C209 +1, C210 = C210 +1, |
| C211 = C211 +1, C212 = C212 +1, C213 = C213 +1, |
| C214 = C214 +1, C215 = C215 +1, C216 = C216 +1, |
| C217 = C217 +1, C218 = C218 +1, C219 = C219 +1, |
| C220 = C220 +1, C221 = C221 +1, C222 = C222 +1, |
| C223 = C223 +1, C224 = C224 +1, C225 = C225 +1, |
| C226 = C226 +1, C227 = C227 +1, C228 = C228 +1, |
| C229 = C229 +1, C230 = C230 +1, C231 = C231 +1, |
| C232 = C232 +1, C233 = C233 +1, C234 = C234 +1, |
| C235 = C235 +1, C236 = C236 +1, C237 = C237 +1, |
| C238 = C238 +1, C239 = C239 +1, C240 = C240 +1, |
| C241 = C241 +1, C242 = C242 +1, C243 = C243 +1, |
| C244 = C244 +1, C245 = C245 +1, C246 = C246 +1, |
| C247 = C247 +1, C248 = C248 +1, C249 = C249 +1, |
| C250 = C250 +1; |
| 1 row inserted/updated/deleted |
| ij> -- PASS:0891 If update completed successfully? |
| |
| -- modified select to avoid a problem with sed in processing test result |
| SELECT |
| C1, C2, C3, C4, C5, C6, |
| C7, C8, C9, C10, C11, C12, |
| C13, C14, C15, C16, C17, C18, |
| C19, C20, C21, C22, C23, C24, |
| C25, C26, C27, C28, C29, C30, |
| C31, C32, C33, C34, C35, C36, |
| C37, C38, C39, C40, C41, C42, |
| C43, C44, C45, C46, C47, C48, |
| C49, C50, C51, C52, C53, C54, |
| C55, C56, C57, C58, C59, C60, |
| C61, C62, C63, C64, C65, C66, |
| C67, C68, C69, C70, C71, C72, |
| C73, C74, C75, C76, C77, C78, |
| C79, C80, C81, C82, C83, C84, |
| C85, C86, C87, C88, C89, C90, |
| C91, C92, C93, C94, C95, C96, |
| C97, C98, C99, C100, C101, C102, |
| C103, C104, C105, C106, C107, C108, |
| C109, C110, C111, C112, C113, C114, |
| C115, C116, C117, C118, C119, C120, |
| --O C121, C122, C123, C124, C125, C126, |
| C121, C122, C123, C124, C125, C126 |
| from l1; |
| C1 |C2 |C3 |C4 |C5 |C6 |C7 |C8 |C9 |C10 |C11 |C12 |C13 |C14 |C15 |C16 |C17 |C18 |C19 |C20 |C21 |C22 |C23 |C24 |C25 |C26 |C27 |C28 |C29 |C30 |C31 |C32 |C33 |C34 |C35 |C36 |C37 |C38 |C39 |C40 |C41 |C42 |C43 |C44 |C45 |C46 |C47 |C48 |C49 |C50 |C51 |C52 |C53 |C54 |C55 |C56 |C57 |C58 |C59 |C60 |C61 |C62 |C63 |C64 |C65 |C66 |C67 |C68 |C69 |C70 |C71 |C72 |C73 |C74 |C75 |C76 |C77 |C78 |C79 |C80 |C81 |C82 |C83 |C84 |C85 |C86 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12 |13 |14 |15 |16 |17 |18 |19 |20 |21 |22 |23 |24 |25 |26 |27 |28 |29 |30 |31 |32 |33 |34 |35 |36 |37 |38 |39 |40 |41 |42 |43 |44 |45 |46 |47 |48 |49 |50 |51 |52 |53 |54 |55 |56 |57 |58 |59 |60 |61 |62 |63 |64 |65 |66 |67 |68 |69 |70 |71 |72 |73 |74 |75 |76 |77 |78 |79 |80 |81 |82 |83 |84 |85 |86 |87 |88 |89 |90 |91 |92 |93 |94 |95 |96 |97 |98 |99 |100 |101 |102 |103 |104 |105 |106 |107 |108 |109 |110 |111 |112 |113 |114 |115 |116 |117 |118 |119 |120 |121 |122 |123 |124 |125 |126 |127 |
| ij> SELECT |
| C127, C128, C129, C130, C131, C132, |
| C133, C134, C135, C136, C137, C138, |
| C139, C140, C141, C142, C143, C144, |
| C145, C146, C147, C148, C149, C150, |
| C151, C152, C153, C154, C155, C156, |
| C157, C158, C159, C160, C161, C162, |
| C163, C164, C165, C166, C167, C168, |
| C169, C170, C171, C172, C173, C174, |
| C175, C176, C177, C178, C179, C180, |
| C181, C182, C183, C184, C185, C186, |
| C187, C188, C189, C190, C191, C192, |
| C193, C194, C195, C196, C197, C198, |
| C199, C200, C201, C202, C203, C204, |
| C205, C206, C207, C208, C209, C210, |
| C211, C212, C213, C214, C215, C216, |
| C217, C218, C219, C220, C221, C222, |
| C223, C224, C225, C226, C227, C228, |
| C229, C230, C231, C232, C233, C234, |
| C235, C236, C237, C238, C239, C240, |
| C241, C242, C243, C244, C245, C246, |
| C247, C248, C249, C250 |
| FROM L1; |
| C127 |C128 |C129 |C130 |C131 |C132 |C133 |C134 |C135 |C136 |C137 |C138 |C139 |C140 |C141 |C142 |C143 |C144 |C145 |C146 |C147 |C148 |C149 |C150 |C151 |C152 |C153 |C154 |C155 |C156 |C157 |C158 |C159 |C160 |C161 |C162 |C163 |C164 |C165 |C166 |C167 |C168 |C169 |C170 |C171 |C172 |C173 |C174 |C175 |C176 |C177 |C178 |C179 |C180 |C181 |C182 |C183 |C184 |C185 |C186 |C187 |C188 |C189 |C190 |C191 |C192 |C193 |C194 |C195 |C196 |C197 |C198 |C199 |C200 |C201 |C202 |C203 |C204 |C205 |C206 |C207 |C208 |C209 |C210 |C211 |C212 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 128 |129 |130 |131 |132 |133 |134 |135 |136 |137 |138 |139 |140 |141 |142 |143 |144 |145 |146 |147 |148 |149 |150 |151 |152 |153 |154 |155 |156 |157 |158 |159 |160 |161 |162 |163 |164 |165 |166 |167 |168 |169 |170 |171 |172 |173 |174 |175 |176 |177 |178 |179 |180 |181 |182 |183 |184 |185 |186 |187 |188 |189 |190 |191 |192 |193 |194 |195 |196 |197 |198 |199 |200 |201 |202 |203 |204 |205 |206 |207 |208 |209 |210 |211 |212 |213 |214 |215 |216 |217 |218 |219 |220 |221 |222 |223 |224 |225 |226 |227 |228 |229 |230 |231 |232 |233 |234 |235 |236 |237 |238 |239 |240 |241 |242 |243 |244 |245 |246 |247 |248 |249 |250 |251 |
| ij> -- PASS:0891 If 250 values are returned with values from 2 thru 251? |
| |
| COMMIT WORK; |
| ij> --O DROP TABLE L1 CASCADE; |
| DROP TABLE L1 ; |
| 0 rows inserted/updated/deleted |
| ij> -- PASS:0891 If table dropped successfully? |
| |
| COMMIT WORK; |
| ij> -- END TEST >>> 0891 <<< END TEST |
| -- ********************************************* |
| -- *************************************************////END-OF-MODULE |
| ; |
| ij> |