insert into tablename a
column1,
column2
select column1,
column2
from tablename b

i am getting abend -104..can any one help?

Answer Posted / amala

A 104 error indicates that either a field that is defined
as integer is specified with quotes or an Char value in
insert that needs to represented with quotes is not
represented so...Hope this helps to solve your issue

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a db2 table?

597


What is the difference between drop table and delete table?

556


What is explain in db2?

585


What is cobol db2?

570


What is image copy in db2?

574






Is it possible using max on a char column?

610


what is db2 restart?

1695


What are the different types of base tables?

587


Why select is not preferred in embedded sql programs?

715


What db2 400?

679


What is lock escalation in db2?

574


When do you specify the isolation level?

611


Explain about rct in db2?

640


What is blu acceleration in db2?

608


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2282