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


Please Help Members By Posting Answers For Below Questions

What is bufferpool in db2?

577


Explain the function done by data manager?

853


What is load replace in db2?

560


What is the use of with ur in db2?

615


How to find primary key of a table in db2?

610






Before you give the explain statement, what are the prerogatives?

579


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

626


How can deadlocks be resolved?

540


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

1595


What action db2 takes when a program aborts in the middle of a transaction?

657


What is concurrency?

709


What is access path in db2?

562


What is scrollable cursor in db2?

581


How to create db2 table in mainframe?

629


Is db2 a programming language?

604