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
What is bufferpool in db2?
Explain the function done by data manager?
What is load replace in db2?
What is the use of with ur in db2?
How to find primary key of a table in db2?
Before you give the explain statement, what are the prerogatives?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How can deadlocks be resolved?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What action db2 takes when a program aborts in the middle of a transaction?
What is concurrency?
What is access path in db2?
What is scrollable cursor in db2?
How to create db2 table in mainframe?
Is db2 a programming language?