SQL Command in a Routine
Posted: Thu Mar 02, 2006 9:32 am
People,
I need to update an existing row or insert a new row in a table after the job runs, i am tinking of writing a AFTER JOB ROUTINE, so Can i run a SQL Command in a Routine, I knwo we can run a Unix command using DSExecute('UNIX','Command','OUTPUT','ReturnCode'), is there any similar way to run a SQL command.
Please throw some ideas.
Thanks
Chowdary
I need to update an existing row or insert a new row in a table after the job runs, i am tinking of writing a AFTER JOB ROUTINE, so Can i run a SQL Command in a Routine, I knwo we can run a Unix command using DSExecute('UNIX','Command','OUTPUT','ReturnCode'), is there any similar way to run a SQL command.
Please throw some ideas.
Thanks
Chowdary