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 are the two types of logging in the db2 database? Explain them.
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the maximum No of rows per page?
Give the name of some fields form sqlca.
What is drop table?
How connect db2 database to datastage?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
what is the sqlcode -501
How many databases can be created inside an instance in db2 ?
How can you classify the locks in db2?
Which component is responsible for db2 startup and shutdown?
What are the rules for db2 programming?
What is the difference between plan and package in db2?
Mention the location where the output received from explain statement is stored.
What is database reorganization?