Hi guys,
i know how to run a single query using mysql embedded in a shell script as follows:
`mysql -umyuser -pmypass --host myhost database<<SQL
${query};
quit
SQL`
However, how would i be able to run several queries within the same connection?
The reason for this is i am creating... (3 Replies)
Hello everyone,
It's my first week using unix and shell scripting. I tried creating a script that has a function that execute SQL query. my script looks something like this:
----------------------------------------------------
#!/bin/sh
tableName="myTable"
secondTable="secondTable"... (2 Replies)
Hi,
I'm trying to build a shell script that reads a set of accounts from a file. For each account I need to perform a set of sql queries. So I have a loop with a set of sqlplus connections to retrieved my data.
Is it possible to have a single sqlplus connection before entering the loop and... (4 Replies)
Hi,
I have a requirement with,
No~Dt~Notes
1~2011/08/1~"aaa
bbb
ccc
ddd
eee
fff
ggg
hhh"
Single column alone got splitted into multiple lines.
I require the output as
No~Dt~Notes
1~2011/08/1~"aaa<>bbb<>ccc<>ddd<>eee<>fff<>ggg<>hhh"
mean to say those new lines to be... (1 Reply)
Hi,
I have a script where I make a sqlplus connection. In the script I have multiple sql queries within that sqlplus connection. I want the result of the queries to be stored in shell variables declared earlier. I dont want to use procedures. Is there anyway else.
Thanks in advance..
Cheers (6 Replies)
I have n number of SQL queries needs to executed in Shell. Result of this query need to assign in a variable. Once all the queries are executed script needs to exit.
Sample Query:
SQL 1: Select Count(*) from TABLE GROUP BY COL1,COL2
SQL 2: Select Count(*) from TABLE GROUP BY COL1,COL2
... (2 Replies)
how to store the count of queries in variables inside a filein shell script
my output :
filename
-------
variable1=result from 1st query
variable2=result from 2nd query
.
.
.
. (3 Replies)
Hi All,
I have a file queries.txt as follows :
SELECT COLUMN1 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN1 FROM SCDEMA2.TABLE2;
SELECT COLUMN2 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN2 FROM SCDEMA2.TABLE2;
SELECT COLUMN3 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN3 FROM SCDEMA2.TABLE2;
SELECT... (2 Replies)
How to run multiple Queries in a ksh Script
I have a KSH script that has one SQL Query and generates and emails output of the query in HTML format. I want to change the script so that it has three SQL queries and the last query generates and emails the HTML output page of just that query.
So far... (5 Replies)
Hi,
I have a shell script containing multiple PSQL queries for which I want the output to be redirected to a text file.
psql -U postgres -d database -o textfile.txt << EOF
Query1;
Query2;
Query ....;
EOF
When executing the script, queries outputs are directed to textfile.txt, however... (2 Replies)
Discussion started by: nms
2 Replies
LEARN ABOUT ULTRIX
uucompact
uuaids(8c)uuaids(8c)Name
uucompact, uumkspool, uurespool, uupoll - uucp utilities
Syntax
uucompact -ssystem
uumkspool system ...
uurespool [ -t# ]
uupoll system ...
Description
All of the commands are located in
The command compacts uucp system spool directories and associated subdirectories. If system is ALL, then all existing uucp system spool
directories are compacted. Otherwise, only the specified system spool directory is compacted. If no system is specified, is compacted.
If is stopped before it is finished, it can be restarted without reprocessing directories. The command continues processing where it left
off during it's previous instantiation.
The command makes a per system spool directory and associated subdirectories for each of the specified systems. For example, if system is
mk3 and if the local system name is penny, the following directories are created:
/usr/spool/uucp/sys/mk3
/usr/spool/uucp/sys/mk3/C.
/usr/spool/uucp/sys/mk3/X.
/usr/spool/uucp/sys/mk3/D.
/usr/spool/uucp/sys/mk3/D.penny
/usr/spool/uucp/sys/mk3/D.penny
The command moves files from old spool directories to new spool directories. Because the structure of the spool directories has changed
from older versions of it is necessary to respool old spooled files to new spool directories in at least two instances:
o When installing the current version of
o When creating a new system spool directory for each system.
In the latter case, it is necessary to move files from to the new spool directories. To ease this task, moves files that have been spooled
in one of 4 formats and respools them under the new spooling structure. The format is specified by the -t# option, where the number sign
(#) can be any one of the following:
o Original spool - All files are in
o Split spool - Contains the subdirectories
o Modified split spool - Contains all subdirectories listed in split spool, and
o Used when a new system directory has been created and spool files must be moved from the DEFAULT directory to the new system directory.
The command forces a connect attempt to the named systems even if recent attempts have failed, but not if the file prohibits the call. For
example, the file will prohibit the call if it is the wrong time of day. Thus, the should be monitored for messages about the connection.
Files
Spool directory
Logfile
See Alsomail(1), uucp(1c), uux(1c)uuaids(8c)