I am executing a few sql scripts through RPG program using QCMDEXC.
command = 'RUNSQLSTM SRCFILE('+%trim(sqlLibrary)+
'/'+%trim(sqlSource)+') '+'SRCMBR('+%trim(sqlMember)+
') COMMIT(*NONE)' ;
How do I get to know the status of the SQL scripts in program? Is there a way I can do this?
command = 'RUNSQLSTM SRCFILE('+%trim(sqlLibrary)+
'/'+%trim(sqlSource)+') '+'SRCMBR('+%trim(sqlMember)+
') COMMIT(*NONE)' ;
How do I get to know the status of the SQL scripts in program? Is there a way I can do this?
Comment