insert into tablename a column1, column2 select column1, col

insert into tablename a
column1,
column2
select column1,
column2
from tablename b

i am getting abend -104..can any one help?

Question Posted / rock

3 Answers
8300 Views
Syntel, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

insert into tablename a column1, column2 select column1, column2 from tablenam..

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

insert into tablename a column1, column2 select column1, column2 from tablenam..

Answer / munabhai

illegal symbol,then u can find -104 error

Is This Answer Correct ?

2 Yes

2 No

insert into tablename a column1, column2 select column1, column2 from tablenam..

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

Post New Answer