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 universal database?

617


How do you eliminate duplicate values in db2?

682


What are the 2 sqlcodes that are returned?

638


What is a storage group (stogroup)?

774


What os does db2 run on?

570






Is ibm db2 open source?

584


What is db2 bind process?

753


How to execute stored procedures?

620


What is blu acceleration in db2?

603


How and when does the db2 enforces the unique key?

613


What is db2 connect?

603


How can you do the explain of a dynamic sql statement?

635


Explain the contents that are a part of dclgen.

656


Define db2.

670


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2044