inserted values required with the given format

kabir6987

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.

Aug 1 '07 #1

r035198x

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
Edit: and if you want to concatenate two strings s1 and s2, you can use the concat function as explained here.

Aug 1 '07 #2

cburnett

create table EMP_VISITS(EMPNO INT,
ENAME CHAR(20),
CNTY_VISITED CHAR(100));

insert into EMP_VISITS
values (1001, 'JACK', '''IND'',''JPN''');

Not that each single quote within the string needs to be doubled. i.e.two single quote characters.

Aug 1 '07 #3