|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
hanging sql script
Post 12302 by inquirer on Wednesday 26th of December 2001 03:43:44 AM
12-26-2001
compatibility
i've seen this before...
i'm using bourne shell is it compatible?
for example:
...
sqlplus scott/tiger << endplus
@ myscript.sql
endplus
ls -l
date
... etc.
i mean is this syntax will be compatible if combined with other syntax under bourne shell?
thanks
i'm using bourne shell is it compatible?
for example:
...
sqlplus scott/tiger << endplus
@ myscript.sql
endplus
ls -l
date
... etc.
i mean is this syntax will be compatible if combined with other syntax under bourne shell?
thanks
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Greetings to everyone,
My Problem:
I have a script which inturn calls couple of other scripts in different servers (solaris) to do a server startups on the respecitve boxes.
My script ...
#!/usr/bin/ksh
siebsrvr_root=/users/siebelserver/siebsrvr
cd $siebsrvr_root
. ./siebenv.sh... (2 Replies)
Discussion started by: vivsiv
2 Replies
2. 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
3. UNIX for Dummies Questions & Answers
I am new at developing EXPECT scripts. I'm trying to create a script that will automatically connect to a UNIX server via FTP and download a log file from the server within a specified server directory on the remote machine. I'm having problems with the EXPECT script "hanging" at the password... (0 Replies)
Discussion started by: markus2008
0 Replies
4. Linux
I want to create a script to simulate a process that hangs to test a java application. My java app executes a system command, which can also be executing scripts, etc. Any ideas on such a script?
The java code is:
Runtime rt = Runtime.getRuntime();
Process p = rt.exec("sh... (4 Replies)
Discussion started by: brendan76
4 Replies
5. Shell Programming and Scripting
Hello,
I have the following shell script and when i execute, it keeps hanging and nothing happens
Please let me know.
Requirement is to read data from file and pass it to the sql and create files as shown.
code
/********
#!/bin/sh
while read user.dat
do
echo "user = $1 email =... (1 Reply)
Discussion started by: rakeshsr12
1 Replies
6. Shell Programming and Scripting
ok... this is where i am at... i need a script to call another script as a wrapper because the first script creates a sub-shell.
here is what i got... i kick off the first script "CCBDEMO-threadpoolworker.sh"
#!/bin/bash
clear #clearing screen
directory="/data1/spl/cis/CCBDEMO/bin"... (1 Reply)
Discussion started by: Dagaswolf
1 Replies
7. Shell Programming and Scripting
Hey,
Does anyone know why my Perl script is hanging when i execute it.
print "looking around ...\n";
my ($out, $err, $exit) = $scon->cmd('ls');
print "done";
i get the following error:
channel 1: open confirm rwindow 131043 rmax 32768
I'm using use Net::SSH::W32Perl Module.... (4 Replies)
Discussion started by: Phi01
4 Replies
8. UNIX for Dummies Questions & Answers
Hi guys,
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies
9. Shell Programming and Scripting
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies
10. UNIX for Beginners Questions & Answers
We are using a korn shell script which is meant to trigger a Oracle job to load the data from a flat file to an Oracle database . Also the same script addresses the following tasks also like triggering a SFTP job to pick the file from one path to the target location and checking the same with... (6 Replies)
Discussion started by: senmng
6 Replies
LEARN ABOUT DEBIAN
use
USE(1) User Commands USE(1) NAME
use - Frontend to the Usepackage Environment Manager SYNOPSIS
csh and derivatives: source /usr/share/usepackage/use.csh bourne shell and derivatives: source /usr/share/usepackage/use.bsh korn shell: . /usr/share/usepackage/use.ksh use [-vs] [-f file] package ... use -l DESCRIPTION
Usepackage is an environment management program. It is based on the principle of packages - collections of executables that share a common set of necessary environment variables, such as PATH, MANPATH or LD_LIBRARY_PATH. For each given package, use sources the appropriate environment information into the current shell. The environment information is speci- fied in a configuration file, see usepackage(1). OPTIONS -v Output verbose information to the standard error stream. -s Silence warnings for un-matched packages. This is useful in a shell rc script when a package is known not to be available on all architectures that the shell is used on. -f file Specify an alternate initial configuration file. -l List available packages and groups. FILES
/usr/share/usepackage/usepackage.conf The default configuration file. /usr/share/usepackage/use.csh Shell setup for csh and derivatives. /usr/share/usepackage/use.bsh Shell setup for bourne shell and derivatives. /usr/share/usepackage/use.ksh Shell setup for ksh. /usr/bin/usepackage The underlying Usepackage executable. ENVIRONMENT
Other than the reading and re-definition of environment variables for package setup, use also uses the following environment variables for user configuration: PACKAGES_PATH Colon-separated path list giving the directories to search for configuration files. Shell-style tilde (~) user-directory escapes are expanded. HOME If present in the environment, this is used to provide the expansion for the tilde (~) user-directory. SHELL If present in the environment, the last path component of this is used for shell matching (see SYNTAX) and detecting the style of environment output that should be used, see usepackage(1). COPYRIGHT
Usepackage Environment Manager Copyright (C) 1995-2005 Jonathan Hogg This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MER- CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA SEE ALSO
usepackage(1), csh(1), sh(1), ksh(1) Usepackage $Date: 2005/12/11 16:42:09 $ USE(1)