Search Results

Anyone know how I would be able to output the results to a txt file where it would include the variable from the list file next to its result?

found the error - I was missing the semicolon to actually end the statement:
echo "select count (*) from dear_trade_snapshot where id_prtf_stars = '$prtf';"

ok, I placed some brackets around prtf in the sql statement and my output now looks like this:



But, I'm not seeing the actual row counts. The start and end times are the same as well. I'm...

Just tried it, however same results...

vgersh99, I gave that a shot, and now i see that it connects and disconnects to sqlplus, however I don't think its running the script as it happens instantaniously (sp?) and nothing is printed...

Hi Jean-Pierre,

Thank you for your reply. I have tried what you suggested and still receive the same issue, with a syntax error that | is unexpected.

Hello,

I'm trying to write a script that will loop a sql statement through an external list. Basically, the script enters a loop and runs the sql statement for each entry in the list file. ...

thanks for all the suggestions everyone! turns out that the list file wasn't fully qualified in the main script. it wasn't pathed at all, so that's why it only worked manually when i was in the...

Hi all,

I have a main script (called OracleCleanup) that runs some sql queries. that runs off a wrapper script which contains the sources for the login information and and JOB_HOME (the script is...

i have a feeling my path is wrong for the list file...let me correct that now...

sorry about that...i have never done any real scripts in unix, and this is my first coding assignment at my internship...basically the code is supposed to read a list file, which is structured...

Here is the whole script so you can get a good idea of what it does:


#!/bin/ksh -x

echo "start of new archive history.ksh"
TBL_HIST_LIST=${JOB_HOME}/archiveHistTbl.list...

Ygor, I tried the loop, however it is not printing anything....I don't think it accesses the archiveHistTbl.list file
Here is the new code:

#For each table, delete based on dt_last_upd
while...

can anyone help??

oh also, how would i make it so that if the 2nd column had an empty value i could set a default value of 30 to be inputted?

Ygor,

would i be able to use the awk script to read the 2nd column of data from the list in the code you wrote?

i know this is a stupid question but...can awk do more than print? can i have it assign a value from a file list to a variable in the script?

the list file itself just contains table names. The goal is to have it include a table name and a number that will be passed through a variable and parsed through a query.

Sample: table_name1 30...

Hi all,
i need to write a script utilizing either awk or sed to allow me to read in two values off a list file (i will probably need a delimiter value there as well).
i.e. table_name, nDays. Any...

Hi all,

I've been assigned the task of modifying a script which reads in names of tables from a list file, exports a 30 days worth of data from these tables, then deletes the table. The list file...