Up Prev Next
From: Rakesh Dinger <dinger_rakesh at jpmorgan dot com>
Subject: Executing sql statements stored in a file
Date: Sep 15 1997 3:18PM
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");
==> Insecure dependency in system while running setuid at /dev/fd/3 line 281,
/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.
Phone : 212 235 4529 Email : email@example.com