UNIX sql options Post: 302844073

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Unix Path Options

I am looking for the best way to move files into a directory (ie PDF_files), if the directory doesn't exist to create it. However I am passing the full filename (psfile) of the file so I will have to remove the filename from the end, which can be at different field end lengths. This is a...

2. Shell Programming and Scripting

unix variables from sql / pl/sql

How do I dynamically assign the below output to unix shell variables so I can build a menu in a shell script? Example: var1 = 1 var2= SYSTEM var3 = 2 var4= UNDOTBS1 and so on, then in the shell script I can use the variables to build a menu. set serveroutput on declare...

3. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

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...

4. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s...

5. UNIX for Dummies Questions & Answers

Unix : About options of clear command ?

Hello everyone, My question is quite simple, even if I didn't find an answer. I would want a command (maybe clear with some options ?) that can do the following : clear completely the console, as it is when we start a console for the first time. My problem is that I sometimes display a lot...

6. UNIX for Dummies Questions & Answers

What are the career options in unix apart from unix system administration?

7. Shell Programming and Scripting

Format options while Redirecting output of sql to a file in shell

In my korn shell - I have a sql with say 6 columns whose output i am redirecting to a file and attaching this file while sending a mail. While all this happens correctly, i face issues in the format of this file. my intended output is Column_1 Column_2 Column_3 Column_4 ...

8. UNIX for Dummies Questions & Answers

UNIX ls options

Hi Guys I'm new to the forums and Unix. I have my first assignment for school and i'm stuck on question 1 spent close to 4 hours on it :(. (doesn't look good). I looked the the online documentation of ls but don't really understand it yet. I need to find files whose names that are of length...

9. Shell Programming and Scripting

UNIX Date function with -d options

Hi , I couldn't understand how this program works. Can somebody please explain it to me. DT=`date -d "1 day"` # This part I understand echo ${DT/ */} # How this works echo ${DT/* /}

LEARN ABOUT DEBIAN

ipcheck

IPCHECK(8)						  System Administration Utilities						IPCHECK(8)

NAME

       ipcheck - dyndns.org client

DESCRIPTION

       Usage  : ipcheck.py [options] Username Password Hostnames or	  ipcheck.py [options] --acctfile acct_info_file

       Options: -a address     manually specify the address

       -r URL NAT router, use web IP detection

       -A text
	      scan syslog for an IP after text (Unix only)

       -F filename
	      guess the WAN IP from a firewall log

       -b     backup mx option ON (default OFF)

       -c     custom dns option (default dynamic)

       -d dir directory for data files (default current)

       -e script
	      execute script after a successful update

       -f     force update regardless of current state

       -g     NAT router, let dyndns guess your IP (do not use this in a cronjob, try -r)

       -h     print this help text

       --help print all available help text

       -i interface
	      interface for local address (default ppp0)

       -j     disable https

       -l     log debugging text to ipcheck.log file

       --syslog
	      log debugging text to syslog (Unix only)

       -m mxhost
	      mx host (default NOCHG)

       -o     set dyndns offline mode

       -p     proxy bypass on port 8245

       -q     quiet mode (unless there is an error)

       -s     static dns option (default dynamic)

       -t     test run, do not send the update

       -v     verbose mode

       -w     wildcard mode ON (default OFF)

       --makedat
	      create the ipcheck.dat file by dns lookup

       --devices
	      print router options (Linksys, Netgear, etc)

       -n ip  the router IP address on the internal lan

       For  help  with different options: python ipcheck.py -h For supported devices listing  : python ipcheck.py --devices For long detailed help
       text    : python ipcheck.py --help

       Make sure you can write to the current directory for data files and that you always run from the same directory.  The first  time  you  run
       the  script,  you will be asked to run with the --makedat option in addition to any other options.  This will create the data files for the
       hostnames and options your specify on the command line.	You should only do this once.  Subsequent runs should be made without the  --make-
       dat option.

       For  help  with different options: python ipcheck.py -h For supported devices listing  : python ipcheck.py --devices For long detailed help
       text    : python ipcheck.py --help

       Example 1: the external IP is on eth0 of the current machine python ipcheck.py -l -i eth0 username password hostnames

       Example 2: you are using the Linksys routing device python ipcheck.py -l -L linksyspassword username password hostnames

       Example 3: you want to use web based ip detection python ipcheck.py -l -r checkip.dyndns.org:8245 ...

       where ... is your dyndns username password and hostnames.  Hostnames should be comma delimited if there are more than one.

Debian GNU/Linux						   January 2012 							IPCHECK(8)