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
Who uses db2?
How connect db2 database to datastage?
Why do we use cursor?
What does sqlcabc has?
What is the difference between using bind () and rebind () methods of naming class?
What is meant by explain?
Which command is used to connect to a database in DB2 ? Give the Syntax.
what are bind concepts in db2 cobol?
What is cursor with hold option in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is a collection in db2?
Explain dclgen.
what is db2 restart?
What are packages in db2?
List out the three types of page locks that can be held.