Hi,

Is it possible use the SYSTEM SPL to find the OS details using 'uname'
command. I am using 7.31.UD7

I tried this:

> create procedure getosname()
> SYSTEM 'uname';
> end procedure;

Routine created.

> execute procedure getosname();

Routine executed.

How do I get the output to be printed other than redirecting it to a
temp file and then getting the data from there. Using UDR is not
possible as this is 7.31.

Is there any other way to get the platform type using a SPL..

Thanks

Antony

Not that I can think of.

Why does the platform type of the database server matter?

Perhaps run some sql to stick this into a table somewhere
that you can query rather than doing the uname each time?

X=`uname -a`
echo 'insert into table x values ("'${X}'";' | dbaccess mydb


stick this in a table