by Hello, I am using a stored procedure where I read some varchar fields
from an old table and am trying to put them in one clob delimited by
newline characters. However, I can not find a function or method of
inserting the new line between fields. Essentially I am looking for a
function that works like the CHAR() function on SQL server and other
systems, where I can pass in the value of the ascii code and have that
inserted into my string.
I have looked fairly extensively through my DB2 manuals, google, and
IRC.
my code looks something like this:
Select Field1, field2, field3 from BLAH
INSERT INTO New_table(New_filed)
VALUES ( field1 || char(10) || field2 || char(10) || field3);
RTFM's are more than welcome as long as you tell me which FM to read.
I am using V5R1.
Thank you.