insert into tablename a
column1,
column2
select column1,
column2
from tablename b
i am getting abend -104..can any one help?
Answer Posted / munabhai
illegal symbol,then u can find -104 error
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do I add a column to an existing table in db2?
Is db2 a mainframe database?
What is load replace in db2?
What is a storage group (stogroup)?
What is buffer pool and list some of them?
What are the uses of db2 optimizer?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is release/acquire in bind?
What is dbrm in db2 database?
Mention the different locking levels that are available in db2.
How do you pull up a query which was previously saved in qmf?
What is runstats and reorg in db2?
What are the bind parameters ibm db2?
How can the duplicate values be eliminated from db2 select?
What are db2 objects?