Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

SQL script processor and executor

by PhilHibbs (Hermit)
on Jul 27, 2012 at 10:17 UTC ( #984012=CUFP: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    @rem = '--*-Perl-*--
    @echo off
    perl "%~dpnx0" %1 %2 %3 %4 %5 %6 %7 %8 %9
    ...
    __END__
    
    :endofperl
    
  2. or download this
    @uatuser.txt
    set schema da03;
    ...
    ,select region_name from regions where region_id in ( ${regions} );
    
    *echo ${result}
    
  3. or download this
    cs-uat-etl02          <= Unix server name
    username              <= put your user name here
    password              <= put your password here
    ...
    DSXMUAT               <= put the database user name here
    dbpassword            <= put the database password here
    /data/scratch/phil    <= this is where the temporary shell script is w
    +ritten
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: CUFP [id://984012]
Front-paged by Arunbear
help
Chatterbox?
[Corion]: hippo: If you have a Unicode-wise Perl then likely some zero-width characters in $x would work. Maybe $x = "\x{200b}" works.
[Corion]: Hmm - no, that outputs 1 for me on 5.14 - perl -wle "my $x = qq(\x{200b}); warn $x; warn length $x"
[hippo]: Smart - I'll give that a go. Thanks.
[hippo]: Ah
[Corion]: But maybe there is some other Unicode string that will be true but have a zero width
[hippo]: For explanation, I've seen this construct in someone else's code (no names, no pack drill) and couldn't think of a situation to trigger it.
[Corion]: You'll have to look somewhere esoteric for that. Maybe some tied variable or special dualvar can also trigger that. But it's certainly not a common occurrence
[Corion]: And on 5.20, the following also outputs no find:perl -wle 'for my $x ("\x{2000}".."\ x{1fffff}") { if( $x && ! length $x ) { warn qq(<$x>); warn length $x; die } }'
[Corion]: (this time on Unix)
[hippo]: Understood. I'll have to go through the code and see if it's doing anything fancy with ties, dual-vars or non-scalars. In the end, it's probably a bug though.

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (11)
As of 2017-07-27 13:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I came, I saw, I ...
























    Results (413 votes). Check out past polls.