Interested to Buy Any Domain ? << Click Here >> for more details...
insert into tablename a
column1,
column2
select column1,
column2
from tablename b
i am getting abend -104..can any one help?
- 3 Answers
- 9611 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guna
insert into tablename(column1,column2)
select column1,column2 from tablename
Alias names 'a' and 'b' should not be used.In case u want
to use alias names, specify the column names with prefix as
a.column1,b.column2 like that.
Also, brackets must be given in an insert statement.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / 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 |
What is a buffer pool?
What is a base table?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
What is the usage of open cursor command?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
What is db2 connect?
How to resolve -407 sql code in DB2?
What is the function of buffer manager?
What is phantom read in db2?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
Where would you find information about the type of database authority held by the user?
Where could you look if you had a question about whether a column has been defined as an index?
COBOL 
