| >>--------------------------------------------------------------------- |
| >>-- Component: NonStop SQL Regression Test Suite |
| >>-- Description: SELECT * against populated database to check that |
| >>-- correct values were stored. The contents of the |
| >>-- tables are those needed for SELECT tests. |
| >>--------------------------------------------------------------------- |
| >> |
| >>--------------------------------------------------------------------- |
| >> SELECT * FROM btempkey ; |
| |
| *** ERROR[4211] DML operations are not allowed on a non-audited table. Table: TRAFODION.SCH.BTEMPKEY. |
| |
| *** ERROR[8822] The statement was not prepared. |
| |
| >> SELECT * FROM btemprel ; |
| |
| *** ERROR[4211] DML operations are not allowed on a non-audited table. Table: TRAFODION.SCH.BTEMPREL. |
| |
| *** ERROR[8822] The statement was not prepared. |
| |
| >> SELECT * FROM btempent ; |
| |
| --- 0 row(s) selected. |
| >> SELECT * FROM btsel01 ; |
| |
| CHAR_1 CHAR_10 PIC_X_1 PIC_X_7 PIC_X_LONG VAR_CHAR BINARY_SIGNED BINARY_32_U BINARY_64_S PIC_COMP_1 PIC_COMP_2 PIC_COMP_3 SMALL_INT MEDIUM_INT LARGE_INT DECIMAL_1 DECIMAL_2_SIGNED DECIMAL_3_UNSIGNED PIC_DECIMAL_1 PIC_DECIMAL_2 PIC_DECIMAL_3 |
| ------ ---------- ------- ------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------- ----------- --------------------- -------------------- ---------- ------------ --------- ---------- -------------------- --------- ---------------- ------------------ ------------- ------------- ------------- |
| |
| D michelle D michael rat thomas -5000 90.00 2000.000 500 .40 100.80000 90 8000 200 7 .93 140 6.1 .600 6 |
| A steven C walter bob B 50 50.00 200.000 50 .12 100.90000 10 10000 1000000000 4 .50 90 1.1 .100 1 |
| A bobby A bobby bop B 60 60.00 1200.000 60 .79 100.99000 1000 8000 -1000 5 .60 100 2.1 .200 2 |
| D melissa C 7 pop jimmy 1000 80.00 1500.000 500 .20 100.99990 80 9000 999 5 .80 120 4.1 .400 4 |
| E monica Q sue pat christopher 2000 90.00 1200.000 3000 .30 100.99999 2000 8000 -1000000 1 .90 80 5.1 .500 5 |
| C maureen E jimmy rum marilyn 3000 80.00 2000.000 500 .50 100.70000 9000 1000 2000 8 .97 150 7.1 .700 7 |
| C marcia Z johnny dum thomas 4000 40.00 2000.000 50 .60 100.60000 8000 5000 0 9 .99 110 8.1 .800 8 |
| D steven B 9 bat thomas 8000 70.00 2000.000 500 .10 100.99900 90 10000 1000 7 .70 110 3.1 .300 3 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel02 ; |
| |
| PIC_X_1 |
| ------- |
| |
| B |
| C |
| B |
| Q |
| B |
| C |
| Q |
| Q |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel03 ; |
| |
| PIC_X_7 BINARY_32_U PIC_X4_A PIC_9_7 BINARY_64_S |
| ------- ----------- -------- ------- --------------------- |
| |
| A 5.00 make 90 200.00 |
| 7 6.00 joe 80 1200.00 |
| 8 6.00 joe 80 1200.00 |
| 5 1000.00 5 100 1000.00 |
| michael 50.00 dave 50 1500.00 |
| 7 6.00 john 80 2000.00 |
| B 6.00 mark 80 3000.00 |
| michael 70.00 joan 50 4000.00 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel04 ; |
| |
| VAR_CHAR MEDIUM_INT PIC_X_7 PIC_COMP_1 |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ------- -------------------- |
| |
| tom 1000 7 200 |
| bob 999 A 300 |
| sue 200 sue 100 |
| bobby 200 sue 100 |
| bill 2000 B 500 |
| christopher 1000 white 1000 |
| william 1000 black 2000 |
| marilyn 2000 green 3000 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel05 ; |
| |
| PIC_X_A PIC_X_B PIC_X_C COL_1 COL_2 COL_3 COL_4 COL_5 COL_6 COL_7 COL_8 COL_9 COL_10 |
| ------- ------- ------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ------ |
| |
| joe A al pablo david amy amy steve steve walt mojo joe percy |
| sue A in peggy diane zora cathy mary mary rhoda debra sue madge |
| deb D jo lowry mary sunny debra junk junk junk junk junk junk |
| can D by lowry steve slope debby junk junk junk junk junk junk |
| box C to howie debra snow debbi junk junk junk junk junk junk |
| red B go lowry sue ski cammy junk junk junk junk junk junk |
| why B so lowry amy squaw tammy junk junk junk junk junk junk |
| not B on lowry mary mogul pammy junk junk junk junk junk junk |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel06 ; |
| |
| PIC_X_A PIC_X_B PIC_X_C COL_1 COL_2 COL_3 COL_4 COL_5 COL_6 COL_7 COL_8 COL_9 COL_10 COL_21 COL_22 COL_23 COL_24 COL_25 COL_26 COL_27 COL_28 COL_29 COL_30 COL_41 COL_42 COL_43 COL_44 COL_45 COL_46 COL_47 COL_48 COL_61 COL_62 COL_63 COL_64 COL_65 COL_66 COL_67 COL_68 COL_69 COL_70 |
| ------- ------- ------- ----- ----- ----- ----- ----- ----- ----- ----- ----- ------ ----------- ----------- ----------- ----------- ----------- ----------- ---------- ---------- ---------- ---------- ----------- ----------- ----------- ----------- ---------- ---------- ---------- ---------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- ------------------- ------------------- ------------------- ------------------- |
| |
| joe A jo 100 1000 200 1000 1000 50 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 |
| joe B to 300 1000 400 1000 1000 50 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 |
| joe C go 100 1000 200 1000 1000 50 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 |
| joe Z in 100 200 100 200 200 100 100 100 50 100 100 200 100 200 200 100 100 100 50 100 100.00 200.00 100.00 200.00 200.00 100.00 100.00 100.00 100 200 100 200 200 100 100 100 50 100 |
| pam D al 900 1000 900 1000 1000 50 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 |
| sue C by 300 1000 500 1000 1000 50 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 |
| sue D so 200 1000 300 1000 1000 50 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000.00 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 |
| sue Q on 200 400 100 100 400 100 100 50 100 200 200 400 100 100 400 100 100 50 100 200 200.00 400.00 100.00 100.00 400.00 100.00 100.00 50.00 200 400 100 100 400 100 100 50 100 200 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel07 ; |
| |
| PIC_X_A PIC_X_B PIC_X_C |
| ------- ------- ------- |
| |
| P P P |
| al F al |
| al F al |
| al Q al |
| al E bo |
| al F di |
| B A ed |
| jo C ek |
| JO D em |
| jo Z jo |
| |
| --- 10 row(s) selected. |
| >> SELECT * FROM btsel08 ; |
| |
| LARGE_INT PIC_252 PIC_1 |
| -------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ----- |
| |
| 4000 valley D |
| 3000 george D |
| 2000 alexander B |
| 1000 harveys B |
| 400 joseph X |
| 300 Q X |
| 200 squaw X |
| 100 carltons E |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel09 ; |
| |
| PIC_X_A PIC_X_2 PIC_X_3 PIC_X_4 PIC_X_5 PIC_X_6 PIC_X_7 |
| ------- ------- ------- ------- ------- ------- ------- |
| |
| why gone R billy 7 15 30 |
| sue mary Z MARY 3 10 20 |
| red long S tommy 5 15 70 |
| not time P diane 7 20 40 |
| joe over W maria 7 90 100 |
| deb bill Y BILL 4 10 30 |
| can come X TED 7 77 77 |
| box here R debby 5 11 50 |
| _t% junk j _% 0 0 0 |
| \ts t_go j to%go 0 0 0 |
| \t_ junk j \% 0 0 0 |
| %t_ junk j %_ 0 0 0 |
| |
| --- 12 row(s) selected. |
| >> SELECT * FROM btsel10 ; |
| |
| PIC_X_A PIC_X_7 PIC_9_7 CHAR_10 DECIMAL_10 BINARY_UNSIGNED BINARY_32_SIGNED |
| ------- ------- ------- ---------- ----------- --------------- ---------------- |
| |
| sue sue 1 ebedafiih 110 80 100 |
| bob bobby 2 ebediih 90 100 -1000 |
| rob bobby 2 ebediih 90 100 -1000 |
| tom tom 3 abadefih 100 100 -100 |
| don who 50 outside 10000 100 -100 |
| rod for 400 inside 25 60 0 |
| jon does 1000 offsides 50000 500 100 |
| ron they 2000 onsides 10000 100 -100 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel11 ; |
| |
| PIC_X_A PIC_X_7 PIC_9_7 CHAR_10 DECIMAL_10 BINARY_UNSIGNED BINARY_32_SIGNED |
| ------- ------- ------- ---------- ----------- --------------- ---------------- |
| |
| bar where 300 gone 200 9999 -100 |
| boe tommy 200 ebedafiih 200 50 50 |
| bob bob 100 abadefih 160 200 200 |
| car who 400 done 160 500 500 |
| jar how 600 inside 160 500 500 |
| dan sue 100 ebediih 100 100 60 |
| tar what 500 none 100 8888 0 |
| mar why 50 house 50 7777 0 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel12 ; |
| |
| DATA_X3 DATA_93 |
| ------- ------- |
| |
| bob 200 |
| fun 500 |
| gun 600 |
| nun 700 |
| pun 800 |
| run 300 |
| sun 400 |
| tom 100 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel13 ; |
| |
| DATA_93 |
| ------- |
| |
| 100 |
| 200 |
| 250 |
| 350 |
| 450 |
| 550 |
| 650 |
| 750 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel14 ; |
| |
| DATA_93 |
| ------- |
| |
| 100 |
| 125 |
| 150 |
| 175 |
| 200 |
| 225 |
| 275 |
| 325 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel15 ; |
| |
| SMALL_INT DATA_93 |
| --------- ------- |
| |
| 6666 40 |
| 5555 50 |
| 4444 60 |
| 3333 70 |
| 2222 80 |
| 1111 90 |
| 1000 100 |
| 2000 200 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel16 ; |
| |
| SMALL_INT DATA_93 |
| --------- ------- |
| |
| 1000 167 |
| 2000 168 |
| 8500 169 |
| 8501 170 |
| 8502 171 |
| 8503 172 |
| 8504 173 |
| 8505 174 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel17 ; |
| |
| SMALL_INT DATA_93 |
| --------- ------- |
| |
| 1000 248 |
| 2000 249 |
| 7500 250 |
| 7501 251 |
| 7502 252 |
| 7503 253 |
| 7504 254 |
| 7505 255 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel18 ; |
| |
| BINARY_SIGNED SMALL_INT DATA_93 |
| ------------- --------- ------- |
| |
| -5000 1000 401 |
| 8000 2000 402 |
| 2001 6001 403 |
| 2002 6002 404 |
| 2003 6003 405 |
| 2004 6004 406 |
| 2005 6005 407 |
| 2006 6006 408 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel19 ; |
| |
| BINARY_SIGNED DATA_93 |
| ------------- ------- |
| |
| -5000 409 |
| 2007 411 |
| 2008 412 |
| 2009 413 |
| 2010 414 |
| 2011 415 |
| 2012 416 |
| 8000 410 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel20 ; |
| |
| BINARY_SIGNED DATA_93 |
| ------------- ------- |
| |
| -5000 417 |
| 2013 419 |
| 2014 420 |
| 2015 421 |
| 2016 422 |
| 2017 423 |
| 2018 424 |
| 8000 418 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel21 ; |
| |
| PIC_COMP_2 BINARY_SIGNED DATA_93 |
| ---------- ------------- ------- |
| |
| -.25 8000 426 |
| .01 5000 427 |
| .02 5001 428 |
| .03 5002 429 |
| .04 5003 430 |
| .05 5004 431 |
| .06 5005 432 |
| .12 -5000 425 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel22 ; |
| |
| PIC_COMP_2 DATA_93 |
| ---------- ------- |
| |
| -.25 434 |
| .07 435 |
| .08 436 |
| .09 437 |
| .10 438 |
| .11 439 |
| .12 433 |
| .92 440 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel23 ; |
| |
| PIC_COMP_2 DATA_93 |
| ---------- ------- |
| |
| -.25 442 |
| .12 441 |
| .13 443 |
| .14 444 |
| .15 445 |
| .16 446 |
| .17 447 |
| .18 448 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel24 ; |
| |
| PIC_COMP_2 DATA_X3 |
| ---------- ------- |
| |
| .19 bob |
| .20 toe |
| .21 woe |
| .22 pin |
| .23 sin |
| .24 win |
| .25 kin |
| .79 tom |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM btsel25 ; |
| |
| PIC_X_1 PIC_X_3 |
| ------- ------- |
| |
| B joe |
| C why |
| D not |
| E al |
| Q al |
| B bar |
| C car |
| D |
| E joe |
| Q sue |
| sue |
| |
| --- 11 row(s) selected. |
| >> SELECT * FROM btsel26 ; |
| |
| SELECTOR LARGE_BIN_1 LARGE_BIN_2 LARGE_DEC_1 LARGE_DEC_2 SMALL_BIN_1 SMALL_BIN_2 SMALL_DEC_1 SMALL_DEC_2 SEMI_LARGE_BIN_1 SEMI_LARGE_BIN_2 EIGHT_ONE_BIN ONE_NINE_BIN NINE_ONE_BIN ONE_EIGHT_BIN NINE_ZERO_BIN_U ZERO_NINE_BIN_U NINE_ZERO_DEC_U ZERO_NINE_DEC_U ZERO_ONE_BIN |
| -------- -------------------- -------------------- ------------------- ------------------- --------------------- --------------------- -------------------- -------------------- -------------------- -------------------- ------------- --------------------- --------------------- ------------- --------------- --------------- --------------- --------------- ------------ |
| |
| A 2 2 2 2 .900000000000000000 .200000000000000000 .900000000000000000 .200000000000000000 99999999999999999 99999999999999999 99999999.9 1.100000000 999999999.1 9.99999999 2 .200000000 2 .200000000 .0 |
| B 999999999999999999 1 999999999999999999 1 .999999999999999999 .000000000000000001 .999999999999999999 .000000000000010000 -99999999999999999 99999999999999999 -99999999.9 1.899999999 999999998.1 9.99999999 999999999 .999999999 999999999 .999999999 .0 |
| C -999999999999999999 1 -999999999999999999 1 .999999999999999999 .000000000000000002 .999999999999999999 .000000000000020000 0 99999999 99999999.9 9.999999999 -999999999.9 9.99999999 0 .000000000 0 .000000000 .9 |
| D 100000000000000000 899999999999999999 100000000000000000 899999999999999999 .999999999999999999 .100000000000000000 .999999999999999999 .000000000000000002 0 100 9999999.9 4.400000000 .0 8.00000000 0 .000000000 0 .000000000 .1 |
| E 999999999999999999 3 999999999999999999 100000000000000000 .000000000000000001 .900000000000000000 .999999999999999999 .000000000000000000 10 99999999999999999 .0 3.000000000 .0 .00000000 0 .000000000 0 .000000000 .0 |
| F 999999999999999999 2 999999999999999999 -999999999999999999 .100000000000000000 .000000000000000000 .999999999999999999 .000000000000000000 99999999999999999 0 .0 2.500000000 .0 .00000000 0 .000000000 0 .000000000 .0 |
| G 92233720368547758 999999999999999999 999999999999999999 0 .080000000000000000 .090000000000000000 .999999999999999999 .000000000000000000 0 0 .0 .000000000 .0 .00000000 0 .000000000 0 .000000000 .0 |
| H 999999999999999999 999999999999999999 999999999999999999 0 .000000000000000000 .000000000000000000 .999999999999999999 .000000000000000000 0 0 .0 .000000000 .0 .00000000 0 .000000000 0 .000000000 .0 |
| I 999999999999999999 0 999999999999999999 0 .000000000000000000 .000000000000000000 .999999999999999999 .000000000000000000 0 0 .0 .000000000 .0 .00000000 0 .000000000 0 .000000000 .0 |
| J 999999999999999999 0 999999999999999999 0 .000000000000000000 .000000000000000000 .999999999999999999 .000000000000000000 0 0 .0 .000000000 .0 .00000000 0 .000000000 0 .000000000 .0 |
| K 999999999999999999 0 999999999999999999 0 .000000000000000000 .000000000000000000 .000000000000000000 .000000000000000000 0 0 .0 .000000000 .0 .00000000 0 .000000000 0 .000000000 .0 |
| L 999999999999999999 0 999999999999999999 0 .000000000000000000 .000000000000000000 .000000000000000000 .000000000000000000 0 0 .0 .000000000 .0 .00000000 0 .000000000 0 .000000000 .0 |
| M 999999999999999999 0 999999999999999999 0 .000000000000000000 .000000000000000000 .000000000000000000 .000000000000000000 0 0 .0 .000000000 .0 .00000000 0 .000000000 0 .000000000 .0 |
| N 999999999999999999 0 0 0 .000000000000000000 .000000000000000000 .000000000000000000 .000000000000000000 0 0 .0 .000000000 .0 .00000000 0 .000000000 0 .000000000 .0 |
| O -999999999999999999 0 0 0 .000000000000000000 .000000000000000000 .000000000000000000 .000000000000000000 0 0 .0 .000000000 .0 .00000000 0 .000000000 0 .000000000 .0 |
| P -999999999999999999 0 0 0 .000000000000000000 .000000000000000000 .000000000000000000 .000000000000000000 0 0 .0 .000000000 .0 .00000000 0 .000000000 0 .000000000 .0 |
| |
| --- 16 row(s) selected. |
| >> SELECT * FROM btsel27 ; |
| |
| SELECTOR TWO_FOUR_BIN ONE_ONE_BIN |
| -------- ------------ ----------- |
| |
| A 1.1001 1.1 |
| B 1.0016 .1 |
| C .0001 9.9 |
| |
| --- 3 row(s) selected. |
| >>--------------------------------------------------------------------- |
| >>-- SELECT data base - checking the PROTECTION VIEWs. |
| >>--------------------------------------------------------------------- |
| >> SELECT * FROM pvsel01 ; |
| |
| BINARY_SIGNED LARGE_INT MEDIUM_INT PIC_DECIMAL_3 PIC_X_1 PIC_X_7 SMALL_INT |
| ------------- -------------------- ---------- ------------- ------- ------- --------- |
| |
| -5000 200 8000 6 D michael 90 |
| 50 1000000000 10000 1 C walter 10 |
| 60 -1000 8000 2 A bobby 1000 |
| 1000 999 9000 4 C 7 80 |
| 2000 -1000000 8000 5 Q sue 2000 |
| 3000 2000 1000 7 E jimmy 9000 |
| 4000 0 5000 8 Z johnny 8000 |
| 8000 1000 10000 3 B 9 90 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM pvsel02 ; |
| |
| PIC_X_1 |
| ------- |
| |
| B |
| C |
| B |
| Q |
| B |
| C |
| Q |
| Q |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM pvsel03 ; |
| |
| NEW_NAME_1 NEW_NAME_2 NEW_NAME_3 NEW_NAME_4 |
| ---------- ----------- ---------- -------------------- |
| |
| 90 5.00 A 3348008712604909660 |
| 80 6.00 7 3348008712604933890 |
| 80 6.00 7 3348008712604972182 |
| 80 6.00 B 3348008712604978694 |
| |
| --- 4 row(s) selected. |
| >> SELECT * FROM pvsel04 ; |
| |
| VAR_CHAR MEDIUM_INT PIC_X_7 PIC_COMP_1 |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ------- -------------------- |
| |
| tom 1000 7 200 |
| bob 999 A 300 |
| bill 2000 B 500 |
| christopher 1000 white 1000 |
| william 1000 black 2000 |
| marilyn 2000 green 3000 |
| |
| --- 6 row(s) selected. |
| >> |
| >>--------------------------------------------------------------------- |
| >>-- SELECT data base - checking the SHORTHAND VIEWs. |
| >>--------------------------------------------------------------------- |
| >> SELECT * FROM svsel01 read committed access ; |
| |
| PIC_X_A PIC_X_7 PIC_9_7 CHAR_10 DECIMAL_10 BINARY_UNSIGNED BINARY_32_SIGNED |
| ------- ------- ------- ---------- ----------- --------------- ---------------- |
| |
| sue sue 1 ebedafiih 110 80 100 |
| bob bobby 2 ebediih 90 100 -1000 |
| rob bobby 2 ebediih 90 100 -1000 |
| tom tom 3 abadefih 100 100 -100 |
| don who 50 outside 10000 100 -100 |
| rod for 400 inside 25 60 0 |
| jon does 1000 offsides 50000 500 100 |
| ron they 2000 onsides 10000 100 -100 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM svsel02 read committed access ; |
| |
| BINARY_UNSIGNED PIC_X_A PIC_X_7 DECIMAL_10 |
| --------------- ------- ------- ----------- |
| |
| 80 sue sue 110 |
| 100 bob bobby 90 |
| 100 rob bobby 90 |
| 100 tom tom 100 |
| 100 don who 10000 |
| 60 rod for 25 |
| 500 jon does 50000 |
| 100 ron they 10000 |
| |
| --- 8 row(s) selected. |
| >> SELECT * FROM svsel03 read committed access ; |
| |
| PIC_X_A PIC_X_7 PIC_9_7 CHAR_10 DECIMAL_10 BINARY_UNSIGNED BINARY_32_SIGNED |
| ------- ------- ------- ---------- ----------- --------------- ---------------- |
| |
| sue sue 1 ebedafiih 110 80 100 |
| don who 50 outside 10000 100 -100 |
| jon does 1000 offsides 50000 500 100 |
| ron they 2000 onsides 10000 100 -100 |
| |
| --- 4 row(s) selected. |
| >> SELECT * FROM svsel04 read committed access ; |
| |
| NEW_NAME_1 NEW_NAME_2 NEW_NAME_3 |
| ---------- ---------- ---------- |
| |
| sue sue ebedafiih |
| bob bobby ebediih |
| rob bobby ebediih |
| jon does offsides |
| |
| --- 4 row(s) selected. |
| >> SELECT new_name_ks_s, new_name_ks_x, new_name_es_x FROM svsel05 read committed access ; |
| |
| NEW_NAME_KS_S NEW_NAME_KS_X NEW_NAME_ES_X |
| -------------------- ------------- ------------- |
| |
| 3348008712608804334 A B |
| 3348008712608804334 A C |
| 3348008712608804334 A D |
| 3348008712608804334 A E |
| 3348008712608804334 A Q |
| 3348008712608804334 A B |
| 3348008712608804334 A C |
| 3348008712608804334 A D |
| 3348008712608804334 A E |
| 3348008712608804334 A Q |
| 3348008712608804334 A |
| 3348008712608903859 D B |
| 3348008712608903859 D C |
| 3348008712608903859 D D |
| 3348008712608903859 D E |
| 3348008712608903859 D Q |
| 3348008712608903859 D B |
| 3348008712608903859 D C |
| 3348008712608903859 D D |
| 3348008712608903859 D E |
| 3348008712608903859 D Q |
| 3348008712608903859 D |
| 3348008712608942394 B B |
| 3348008712608942394 B C |
| 3348008712608942394 B D |
| 3348008712608942394 B E |
| 3348008712608942394 B Q |
| 3348008712608942394 B B |
| 3348008712608942394 B C |
| 3348008712608942394 B D |
| 3348008712608942394 B E |
| 3348008712608942394 B Q |
| 3348008712608942394 B |
| 3348008712608849564 A B |
| 3348008712608849564 A C |
| 3348008712608849564 A D |
| 3348008712608849564 A E |
| 3348008712608849564 A Q |
| 3348008712608849564 A B |
| 3348008712608849564 A C |
| 3348008712608849564 A D |
| 3348008712608849564 A E |
| 3348008712608849564 A Q |
| 3348008712608849564 A |
| 3348008712608876862 D B |
| 3348008712608876862 D C |
| 3348008712608876862 D D |
| 3348008712608876862 D E |
| 3348008712608876862 D Q |
| 3348008712608876862 D B |
| 3348008712608876862 D C |
| 3348008712608876862 D D |
| 3348008712608876862 D E |
| 3348008712608876862 D Q |
| 3348008712608876862 D |
| 3348008712608988150 B B |
| 3348008712608988150 B C |
| 3348008712608988150 B D |
| 3348008712608988150 B E |
| 3348008712608988150 B Q |
| 3348008712608988150 B B |
| 3348008712608988150 B C |
| 3348008712608988150 B D |
| 3348008712608988150 B E |
| 3348008712608988150 B Q |
| 3348008712608988150 B |
| 3348008712608964264 B B |
| 3348008712608964264 B C |
| 3348008712608964264 B D |
| 3348008712608964264 B E |
| 3348008712608964264 B Q |
| 3348008712608964264 B B |
| 3348008712608964264 B C |
| 3348008712608964264 B D |
| 3348008712608964264 B E |
| 3348008712608964264 B Q |
| 3348008712608964264 B |
| 3348008712608922768 C B |
| 3348008712608922768 C C |
| 3348008712608922768 C D |
| 3348008712608922768 C E |
| 3348008712608922768 C Q |
| 3348008712608922768 C B |
| 3348008712608922768 C C |
| 3348008712608922768 C D |
| 3348008712608922768 C E |
| 3348008712608922768 C Q |
| 3348008712608922768 C |
| |
| --- 88 row(s) selected. |
| >> SELECT * FROM svsel06 read committed access ; |
| |
| NEW_NAME_KS_X NEW_NAME_ES_X |
| ------------- ------------- |
| |
| A B |
| A C |
| A D |
| A E |
| A Q |
| A B |
| A C |
| A D |
| A E |
| A Q |
| A |
| D B |
| D C |
| D D |
| D E |
| D Q |
| D B |
| D C |
| D D |
| D E |
| D Q |
| D |
| B B |
| B C |
| B D |
| B E |
| B Q |
| B B |
| B C |
| B D |
| B E |
| B Q |
| B |
| A B |
| A C |
| A D |
| A E |
| A Q |
| A B |
| A C |
| A D |
| A E |
| A Q |
| A |
| D B |
| D C |
| D D |
| D E |
| D Q |
| D B |
| D C |
| D D |
| D E |
| D Q |
| D |
| B B |
| B C |
| B D |
| B E |
| B Q |
| B B |
| B C |
| B D |
| B E |
| B Q |
| B |
| B B |
| B C |
| B D |
| B E |
| B Q |
| B B |
| B C |
| B D |
| B E |
| B Q |
| B |
| C B |
| C C |
| C D |
| C E |
| C Q |
| C B |
| C C |
| C D |
| C E |
| C Q |
| C |
| |
| --- 88 row(s) selected. |
| >> SELECT * FROM svsel07 read committed access ; |
| |
| COUNT_ALL AVG_DISTINCT AVG_ALL MAX_ALL MIN_ALL SUM_ALL |
| -------------------- --------------------- --------------------- --------------------- --------------------- --------------------- |
| |
| 8 226.20 143.62 1100.00 -.90000000 539.00 |
| |
| --- 1 row(s) selected. |
| >> SELECT * FROM svsel08 read committed access ; |
| |
| MAX_DISTINCT |
| ------------ |
| |
| 1000.00 |
| |
| --- 1 row(s) selected. |
| >> SELECT * FROM svsel09 read committed access ; |
| |
| MIN_DISTINCT |
| ------------ |
| |
| 5.00 |
| |
| --- 1 row(s) selected. |
| >> SELECT * FROM svsel10 read committed access ; |
| |
| COUNT_DISTINCT |
| -------------------- |
| |
| 5 |
| |
| --- 1 row(s) selected. |
| >> SELECT * FROM svsel11 read committed access ; |
| |
| COL_1 COL_2 COL_3 COL_4 COL_5 COL_6 COL_7 COL_8 |
| ------ -------------------- ---------- ----- ----- ------- ------ ------- |
| |
| -5000 200 8000 6 D michael 90 7 |
| 50 1000000000 10000 1 C walter 10 A |
| 60 -1000 8000 2 A bobby 1000 7 |
| 60 -1000 8000 2 A bobby 1000 8 |
| 1000 999 9000 4 C 7 80 michael |
| 2000 -1000000 8000 5 Q sue 2000 7 |
| 2000 -1000000 8000 5 Q sue 2000 8 |
| 3000 2000 1000 7 E jimmy 9000 7 |
| 4000 0 5000 8 Z johnny 8000 7 |
| 8000 1000 10000 3 B 9 90 7 |
| |
| --- 10 row(s) selected. |
| >> SELECT * FROM svsel12 read committed access ; |
| |
| COL_1 COL_3 COL_4 COL_5 |
| -------------------- -------------------- ----- ------- |
| |
| 13060 5 Z 7 |
| |
| --- 1 row(s) selected. |
| >> SELECT * FROM svsel13 read committed access ; |
| |
| NEW_NAME_1 NEW_NAME_2 NEW_NAME_3 NEW_NAME_4 VAR_CHAR MEDIUM_INT PIC_X_7 PIC_COMP_1 |
| ---------- ----------- ---------- -------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ------- -------------------- |
| |
| 90 5.00 A 3348008712604909660 bob 999 A 300 |
| 80 6.00 7 3348008712604933890 tom 1000 7 200 |
| 80 6.00 7 3348008712604972182 tom 1000 7 200 |
| 80 6.00 B 3348008712604978694 bill 2000 B 500 |
| |
| --- 4 row(s) selected. |
| >> |
| >> SELECT * FROM svsel14 read committed access ; |
| |
| NEW_NAME_1 NEW_NAME_3 |
| ---------- ---------- |
| |
| 90 A |
| 80 7 |
| 80 B |
| |
| --- 3 row(s) selected. |
| >> SELECT * FROM svsel15 read committed access ; |
| |
| MIXED_1 MIXED_2 MIXED_3 MIXED_4 MIXED_5 MIXED_11 MIXED_12 MIXED_13 MIXED_21 MIXED_22 MIXED_23 |
| ------- ------- ------- ------- ------- -------- -------- -------- -------- -------- -------- |
| |
| joe A al pablo david joe A jo B A ed |
| sue A in peggy diane sue D so JO D em |
| sue A in peggy diane sue Q on al Q al |
| joe A al pablo david joe C go jo C ek |
| sue A in peggy diane sue C by jo C ek |
| joe A al pablo david joe Z in jo Z jo |
| |
| --- 6 row(s) selected. |
| >> |
| >>control query default optimization_level '0'; |
| |
| --- SQL operation complete. |
| >>SELECT * FROM svsel16 read committed access ; |
| |
| DATA_X3 DATA_93 SMALL_INT BINARY_SIGNED PIC_COMP_2 |
| ------- ------- --------- ------------- ---------- |
| |
| tom 100 1000 -5000 .12 |
| bob 200 2000 8000 -.25 |
| |
| --- 2 row(s) selected. |
| >>SELECT * FROM svsel17 read committed access ; |
| |
| A B C |
| --- ----- --- |
| |
| bob -.25 bob |
| tom .12 tom |
| |
| --- 2 row(s) selected. |
| >>control query default optimization_level '3'; |
| |
| --- SQL operation complete. |
| >> |
| >>--------------------------------------------------------------------- |
| >> |
| >> |
| >>LOG; |
