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
- 9712 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 the reason behind not using select * in embedded sql programs?
Can we update view in db2?
List out the three types of page locks that can be held.
What is database manager in db2?
What is the physical storage length of date data type?
What are the 2 sqlcodes that are returned?
Where do you specify them?
What is concurrency?
How to run db2 command in windows?
How to find schema of a table in db2?
What are db2 objects?
Can there be more than one cursor open for any program?
Why select is not preferred in embedded sql programs?
Explain in detail about buffer manager and its functionalities?
What is clone table?
