Issue qcmdexc from VB client

[shfishell@yahoo.com]

I'm trying to override to a particular member on the AS/400 but I'm receiving a token not valid error. Anyone have any ideas what's wrong with this syntax? call qsys.qcmdexc(ovrdbf file(file1) mbr(mbr9) ovrscope(*job) , 0000000044.00000)

[shfishell@yahoo.com]

Issue qcmdexc from VB client

I found that the parm part needs to be in single quotes. Thanks anyway. Figure 3 is an example of VB code that invokes the function to override a database file. In the first override example, any future reference to file FILE1 is being overridden to refer to member MBR9. This is the complete SQL command generated: CALL QSYS.QCMDEXC('OVRDBF FILE(FILE1) MBR(MBR9) OVRSCOPE(*JOB) ', 0000000044.00000)