insert into tablename a
column1,
column2
select column1,
column2
from tablename b
i am getting abend -104..can any one help?
Answer Posted / guna
insert into tablename(column1,column2)
select column1,column2 from tablename
Alias names 'a' and 'b' should not be used.In case u want
to use alias names, specify the column names with prefix as
a.column1,b.column2 like that.
Also, brackets must be given in an insert statement.
Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is the role of data manager in the db2 database?
What is a db2 tablespace?
What is the physical storage length of the data types date, time, and timestamp?
What is null indicator in cobol db2?
What is access path in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is db2 purescale?
What is dclgen (declaration generator)?
What is a db2 schema?
What are types of indexes?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is check constraint. Explain with example.
What is host variable?
What does db2 plan contain?
How to connect to db2 database from windows command line?