help with script Post: 302161413

Sponsored Content

Top Forums Shell Programming and Scripting help with script Post 302161413 by kkcarlton on Thursday 24th of January 2008 12:15:05 PM

01-24-2008

Registered User

help with script

Hi,

I am completley new to Unix and shell scripts. I need to write a script that does the following:

selects 2 values from a table on an oracle database (directory structure)
ftps a .csv file from a Win server to a Unix server (directories from above sql)
changes directory
uses a utility called mload to upload data

I know how to write the select statement but do I write it in my script or do I write a separate sql script that I call from my shell script? if so, how do I pass the values I retrieve from the database back to the calling shell script.

I am also unclear on how to use ftp in my script to ftp the csv file.

The rest I know how to do.

If someone could give me some hints, point me in the right direction, or point me to some samples, I would greatly appreciate it.

thanks,
KKC

kkcarlton

View Public Profile for kkcarlton

Find all posts by kkcarlton

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

create a shell script that calls another script and and an awk script

Hi guys I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file. #!/bin/sh echo " $2 $3 $4 $5 $6 $7 isql -w400 -U$2 -S$5 -P$3 << xxx use $4 go print"**Changes to the table...

2. Shell Programming and Scripting

Script will keep checking running status of another script and also restart called script at night

I am using blow script :-- #!/bin/bash FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not if then # echo "process found" exit 0; else echo "process not found" exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ...

3. UNIX for Dummies Questions & Answers

Calling a script from master script to get value from called script

I am trying to call a script(callingscript.sh) from a master script(masterscript.sh) to get string type value from calling script to master script. I have used scripts mentioned below. #masterscript.sh ./callingscript.sh echo $fileExist #callingscript.sh echo "The script is called"...

4. Shell Programming and Scripting

Shell script works fine as a standalone script but not as part of a bigger script

Hello all, I am facing a weird issue while executing a code below - #!/bin/bash cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset sh UKBA_publish.sh UKBA 28082015 3 if then echo "Param file conversion for all the areas are completed, please check in your home directory"...

5. Shell Programming and Scripting

How to block first bash script until second bash script script launches web server/site?

I'm new to utilities like socat and netcat and I'm not clear if they will do what I need. I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes. I'm using Cygwin bash on Windows 10. My...

LEARN ABOUT DEBIAN

ipescript

IPESCRIPT(1)						      General Commands Manual						      IPESCRIPT(1)

NAME

       ipescript - Run an Ipe script (written in Lua)

SYNOPSIS

       ipescript script { arguments }

DESCRIPTION

       ipescript  runs	an Ipe script written in Lua.  The Ipe bindings are automatically available in the script.  Ipescript looks for the script
       in any of the script directories.

       The script argument should not contain the .lua extension.

ENVIRONMENT VARIABLES

       ipescript respects the following environment variables:

       IPELATEXDIR
	      the directory where ipetoipe runs Pdflatex.

       IPESCRIPTS a list of directories where Ipescript will look for
	      scripts.	When this variable is not set, Ipe searches first the current directory, then ~/.ipe/scripts, and finally the  system-wide
	      Ipe script directory.  When this variable is set, it should contain a list of directories, separated by semicolons.  A single under-
	      score is replaced by the system-wide Ipe script directory.

       IPEDEBUG
	      set this to 1 for debugging output from ipescript.

AUTHOR

       Otfried Cheong

REPORTING BUGS

       Please report bugs using Ipe bugzilla at http://ipe7.sourceforge.net/bugzilla.html

SEE ALSO

       Ipe is documented fully in The Ipe Manual, which is available online at http://ipe7.sourceforge.net/manual/manual.html .

								  August 28, 2011						      IPESCRIPT(1)