04-14-2008
Thanks for your help Franklin52 and unilover.
I ended up using a mixture of both commands (simple replacements done with SED, others with AWK) to fix my sql file.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Ok, I'm stumped and can't seem to find relevant info.
(I'm not even sure, I might have asked something similar before.):
I'm trying to use shell scripting/UNIX commands to extract URLs from a fairly large web page, with a view to ultimately wrapping this in PHP with exec() and including the... (2 Replies)
Discussion started by: ropers
2 Replies
2. Shell Programming and Scripting
I've got:
isql -U $USERID -S $SERVER -D $DATABASE -i inputfile.sql -o outputfile.txt
in inputfile I have:
go
sql#1
go
sql#2
go
sql#3
go
I also tried without "go" and with";" instead which did not work
SQL statements will work if I paste them directly into the script and use EOF
... (0 Replies)
Discussion started by: Cailet
0 Replies
3. Shell Programming and Scripting
Hi,
I have data in my text file something like this.
adams
robert
ahmed
gibbs
I want to use this data line by line as input to an sql query which i run by connecting to an oracle database from shell.
If you have code for similar scenario , please ehlp.
I want the output of the sql query... (7 Replies)
Discussion started by: rdhanek
7 Replies
4. Shell Programming and Scripting
Hi ,
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies
5. Shell Programming and Scripting
I am having trouble parsing rpm filenames in a shell script.. I found a snippet of perl code that will perform the task but I really don't have time to rewrite the entire script in perl. I cannot for the life of me convert this code into something sed-friendly:
if ($rpm =~ /(*)-(*)-(*)\.(.*)/)... (1 Reply)
Discussion started by: suntzu
1 Replies
6. Shell Programming and Scripting
Hi everyone,
another question while using sed.
my sed statement should parse every line in a file and store all "i" variable item a a new file.
any wrong arguments here?
Thanks a million.
task_name => name,
object_type => 'TABLE',
attr1 => 'TestR3',
attr2 => '$i',
for i... (4 Replies)
Discussion started by: sundaygeek
4 Replies
7. UNIX for Dummies Questions & Answers
Here is the requirement, When I run the "run file KSH (sql)", it should substitute
'${pCW_Bgn_DT}' with 201120
and
'${pCW_End_DT}' with 201124
Input File
----------
$ cat prevwk.dat
201124 20110711
run file KSH (sql)
------------------
In this file, I want to use the variables... (1 Reply)
Discussion started by: shanrice
1 Replies
8. Shell Programming and Scripting
I need to run sql script from shell script which takes the input from a file and contents of file will be like :
12345
34567
78657
and query will be like :
select seq_nbr from bus_event where event_nbr='12345';
select seq_nbr from bus_event where event_nbr='34567';
select seq_nbr... (1 Reply)
Discussion started by: rkrish
1 Replies
9. Shell Programming and Scripting
Hi All,
Seeking for your assistance to read each line $1 and $2 of input file and used it to query.
Ex. file1.txt(number range)
9064500000 9064599999
9064600000 9064699999
9064700000 9064799999
Database name: ranges_log
a_no message
9064500001 test
9064700000 ... (7 Replies)
Discussion started by: znesotomayor
7 Replies
10. Shell Programming and Scripting
Hi friends,
Need your help again to get a best approach for the below scenario.
I am previously having one shell script which accepts request_id/s as the command line argument.
single req_id arg= 1111
Multiple arg= 1111,2222,3333
which gets passed to the embedded sql inside to... (9 Replies)
Discussion started by: Showdown
9 Replies
LEARN ABOUT REDHAT
ps2frag
ps2frag(1) General Commands Manual ps2frag(1)
NAME
ps2frag - obsolete shell script for the PSfrag system.
IMPORTANT NOTICE
The new PSfrag system no longer requires the ps2frag script; instead, it handles the processing entirely within TeX/LaTeX and DVIPS. I'm
sure you will agree that never needing to run ps2frag again is a nice convenience!
However, there are two significant differences in the way this new version of PSfrag works. Please make yourself aware of them:
1) XDvi is no longer able to determine where your PSfrag replacements should go, so instead it lines them up in a vertical list to the left
of the figure. This allows you to confirm that they have been typeset properly, at least. However, to confirm that PSfrag positions your
replacements properly, you will have to view the PostScript version of your file with a viewer like GhostView, or print it out. This seems
to be the only disadvantage to the elimination of the pre-processing step.
2) If you embed ' ex' commands inside your figures, you now need to explicitly _tell_ PSfrag to process these commands. To do so, use
usepackage[scanall]{psfrag} instead of usepackage{psfrag} at the beginning of your LaTeX file.
If you only use ' ex' commands in a small number of figures, then a more efficient might be to turn on ' ex'-scanning only for those fig-
ures. To do that, add the command 'psfragscanon' immediately before each relevant includegraphics or epsfbox command.
NOTES
See the PSfrag documentation for further information.
SEE ALSO
dvips(1), gs(1), ghostview(1), latex(1)
AUTHORS
psfrag@rascals.stanford.edu
The PSfrag maintainer's mailing list.
TeXware Feb 95 ps2frag(1)