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
- 9750 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
Define predicate?
What is an instance in db2?
How to get the ddl of a table in db2?
How can you find out the # of rows updated after an update statement?
What parameters are used to control the free space in DB2?
What is a db2 collection?
What is buffer pool?
What is the role of schema in the db2 database?
What is a cursor in programming?
What is dclgen (declaration generator)?
What is the function of logging in the db2 database?
Mention the downsides of page level lock.
Can we update view in db2?
How can we read records for specific member in CL? AND rpg?
What is buffer pool and list some of them?
