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 a dbrm in db2?
How do you find the maximum value in a column in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Is ibm db2 free?
What is db2?
What os does db2 run on?
Explain the contention situations caused by locks?
What is the result of open cursor statement?
How to get the ddl of a table in db2?
Explain the function of data manager.
What is cursor with hold option in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How to run db2 command in windows?
How to retrieve rows from a db2 table in embedded sql?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?