Stored Procedure ???
Hello Everyone,
In a stored procedure can we pass command line arguments thru the
system command of SPL.
Example :
Create procedure xyz(str char(100))
system "test.4ge str ";
enc procedure
--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---
In article <7hk9hn$9hq$1@nnrp1.deja.com>,
yap123@my-dejanews.com wrote:
> Hello Everyone,
>
> In a stored procedure can we pass command line arguments thru the
> system command of SPL.
>
> Example :
>
> Create procedure xyz(str char(100))>
> system "test.4ge str ";
> enc procedure
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
>
You certainly can !
Simply follow the following syntax :-
create procedure pr_del_mford(orderno char(10))define syscall char(100);
-- set debug file to '/tmp/pr_del_mford';
-- trace on;
define currdb char(4);
select sysmaster:pr_curr_db()
into currdb
from systables where tabid = 1;
let syscall = "uudelmford " ||orderno|| " " ||USER|| " " ||currdb|| "
&";
system syscall;
end procedure
Regards
Glyn Balmer
BICC Cables Limited
Erith UK Kent
--
"Nothing succeeds like a toothless budgerigar"
--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---