--------------------------------------------- Statement # 1 : CREATE TABLE chartest (charval1 CHAR(10) NOT NULL, charval2 CHAR(10) NOT NULL, varcharval VARCHAR(30) NOT NULL) Elapsed Time is: 0.013 seconds --------------------------------------------- Statement # 2 : INSERT INTO chartest VALUES ('aaa','aaa','aaa') Elapsed Time is: 0.004 seconds --------------------------------------------- Statement # 3 : INSERT INTO chartest VALUES ('aaaaaa ','aaa','aaa') Elapsed Time is: 0.004 seconds --------------------------------------------- Statement # 4 : INSERT INTO chartest VALUES ('aaaaaaaaaaaa','aaa','aaa') SQL0433N Value "aaaaaaaaaaaa" is too long. SQLSTATE=22001 Elapsed Time is: 0.006 seconds --------------------------------------------- Statement # 5 : SELECT * FROM chartest CHARVAL1 CHARVAL2 VARCHARVAL -------------------------------------------------------- aaa aaa aaa aaaaaa aaa aaa Number of rows retrieved is: 2 Number of rows sent to output is: 2 Elapsed Time is: 0.004 seconds --------------------------------------------- Statement # 6 : DELETE FROM chartest WHERE charval1='aaaaaa' Elapsed Time is: 0.004 seconds --------------------------------------------- Statement # 7 : SELECT * FROM chartest CHARVAL1 CHARVAL2 VARCHARVAL -------------------------------------------------------- aaa aaa aaa Number of rows retrieved is: 1 Number of rows sent to output is: 1 Elapsed Time is: 0.001 seconds --------------------------------------------- Statement # 8 : SELECT * FROM chartest WHERE charval1=varcharval CHARVAL1 CHARVAL2 VARCHARVAL -------------------------------------------------------- aaa aaa aaa Number of rows retrieved is: 1 Number of rows sent to output is: 1 Elapsed Time is: 0.004 seconds --------------------------------------------- Statement # 9 : SELECT charval1 || 'X' AS res FROM chartest RES ------------- aaa X Number of rows retrieved is: 1 Number of rows sent to output is: 1 Elapsed Time is: 0.004 seconds --------------------------------------------- Statement # 10 : SELECT LENGTH(charval1 || charval2) AS len FROM chartest LEN ------------- 20 Number of rows retrieved is: 1 Number of rows sent to output is: 1 Elapsed Time is: 0.004 seconds --------------------------------------------- Statement # 11 : SELECT LENGTH(charval1) + LENGTH(charval2) AS res FROM chartest RES ------------- 20 Number of rows retrieved is: 1 Number of rows sent to output is: 1 Elapsed Time is: 0.004 seconds