Silly me ... sorry guys, foudn out where am getting it wrong, supposed to be
INSERT INTO TEST.X VALUES ( 'ONE' )

Need more coffee I think ...

Quoting benbart <db2udbdba-ezmlmshield-x55312091.[Email address protected]

> Hi all,
>
> I've managed to do CREATE SCHEMA TEST and CREATE TABLE TEST.X ( X1
> VARCHAR(10)
> and I thought I can do insert into table TEST.X X1 VALUES ( 'ONE') but
> apparently, I can't. Can someone tell me how to insert into a table of a
> schema? Am coming out of a different database flavour so am still getting
> confused in DB2 ...
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html





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