set -A RESULTS Post: 19232

8 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Set shell variables from SQLPLUS query results

Hi All, I needed to get the result of two sqlplus queris into shell variables. After days of looking for the ultimate solution to this problem.. i found this... sqlplus -s USER/PASS@DB <<EOF | awk '{if(NR==1) printf("%s ", $1); if(NR==2) printf("%s ", $1);}' | read VAR1 VAR2 set head off...

2. UNIX for Dummies Questions & Answers

How to set server's ip address, router, network mask and set if it is an internal or external ip?

Hello, I need to write a program which sets server's ip address, router, network mask. Program also should set if it is an internal or external ip. Maybe someone can help me ? Any information from u is very useful :b: I stopped at .. :( #!/bin/sh A=`hostname -i` echo "server ip address is $A"...

3. Shell Programming and Scripting

set Net:SSH:Expect timeout and set it again.

SSHing into a machine can take a few seconds, but after I'm in, the commands return quickly. I was wondering if the timeout setting can be changed once I'm logged into the machine. Does anyone know if this can be set on the fly? The problem here is, if I have to set timeout = 10, it'll take 10...

4. UNIX for Dummies Questions & Answers

SET produces different results in a script?

Hi all, So wondering if anyone has ever come across this... I know if you run SET command you can see a listing of all your shell variables. HOWEVER, if you create a script in vi, and in that script you issue a set command, it does not return the variables when you run the file after making...

5. Shell Programming and Scripting

Can ctag and cscope support recording search results and displaying the history results ?

Hello , When using vim, can ctag and cscope support recording search results and displaying the history results ? Once I jump to one tag, I can use :tnext to jump to next tag, but how can I display the preview search result?

6. Solaris

LC_ALL & LANG are set OK, but others couldn't set locale correctly.

Hi, I have a Solaris (SunOS 5.10) installed, by default with the en_AU.UTF-8 locale. I want to change it to en_US.UTF-8 With AU, I have no issues whatsoever, so I installed the language package and now locale -a shows "en_US.UTF-8". Problem is even with LC_ALL set in etc/default/init, the...

7. Shell Programming and Scripting

Help needed with shell script to search and replace a set of strings among the set of files

Hi, I am looking for a shell script which serves the below purpose. Please find below the algorithm for the same and any help on this would be highly appreciated. 1)set of strings need to be replaced among set of files(directory may contain different types of files) 2)It should search for...

8. Shell Programming and Scripting

I want to add a variable for the results from the formula of one variable and results of another var

Good morning all, This is the file name in question OD_Orders_2019-02-19.csv I am trying to create a bash script to read into files with yesterdays date on the file name while retaining the rest of the files name. I would like for $y to equal, the name of the file with a formula output with...

LEARN ABOUT DEBIAN

cvm-sql

cvm-sql(7)						 Miscellaneous Information Manual						cvm-sql(7)

NAME

       cvm-sql - CVM SQL Framework

QUERY SUBSTITUTION

       $VAR  and  ${VAR} are replaced with the quoted value of the environment variable named VAR.  Use the second form when VAR contains anything
       other than alpha-numeric or underscore (_) characters.  Do not include quotes in the query.  The variables account and domain  contain  the
       account and domain names given by the CVM client.  $$ is replaced with a single dollar sign.

QUERY RESULTS

       The query must produce the following fields exactly in order.  All required fields must not be null or empty.

       1.     Password, encrypted with crypt(3) (required)

       2.     Actual account name (required)

       3.     User ID (integer) (required)

       4.     Group ID (integer) (required)

       5.     Directory (required)

       6.     Real name (optional)

       7.     Login shell (optional)

       8.     Group name (optional)

       9.     Domain name (optional)

       10.    System account name (optional)

       11.    System account directory (optional)

       12.    Mailbox path (optional)

DEFAULT QUERY

       SELECT  password, username, userid, groupid, directory, realname, shell, groupname, domain, sys_username, sys_directory FROM accounts WHERE
       username=$account AND domain=$domain

SEE ALSO

       cvm-mysql(8), 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/cvm/cvm.html

																	cvm-sql(7)