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
- 9735 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Is db2 free?
How is a typical db2 batch pgm executed?
What is with ur in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is a system catalog table in db2?
Explain package in db2 and its advantages?
How will you return the number of records in table?
How many databases are there?
What is the use of runstats in db2?
What is explain plan in db2?
How do you select a row using indexes in db2?
What is dbrm? What it contains?
What is a buffer in memory?
is it compulsory commitment control in journal?
How do I add a column to an existing table in db2?
