insert into tablename a
column1,
column2
select column1,
column2
from tablename b
i am getting abend -104..can any one help?
- 3 Answers
- 9094 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
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Is ibm db2 free?
What is host variable?
What is dclgen in db2?
What is a system catalog table in db2?
What is isolation level in db2?
How many databases can be created inside an instance in db2 ?
Why db2 is called db2?
What is package in db2 mainframe?
How to check sequence on a table in db2?
What is multi row fetch in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What are types of indexes?
What is the use of dclgen in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
