sybperl-l Archive

From: Rakesh Dinger <dinger_rakesh at jpmorgan dot com>
Subject: Executing sql statements stored in a file
Date: Sep 15 1997 3:18PM

Hi,

I have a requirement where I need to execute a bunch of sql statements (which 
are stored in a file) from within a perl script.

I tried using system and isql, but this does not work as perl was compiled with 
the suidperl security patch: (The script has setuid on by design.)

 .....system ("isql -Usa -S$SVR -P$PWD -i $PROCFILE");

/home/rdinger> admin.pl
==>  Insecure dependency in system while running setuid at /dev/fd/3 line 281, 
      chunk 13.

/home/rdinger> perl -v
This is perl, version 5.003 with EMBED
        built under solaris at Sep 22 1996 14:10:35
        + suidperl security patch

I then tried to read in the file line-by-line and build up a dbcmd string, but
then I have to backslash all the sybase @ variables within the st proc file (
 which is a pain).


Is there any way this can be done keeping in mind the security patch (short of
recompiling perl without the patch)?

Any help would be greatly appreciated.



Cheers 

Rakesh

Phone : 212 235 4529		Email : dinger_rakesh@jpmorgan.com