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

How to check last update on table in db2?

628


What does reorg do in db2?

578


Why cursor is used in db2?

577


What is the maximum size of a char data type in db2?

588


What are db2 objects?

641






How does a cursor work?

558


What are concurrency issues?

632


What is a plan and package in db2?

625


What is rct?

753


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10777


What are the benefits of using the db2 database?

662


what is utility for parm lib

1884


Define db2.

672


How to find the number of rows in db2 tables?

617


How many types of page locks can be held in db2?

593