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 contents of dclgen?
What is runstats db2?
Define db2.
Which command is used to remove all rows from a table?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is db2 purescale?
What do you mean by rollback?
Explain packages.
How can deadlocks be resolved?
Explain the contention situations caused by locks?
What do you mean by storage group (stogroup)?
What is the maximum No of rows per page?
What is a storage group (stogroup)?
i want to maintain uniqueness on pdf without make lf??????????
What is the meaning concurrency in the db2 database?