Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

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

Question Posted / rock

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

What is meant by index cardinality?

2 Answers  

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

What is the connection string to connect to the DB2 Database ?

0 Answers   MCN Solutions,

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

Explain about cursor stability?

0 Answers  

What is PRIME TABLE and what are the uses of it

1 Answers  

Mention the various locks that are available in db2.

0 Answers  

Can one database have multiple instances?

0 Answers  

What is the role of union all and union

0 Answers  

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

1 Answers   UST,

What is runstats db2?

0 Answers  

For more DB2 Interview Questions Click Here
Categories