Interested to Buy Any Domain ? << Click Here >> for more details...
insert into tablename a
column1,
column2
select column1,
column2
from tablename b
i am getting abend -104..can any one help?
- 3 Answers
- 9612 Views
- Syntel, I also Faced
- E-Mail Answers
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 cobol db2?
What is bind and rebind in db2?
What is the role of data manager in the db2 database?
Define check constraint.
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is db2 purescale?
Is schema the same as database?
Define declaration generator (dclgen).
How does cobol compile db2 program?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is a buffer in memory?
What is the clustering index in the db2 database?
Are view updateable?
What is the difference between drop table and delete table?
What is package in db2 mainframe?
