Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2005

    Unanswered: Cursors,Triggers in DB2

    hi guys i am a newbee here
    plz!! help me!! my exams is on 12 dec

    Q1) how cursors,triggers,functions are maintained in db2 product?

    Q2) DB2 architecture defining logical n physical data structure?

    Q3) on what model db2 is based?

    U can also refer a site where i can get the info!!
    plz!! plz!! help!!


  2. #2
    Join Date
    Nov 2004


    as always, too late...
    it is not possible to explain in some days the complete DB2 terminology and architecture. You will have to study day and night.
    Cursor : is part of sql instructions : declare cursor/open cursor...
    to fetch data from a database
    triggers are db2 objects that are fired whenever the depending table is hit in a specified condition : update/delete/insert..
    functions : are DB2 or programming objects that can be defined and called in a user program : eg substr(col,1,1) where substr is a build in function
    the architecture and model are basically explained in the administration guides of DB2 documentation. all doc is available online en public...
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified

  3. #3
    Join Date
    Nov 2004
    Provided Answers: 4
    Q2) DB2 architecture defining logical n physical data structure?
    Read this paper about logical and physical data structures.
    In two words:
    Logical: about entities, its data elements and relations between entities.
    Physical: how things are implemented in the database, entities become tables, data elements fields, relations become FK's and a lot of performance related decisions (indexes, tablespaces, ...) and ease-of use (views, UDF's, SP's).
    Q3) on what model db2 is based?
    Relational calculus (?)
    With kind regards . . . . . SQL Server 2000/2005/2012

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  4. #4
    Join Date
    Aug 2004
    The ideal answer to most exam questions is very likely to be something that the instructor said in class. Check to see if you took notes, or go to the instructor's office and shoot the breeze with him/her and casually bring up the topics that you need info on.

  5. #5
    Join Date
    Nov 2005
    thx!! guys 4 ur help!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts