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
9871 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

More DB2 Interview Questions

how to fetch multiple records without using cursor

14 Answers HCL,

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers TATA,

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

1 Answers

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers Syntel,

Could anyone clearly explain the diference between sub query and correlated sub query?

3 Answers

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers

What is ACQUIRE/RELEASE in BIND?

3 Answers Cognizant,

Comment whether the cursor is closed during commit or not.

0 Answers

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

2 Answers IBM,

Who uses db2?

0 Answers

What is the difference between IN subselects and EXISTS subselect?

1 Answers HCL, PreVator, TCS,

What is a synonym? How is it used?

2 Answers

For more DB2 Interview Questions Click Here