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

what is the total syntax for fetch ? can any one please give
me all the details of fetch ? thx

Question Posted / krishna

Answers were Sorted based on User's Feedback



what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx..

Answer / pandu

Exec SQL
Fetch<cursorname> into :<host variables>
End-exec.

correct me is am wrong?

Is This Answer Correct ?    11 Yes 0 No

what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx..

Answer / sree

YES THE ABOVE SYNTAX IS CORRECT

IF THERE ARE MORE THAN ONE HOSTVARIABLES,IE IF THERE ARE
MORE COLUMNS IN THE DB2 TABLE

SYNTAX IS

EXEC SQL
FETCH CURSORNAME INTO :HOSTVARIABLE1 ,
:HOSTVARIABLE2 ,
---
---
:HOSTVARIABLEN
END-EXEC

Is This Answer Correct ?    11 Yes 0 No

Post New Answer

More DB2 Interview Questions

What do you mean by storage group (stogroup)?

0 Answers  

what is the soft code for deadlock ?

2 Answers   Logica CMG,

Mention the definition of cobol in varchar field.

0 Answers  

What does sqlcabc has?

0 Answers  

How can deadlocks be resolved?

0 Answers  

What is concurrency?

0 Answers  

What is with ur in db2?

0 Answers  

What is the self-referencing constraint?

2 Answers  

What is the difference between oracle and db2?

0 Answers  

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

What is copy book?

1 Answers   Thomson Reuters,

For more DB2 Interview Questions Click Here
Categories