Hi, I'm not sure an apples to apples example is possible in print. I have sudu set up as an alias (alias sudu='sudo -H -u prodaccount SudoENV.ksh where SuoENV.ksh is a bash shell script that references the prodaccount environment variables. Actual command line example; sudu optim_table.pl -i ab_in_keys_201504 -ic NZMDSODS -n 1000 -o work_cal_123 -oc NZMDSODS -u clough -w "track_seq in ('Z010201503052014871','Z0102015030520148710')" .pl snippets 

GetOptions ("i=s"               => \$input_tbl,
            "ic=s"              => \$input_con_str,    ## defaults to 
+"nzmdsods"
            "o=s"               => \$output_tbl,       ## defaults to 
+"${input_tbl}"
            "oc=s"              => \$output_con_str,   ## defaults to 
+"nzmdsods"
            "u=s"               => \$user,
            "k=s"               => \$key,              ## defaults to 
+"rowid"
            "w=s"               => \$where_condition,  ## defaults to 
+"1=1"
            "n=i"               => \$rec_count,        ## defaults to 
+1000
            "cfg=s"             => \$config_file,      ## defaults to 
+same name as report file; if specified, overrides
 pii class mapping
            "ld=s"              => \$log_dir           ## defaults to 
+"/Projects/OPScripts/MDS/logs"
           );
.....


print "CED WHERE CONDITION $where_condition\n";
$where_condition = "1=1" if (!$where_condition);
$where_clause = "where $where_condition";
print "CED WHERE CLAUSE $where_clause\n";

[download]
result: CED WHERE CONDITION track_seq CED WHERE CLAUSE track_seq expected: CED WHERE CONDITION track_seq in ('Z010201503052014','Z010201503052014') CED WHERE CONDITION track_seq in ('Z010201503052014','Z010201503052014') This may not be a perl issue per se and more of a shell issue. I'm hoping the symptoms described will foster some thoughts/tricks on how to rectify the quirk.

In reply to Re^2: sudo ignoring string entry after first space encountered by perl197
in thread sudo ignoring string entry after first space encountered by perl197

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.