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
Is db2 relational database?
Which are the db2 tools to protect integrity of the database?
Explain correlated sub-queries.
What is load utility in db2?
Which isolation level provides maximum concurrency?
How connect db2 database to datastage?
How do you stop a db2 database in linux?
What are the contents of dclgen?
can all users have the privilage to use the sql statement select * (dml)?
How would you find out the total number of rows in a db2 table?
What is the information associated with sysibm.syslinks table?
What is a db2 schema?
Explain about rct in db2?
What is query_cache_limit?
What is a collection in db2?