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
What is the use of value function?
How to retrieve rows from a db2 table in embedded sql?
What do you mean by cursor?
What is commit in db2?
What is copy pending status in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
How to check last update on table in db2?
What is the maximum No of rows per page?
How to resolve deadlock issue
what is the role of the cursor in db2?
What does db2 plan contain?
What is the physical storage length of time data type?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
is it compulsory commitment control in journal?
How will you return the number of records in table?