vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| U can try using select dbinfo('dbhostname') from systables where tabid=1 to get the hostname .. if that's what u r interested in. U can also try DBINFO('version','os') to get what kind of OS is it .. HTH Thanx much, Rajib Sarkar DB2 UDB RPD Team IBM Data Management Group T/L : 667-2100 http://www.ibm.com/software/data/db2/udb/support/ >From his neck down a man is worth a couple of dollars a day, from his neck up he is worth anything that his brain can produce. -- T. Edison "Antony U P" <anupmail@gmail.c om> To Sent by: informix-list@iiug.org informix-list-bou cc nces@iiug.org Subject OS type using SP 01/05/2006 05:16 PM 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 _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list |
| Thread Tools | |
| Display Modes | |
|
|