08-24-2006
Hi
The Escape characters before the brackets ...still gives the same problem..The variables are empty...
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi to everyone, i want ask if someone knows about a script/program to convert the .gdl (Interbase) to .sql scripts. I wrote a little script to make it but it's very very simple, and the triggers and some code from .gdl are so difficult to me. If somebody could help me, I would very thankful.
... (0 Replies)
Discussion started by: ch4r1e5
0 Replies
2. Shell Programming and Scripting
Oracle and Scripting gurus,
I need some help with this script...
I am trying to add the query
SELECT * FROM
ALL_SYNONYMS
WHERE SYNONYM_NAME = 'METADATA'
in the current script....
Read the result set and look for the TABLE_NAME field. If the field is pointing to one table eg.... (18 Replies)
Discussion started by: madhunk
18 Replies
3. Shell Programming and Scripting
I've a script that fetches various values from the database as below:
#! /bin/ksh
$conn="user/pwd@service_name"
`sqlplus -s << $conn EOF1
@xyz.sql
@pqr.sql
@abc.sql
EOF1`
The output of the script should generate txt files containing the results from queries which are further... (6 Replies)
Discussion started by: manthasirisha
6 Replies
4. Shell Programming and Scripting
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies
5. Shell Programming and Scripting
hi all,
i have a function which will take i/p as a ddl sctipt as i/p and execute it,
let
function execute_sql
{
db_var="$1"
v_cnt=`sqlplus -s XXXXX/XXXXX@aXXX << ENDSQL | sed -e "s/Connected\.//" -e "/^$/d"
set pagesize 0 feedback off verify off heading off echo off serveroutput on size... (4 Replies)
Discussion started by: manas_ranjan
4 Replies
6. Shell Programming and Scripting
I am using HP-UX:
I have written a ksh script where I need to connect to sqlplus and execute few sql scripts. Part of this code is -
sqlplus user/temp1234 <<!
set serverout on
set feedback off
set pages 1000
set colsep ,
set echo off
spool /home/supp1/pks/output.csv... (8 Replies)
Discussion started by: Sriranga
8 Replies
7. Shell Programming and Scripting
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies
8. UNIX for Advanced & Expert Users
Hi Experts:
I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies
9. UNIX and Linux Applications
using sqlplus I want to execute a .sql script that has dbms_output statments in rhe script. I want to write the dbms_output statements from .sql file to a log file. is this possible. thanks
any help would be appreciated
:wall: (1 Reply)
Discussion started by: TRS80
1 Replies
10. Shell Programming and Scripting
Hi,
I'm planning to load the data from FLAT files into tables.
Source file: more input.txt
LRNO|Bale|Horsepower|NumberOfBarges|BollardPull|NumberOfCars|GasCapacity|GrainCapacity|IndicatedHorsepower|LiquidCapacity|... (6 Replies)
Discussion started by: shyamu544
6 Replies
rmdir(1) General Commands Manual rmdir(1)
NAME
rmdir - Removes a directory
SYNOPSIS
rmdir [-p] [-s] directory...
STANDARDS
Interfaces documented on this reference page conform to industry standards as follows:
rmdir: XCU5.0
Refer to the standards(5) reference page for more information about industry standards and associated tags.
OPTIONS
Removes all directories in a path name. For each directory argument, the directory entry it names is removed.
If the directory argument includes more than one path name component, effects equivalent to the following command occur: rmdir -p
$(dirname directory)
That is, rmdir recursively removes each directory in the path name.
OPERANDS
The path name of an empty directory to be removed.
DESCRIPTION
The rmdir command removes a directory from the system. The directory must be empty before you can remove it, and you must have write per-
mission in its parent directory. Use the ls -al command to see if a directory is empty.
If a directory and a subdirectory of that directory are specified in a single invocation of rmdir, the subdirectory must be specified
before the parent directory so that the parent directory will be empty when rmdir tries to remove it.
RESTRICTIONS
A directory must be empty before you can remove it, and you must have write permission in its parent directory. If the -p option is used,
all directories in the path must be empty except for the directory being recursively removed.
EXIT STATUS
The following exit values are returned: Each directory specified by directory operand was successfully removed. An error occurred.
EXAMPLES
To empty and remove a directory, enter: rm mydir/* mydir/.* rmdir mydir
This removes the contents of mydir, then removes the empty directory. The rm command displays an error message about trying to
remove the directories . (dot) and .. (dot dot), and then rmdir removes them.
Note that rm mydir/* mydir/.* first removes files with names that do not begin with a (dot), then those with names that do begin
with a (dot). You may not realize that the directory contains file names that begin with a (dot) because the ls command does not
normally list them unless you use the -a option to see the files whose names begin with a (dot). To remove all of the directories
in the path name a/b/c, enter: rmdir -p a/b/c
Use a command like this one if directory a in the current directory is empty except that it contains a directory b and a/b is empty
except that it contains a directory c.
ENVIRONMENT VARIABLES
The following environment variables affect the execution of rmdir: Provides a default value for the internationalization variables that are
unset or null. If LANG is unset or null, the corresponding value from the default locale is used. If any of the internationalization vari-
ables contain an invalid setting, the utility behaves as if none of the variables had been defined. If set to a non-empty string value,
overrides the values of all the other internationalization variables. Determines the locale for the interpretation of sequences of bytes
of text data as characters (for example, single-byte as opposed to multibyte characters in arguments). Determines the locale for the for-
mat and contents of diagnostic messages written to standard error. Determines the location of message catalogues for the processing of
LC_MESSAGES.
SEE ALSO
Commands: mkdir(1), ls(1), rm(1)
Functions: rmdir(2), unlink(2), remove(3)
Standards: standards(5)
rmdir(1)