Here is a table structure :
Column Type Type
name schema name Length Scale Nulls
EMPNO SYSIBM INTEGER 4 0 Yes
ENAME SYSIBM CHARACTER 20 0 Yes
CNTY_VISITED SYSIBM CHARACTER 100 0 Yes
Now goes the prob.....
I want to insert a row in the table such that the data in the table shud look as :
EMPNO ENAME CNTY_VISITED
1001 JACK 'IND','JPN'
I guess you understood the req. It should not be IND,JPN.. It should be ' IND ' , ' JPN '
in the table.
The basic structure of an insert statement is
- insert into schema.tableName(col1, col2) values (val1, val2)
Edit: and if you want to concatenate two strings s1 and s2, you can use the concat function as explained
here.