08-14-2013
well SAS is not standard unix tools but a powerfull $$ software, I happen to use it in cases where other unix tools fail... (e.g. mainrame files in impossible format containing binary and photos in the file... with file size around 40GB...) I suppose all people using oracle are happy with SQLplus and plSQL..., I suppose you could have a look at what mysql and postgress offer...
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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 Replies)
Discussion started by: Shakey21
2 Replies
2. Shell Programming and Scripting
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... (2 Replies)
Discussion started by: djehres
2 Replies
3. 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
4. Shell Programming and Scripting
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... (2 Replies)
Discussion started by: Nareshp
2 Replies
5. UNIX for Dummies Questions & Answers
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... (5 Replies)
Discussion started by: Ben31400
5 Replies
6. UNIX for Dummies Questions & Answers
What are the career options in unix apart from unix system administration? (2 Replies)
Discussion started by: thulasidharan2k
2 Replies
7. Shell Programming and Scripting
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 ... (7 Replies)
Discussion started by: qwertyu
7 Replies
8. UNIX for Dummies Questions & Answers
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... (1 Reply)
Discussion started by: Stephvai
1 Replies
9. Shell Programming and Scripting
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/* /} (2 Replies)
Discussion started by: LoneRanger
2 Replies
LEARN ABOUT DEBIAN
cvm-mysql
cvm-mysql(8) System Manager's Manual cvm-mysql(8)
NAME
cvm-mysql - MySQL module
SYNOPSIS
cvm-mysql
CREDENTIALS
Pass phrase
DESCRIPTION
This module queries a MySQL database for the account name, compares the stored pass phrase with the given one using crypt(3).
CONFIGURATION VARIABLES
CVM_MYSQL_DEFAULT_FILE
The full path of the defaults file to read if the following variable is set. If not set, the file $HOME/.my.cnf will be read (the
MySQL default).
CVM_MYSQL_DEFAULT_GROUP
If set, the module will read connection default options from the named group in the defaults file as above
CVM_MYSQL_HOST
The hostname or IP of the MySQL server. If not set, a connection to the local host is assumed.
CVM_MYSQL_USER
The MySQL login ID to connect as. If not set, the invoking user is assumed.
CVM_MYSQL_PASS
The password for the above user.
CVM_MYSQL_DB
The database name, must be set.
CVM_MYSQL_PORT
The port number for the TCP/IP connection (only used if the server is not local).
CVM_MYSQL_POSTQ (optional)
The SQL query to execute after the credentials have been validated, see cvm-sql(7).
CVM_MYSQL_PWCMP (optional)
The password comparison module to use.
CVM_MYSQL_SOCKET
The path to the socket that should be used for connections to a local server.
CVM_MYSQL_QUERY (optional)
The SQL query to issue to retrieve the row containing the account information from the database, see cvm-sql(7).
SEE ALSO
cvm-sql(7), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8), cvm-test-
client(8)
http://untroubled.org/pwcmp/pwcmp.html
http://untroubled.org/cvm/cvm.html
cvm-mysql(8)