I am exporting test with criteria. How do I prevent the user input from showing up on the output file? The argument is in the where clause. I am using a .bat file to run the script, don't know if that helps.
I have provided results and script.
Results:
Enter value for 2: 'IR'
old 8: where vendor = &2
new 8: where vendor = 'IR'
1000*200*IR******************* ----------------------------------------------------
Script:
set echo off
set termout off
set pagesize 0
set heading off
set feedback off
set serveroutput off
set linesize 1000
spool graybar_out.txt
select rfqnum||'*'||rfqlinenum||'*'||vendor||'*'||quotationlineid||'*'
||itemnum||'*'||manufacturer||'*'||modelnum||'*'||orderqty||'*'
||orderunit||'*'||unitcost||'*'||conversion||'*'||linecost||'*'
||eoq||'*'||deliverytime||'*'||deliverydate||'*'||enterdate||'*'
||enterby||'*'||memo||'*'||description||'*'||quotestartdate||'*'
||quoteenddate||'*'
from quotationline
where vendor = &2;
quit
----------
John
I have provided results and script.
Results:
Enter value for 2: 'IR'
old 8: where vendor = &2
new 8: where vendor = 'IR'
1000*200*IR******************* ----------------------------------------------------
Script:
set echo off
set termout off
set pagesize 0
set heading off
set feedback off
set serveroutput off
set linesize 1000
spool graybar_out.txt
select rfqnum||'*'||rfqlinenum||'*'||vendor||'*'||quotationlineid||'*'
||itemnum||'*'||manufacturer||'*'||modelnum||'*'||orderqty||'*'
||orderunit||'*'||unitcost||'*'||conversion||'*'||linecost||'*'
||eoq||'*'||deliverytime||'*'||deliverydate||'*'||enterdate||'*'
||enterby||'*'||memo||'*'||description||'*'||quotestartdate||'*'
||quoteenddate||'*'
from quotationline
where vendor = &2;
quit
----------
John