JDBC Adapter : Basic Notification

, ,
1

Hi,

When I am connecting Main frame DB through JDBC Adapter, i require basic notification …but in that configured operation i can`t find the “WHERE” clause which i needed…
Tell me how to come over the situation if i have to use JDBC only

I hv switched to ODBC which provides the solution

Regards
Deepak Maheshwari

2

hi,

For JDBC Adapter Basic Notification, we need to do like following,

  1. Insert New Configured Operation, Select Basic Notification.
  2. Source Table : Ex. JDBCTEST1.
    Notification Table : Ex. WMB_JDBCTEST1.
    In the Tables Tab, Select the Notification Table Name(WMB_JDBCTEST1)
  3. In the SELECT Tab, Select the required fields, mentioned the Notification Priority and Check the Delete Selected Records.
  4. In the Initialization Tab, Type the following triggers

For CREATE Statements,

  1. CREATE TABLE WMB_JDBCTEST1(TNO NUMBER(2),TNAME VARCHAR2(30),WM_ROWID NUMBER(9) PRIMARY KEY)

  2. CREATE SEQUENCE WMB_JDBCTEST1_SEQ

  3. CREATE TRIGGER WM_BasicNotificationTrigger AFTER INSERT OR UPDATE ON JDBCTEST1 FOR EACH ROW WHEN ( new.TSTATUS = ‘0’) BEGIN INSERT INTO WMB_jdbctest1 (TNO, TNAME, wm_rowid) VALUES (:new.TNO, :new.TNAME, wmb_jdbctest1_seq.NEXTVAL); END;

For Drop Statements,

  1. drop trigger wm_basicnotificationtrigger
  2. drop sequence wmb_jdbctest1_seq
  3. drop table wmb_jdbctest1

Thanks,
Sreeni