Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: hofc
  • Order by date
  1. hofc

    how to call db2 store procedure in trigger / UDF?

    Thanks for the reply. Can trigger / UDF execute shell script?
  2. hofc

    how to call db2 store procedure in trigger / UDF?

    Hi, 1. Any body know how to call store procedure in trigger? 2. Any body know how to call store procedure in user define function? Thanks. Regards, fcho
  3. hofc

    Hit error SQL10003C when call DB2 C UDF

    Hi, I'm recently getting below error when calling my C UDF. Any body know how to solve this? FYI, previously the C UDF is working fine but don't know why recently cannot work. I'm using DB2 UDB 7.2 in AIX(RS 6000). SQL10003C There are not enough system resources to process the request...
  4. hofc

    cann't get environment variable in C UDF

    Hi, I've a C UDF that suppose to get 2 environment variable using getenv() but don't know why the udf unable to get it, any body know why? FYI, my C udf is in DB2 AIX. I also set the environment variable in DB2ENVLIST using db2set and restart the instance but still cannot work. >> db2set...
  5. hofc

    TRIGGER AFTER INSERT NOT WORK!

    Hi, I've 3 triggers in AIX box as below : DROP TRIGGER SS_ATRG; CREATE TRIGGER SS_ATRG AFTER INSERT ON SS REFERENCING NEW AS NSS FOR EACH ROW MODE DB2SQL BEGIN ATOMIC VALUES DBIQSEND('IQMGR', CONCAT(NSS.MDC,'PROG1'), '42');END; DROP TRIGGER SS_UTRG; CREATE TRIGGER SS_UTRG AFTER UPDATE OF...

Part and Inventory Search

Back
Top