Trigger start on DB2 via ODBC

[bobo123]

Hi all,
please, anybody has experience with starting/removing triggers on DB2 from VFP via ODBC ??
Any help ?
Thanks !!!!
Bobo

 

[mathirajan]

I think u have to send the respective DB2 command(s) through SQLExec(). U need to verify the security issues involved in it. I mean the authentication (rights) on those objects.

In short if u know the DB2 commands for any action to be taken on the backend the same command u can send it via SQLExec()

 

[bobo123]

Im sure I'm connected properly.
The DB2 command is:
RMVPFTRG FILE(MYFILE)

I tried all:
sqle(1,"RMVPFTRG FILE(MYFILE)&quot
sqle(1,"RMVPFTRG(MYFILE)&quot
sqle(1,"RMVPFTRG(FILE(MYFILE))&quot
sqle(1,"RMVPFTRG('MYFILE')&quot
sqle(1,"RMVPFTRG('FILE(MYFILE)')&quot
and all this with "CALL" statemnent - nothing works (

Bobo