call stored proc from 4GL possible and 4GL from stored proc

[jpp]

Hi ,


Is it possible to call , execute , run 4GL code from within a stored proc

If the answer if not yes :

I call a stored procedure on an SQL server server from within a servlet,

I have business logic in 4GL doing the same, I want to be able to call it from within the same servlet. Being able to call the 4GL logic from within a stored procedure would make my transition to progress easy

tx

 

[Casper]

Look at KB 19046: http://tinyurl.com/zsnje

HTH,

Casper.

 

[BCM]

Yes, it's possible. SQL Server stored procedures can run external programs and O/S commands. Take a look at the procedure named 'xp_cmdshell' in the master database of your SQL Server.