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 db2 purescale?
How do I connect my db2 database to ibm?
What is a cursor in programming?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Explain in detail about buffer manager and its functionalities?
Define db2.
What is bind package and plan in db2?
Is db2 a programming language?
What are iseries servers?
How to find the maximum value in a column in the db2 database?
What is declare cursor?
what is the role of the cursor in db2?
Explain db2.
How to fetch the last row from the table in SQL (db2)?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?