To All,
How do you output a semicolon (;) in DB2 in the following code below (see select statement below)? Thanks.


create table test2 (text1 varchar(10));

insert into test2 values(',,,,,,');
commit;

insert into test2 values('aaaaa');
commit;

insert into test2 values('AAAAA');
commit;

insert into test2 values('AAbb');
commit;

insert into test2 values('bbAA');
commit;

insert into test2 values('12345');
commit;

insert into test2 values('1');
commit;

select 'insert into test2 values (' || '''' || text1 || ''')'
from test2;


Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]

DB2 & UDB email list listserv db2-l LazyDBA home page