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

Is db2 relational database?

730


Which are the db2 tools to protect integrity of the database?

898


Explain correlated sub-queries.

764


What is load utility in db2?

881


Which isolation level provides maximum concurrency?

891


How connect db2 database to datastage?

971


How do you stop a db2 database in linux?

741


What are the contents of dclgen?

838


can all users have the privilage to use the sql statement select * (dml)?

839


How would you find out the total number of rows in a db2 table?

779


What is the information associated with sysibm.syslinks table?

871


What is a db2 schema?

969


Explain about rct in db2?

864


What is query_cache_limit?

744


What is a collection in db2?

768