Hi
I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this.
1. Opened a cursor to a table in DB2 databse.
2. Fetching individual rows with the help of cursor.
3. Each row has 4 fields.
I want each of the field in individual shell... (1 Reply)
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
I want to perform few post-session success tasks like update a status to 'true' in one of the sql database table, update date values to current system date in one of the configuration table in sql. How do i achieve this in a post session command?syntax with example will be helpful. (3 Replies)
Hi,
I have basic knowledge on how to write pl/sql code inside shell script.
I am looking for more advance thing. Is there any book for that which can just talk about how to write more advance plsql code inside shell script.
Please help
Thanks!!!!!! (1 Reply)
I need to compare a R$Timestamp field sql within a Unix Shell Script.
In straight SQL the following code works fine:
Table Name: LL_UNIT_TRANSACTION UT
Field: R$Timestamp
Where TRUNC(UT.R$Timestamp) >= TRUNC(SYSDATE -7)
the following returns no data within the Unix Shell Script... (2 Replies)
Hi all
I am writing a shell script which will run a select query from a table . If the ouput is not 500 - then send a email to the team saying there is a error . But i am not sure how to redirect this output of the select query to the log file -
#!/bin/ksh
sqlplus /nolog
conect... (1 Reply)
Hi all,
$ echo $SHELL
/bin/bash
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
Shell Script
$ cat output.sh
#!/bin/bash
.... (7 Replies)
I know this question is out there in many forums, but I tried all the combinations in vain.
I'm basically trying to call a sql script from a shell script.
Below is my sql script (plsql.sql)
DELCARE
v_empno NUMBER := '&empno';
BEGIN
select ename,sal from emp where empno = v_empno;... (3 Replies)
Discussion started by: FName_LName
3 Replies
LEARN ABOUT DEBIAN
eurephiadm-users
eurephiadm users(7) eurephiadm users(7)NAME
eurephiadm-users - User management module
SYNOPSIS
eurephiadm users --list|-l [-S|--sort <sort keys>]
eurephiadm users --show|-s [-i|--uid <user id>] [-u|--username <user name>] [-l|-|-lastlog] [-L|--lastlog-details] [-a|--attempts]
[-b|--blacklist]
eurephiadm users --activate|-a [-i|--uid <user id>] [-u|--username <user name>]
eurephiadm users --deactivate|-d [-i|--uid <user id>] [-u|--username <user name>]
eurephiadm users --add|-A [-u|--username <user name>] [-P|--password <plain text password>] [-C|--certid <certificate ID>] [-D|--digest
<certificate SHA1 digest>] [-c|--certfile <certificate file>] [-2|--pkcs12]
eurephiadm users --delete|-D [-i|--uid <user id>] [-u|--username <user name>]
eurephiadm users --password|-p [-i|--uid <user id>] [-u|--username <user name>]
eurephiadm users [-h|--help [<mode>]]
DESCRIPTION
eurephiadm users manages eurephia user accounts. It provides an interface for listing, creating new, modify and delete user accounts.
MODES
Available modes:
-l | --list
[-S|--sort <sort keys>]
List all user accounts. Providing -S|--sort and a sort key will define the sort order of the list. Valid sort keys are:
uid - user ID
username - User name belonging to the user account
activated - When the user account was activated
deactivated - When the user account was deactivated
lastaccess - When the user account was last used
-s | --show
[-i|--uid <user id>] [-u|--username <user name>] [-l|--lastlog] [-L|--lastlog-details] [-a|--attempts] [-b|--blacklist]
Show user account details. --uid or --username are required. The other arguments only defined which kind of information to show.
-a | --activate
[-i|--uid <user id>] [-u|--username <user name>]
Activate a user account. --uid or --username is required.
-d | --deactivate
[-i|--uid <user id>] [-u|--username <user name>]
Deactivate a user account. --uid or --username is required.
-A | --add
[-u|--username <user name>] [-P|--password <plain text password>] [-C|--certid <certificate ID>] [-D|--digest <certificate SHA1
digest>] [-c|--certfile <certificate file>] [-2|--pkcs12]
Add a new user account. --username is required. If you want to assign a password for the new user account via the command line,
provide the password with --password.
To associate this user account against an already regstistered certificate, it can be done by either refering to the certificate ID
in eurephia using --certid or providing the certificate SHA1 digest/fingerprint to --digest.
A brand new certificate can be registered and linked to the user account directly if you have access to the certificate file. The
file can be in either PEM/DER format or PKCS#12. Use --certfile to indicate the certificate file to extract the information from
and --pkcs12 if it is a PKCS#12 file.
-D | --delete
[-i|--uid <user id>] [-u|--username <user name>]
Delete a user account. --uid or --username is required.
-p | --password
[-i|--uid <user id>] [-u|--username <user name>]
Change password on a user account. --uid or --username is required.
-h | --help
[<mode>]
Show a help screen. Without any arguments, all modes are listed. Providing a mode will show more information about the chosen
mode.
SEE ALSO eurephiadm(7), eurephiadm-certs(7)AUTHOR
Copyright (C) 2008-2010 David Sommerseth <dazo@users.sourceforge.net>
David Sommerseth July 2010 eurephiadm users(7)