Results 1 to 3 of 3

Thread: Events

  1. #1
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74

    Unanswered: Events

    Hi people,

    Somebody could tell me how i can work with events on db2 7.2?...
    For example: I want to extract from a table sets of data,
    the table have the folowing columns (str_id, wk_id,..etc..) and one
    store is defined by the str_id.
    I want to extract from the table the stores and each store correspond
    at an Event.

    I need an urgent help!
    Thank!

    Rui

  2. #2
    Join Date
    Jan 2003
    Location
    Zutphen,Netherlands
    Posts
    256
    What exactly do you mean by event? If the table you are talking about is updated, you could create a stored procedure to write a dataset to another (temporary ) table. If you add a timestamp to the set you can afterwards distinguish the different datasets.....
    Ties Blom
    Senior Application Developer BI
    Getronics Healthcare
    DB2,ORACLE,Powercenter,BusObj,Access,
    SQL, SQL server

  3. #3
    Join Date
    Jul 2003
    Location
    porto - Portugal
    Posts
    74
    THANKS..
    I want to process a dataset like an Event (for example a set of imformation for one Store(str_id) come from one table with many stores).

    Originally posted by blom0344
    What exactly do you mean by event? If the table you are talking about is updated, you could create a stored procedure to write a dataset to another (temporary ) table. If you add a timestamp to the set you can afterwards distinguish the different datasets.....

Posting Permissions

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