on UDB v8/AIX:
I can create an sql insert sql statement with qualified column names i.e.
(<view/schema>.<tablename>.<column name>):
insert into wmdb.wmdatpdt ( wmdb.wmdatpdt.PERIOD, wmdb.wmdatpdt.FROM_DATE, wmdb.wmdatpdt.TO_DATE )
values ( '000099', '1982-12-28', '1982-01-24' )

and it works, no problem.........

If I then issue the same sql statement (same table name) on OS/390 I get an error:

DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "." was found following "". Expected tokens may include: ") , ". SQLSTATE=42601


Can I use qualified names on OS/390 for insert and update sql statments ?

Please see the zOS documentation for DB2:

http://publib.boulder.ibm.com/infoce...jnrmstr438.htm

It says for the column name:
"that is, the table
name must be the table or view name specified after the INTO keyword, and
if a qualifier is specified for the table name, it must match the default qualifier."

You can't give an qualifier here.
Default qualifier is your sqlid.
otherwise you have to set it:
set current sqlid <your_qualifier>.

Well, you don't need for an insert anyway. In a select-statement use an alias for the table instead.

Juliane

I presume if you say
insert into schema.tname tname (tname.col1....
giving the table a symbolic name should be possible

thanks for replying, I tried that as well, same error, I looked in the db2 cross platform development guide and it says that the insert should work....but I cannot get it to work...I wonder if there is some setting in zOS that allows it to work ...

Try The fully qualified table name "wmdb.wmdatpdt" unambigually defines the table, it's redundant to retell the table name of each column. Just pass the column name. That should work.