Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Query result from shell script
Top Forums Programming Query result from shell script Post 302887995 by rbatte1 on Wednesday 12th of February 2014 06:46:51 AM
Old 02-12-2014
Of course, you should consider that whilst the query is running, the user and password will be there for all to see with a simple ps command. Can you embed them in the code like this:-
Code:
isql -s SYBASE SERVERNAME << EOF
userid/password
USE ***(Database name in Sybase)
@command.sql
EOF

I'm not clear on the exact syntax, but it's to mimic how you would connect for an interactive session from the command line.



I hope that this helps,
Robin
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

passing result of query to a varibale in ksh script

Hi, I have a scenario where in i have to extarct max of one column and pass it to a variable. i have tried to export the result as .dat file and read from that file.But my database is mainframe and it is not permitting me to export in .dat file.I have tried using .ixf file but reading from... (2 Replies)
Discussion started by: ammu
2 Replies

2. Shell Programming and Scripting

How to store query multiple result in shell script variable(Array)

:) Suppose,I have one table A. Table A have one column. Table A have 10 rows. I want this 10 rows store into shell script variable. like #!/bin/ksh v_shell_var=Hi here in call oracle , through loop How can I store table A's 10 rows into v_shell_var (Shell Script Array). Regards, Div (4 Replies)
Discussion started by: div_Neev
4 Replies

3. Shell Programming and Scripting

In a csh script, can I set a variable to the result of an SQLPLUS select query?

Can someone tell me why I'm getting error when I try to run this? #!/bin/csh -f source ~/.cshrc # set SQLPLUS = ${ORACLE_HOME}/bin/sqlplus # set count=`$SQLPLUS -s ${DB_LOGIN} << END select count(1) from put_groups where group_name='PC' and description='EOD_EVENT' and serial_number=1;... (7 Replies)
Discussion started by: gregrobinsonhd
7 Replies

4. Homework & Coursework Questions

A function in shell script,how can i get the right result

there is a directory /data/users/osa/psidp/dmp/files/cimdir ,it have some subdirectories ,and also the subdirectoriy have it's subdirectoriis. I want to get all the leaf nodes of the directory path . but the result of the script is wrong ,how can i get the right result somebody who can help... (1 Reply)
Discussion started by: fw0037
1 Replies

5. Shell Programming and Scripting

A function in shell script,how can i get the right result

there is a directory /data/users/osa/psidp/dmp/files/cimdir ,it have some subdirectories ,and also the subdirectoriy have it's subdirectoriis. I want to get all the leaf nodes of the directory path . but the result of the script is wrong ,how can i get the right result somebody who can help me... (3 Replies)
Discussion started by: fw0037
3 Replies

6. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies

7. Shell Programming and Scripting

How to put db2 query result into an array in shell script?

Hello, Can someone please advise me how to put the db2 query reult into an array? For example, the query reults are: string A string B string C Then how do I put them into array=string A array=string B ... (2 Replies)
Discussion started by: hanul
2 Replies

8. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ... (2 Replies)
Discussion started by: DevendraG
2 Replies

9. Shell Programming and Scripting

Query the table and return values to shell script and search result values from another files.

Hi, I need a shell script, which would search the result values from another files. 1)execute " select column1 from table_name" query on the table. 2)Based on the result, need to be grep from .wft files. could please explain about this.Below is the way i am using. #!/bin/sh... (4 Replies)
Discussion started by: Rami Reddy
4 Replies

10. UNIX for Beginners Questions & Answers

Putting query result dynamically to one cell of table from shell

I have to send a data in mail table format.only one cell need to get dynamically from query. my code is like (echo '<table boarder="1"> echo '<tr><td>stock</td><td>/path</td><td>.........</td></tr>' echo '</table> )sendmail.. in ......... I am trying to get query result.By putting query... (2 Replies)
Discussion started by: meera_123
2 Replies

LEARN ABOUT CENTOS

systemd-ask-password

SYSTEMD-ASK-PASSWORD(1) 				       systemd-ask-password					   SYSTEMD-ASK-PASSWORD(1)

NAME

       systemd-ask-password - Query the user for a system password

SYNOPSIS

       systemd-ask-password [OPTIONS...] [MESSAGE]

DESCRIPTION

       systemd-ask-password may be used to query a system password or passphrase from the user, using a question message specified on the command
       line. When run from a TTY it will query a password on the TTY and print it to STDOUT. When run with no TTY or with --no-tty it will query
       the password system-wide and allow active users to respond via several agents. The latter is only available to privileged processes.

       The purpose of this tool is to query system-wide passwords -- that is passwords not attached to a specific user account. Examples include:
       unlocking encrypted hard disks when they are plugged in or at boot, entering an SSL certificate passphrase for web and VPN servers.

       Existing agents are: a boot-time password agent asking the user for passwords using Plymouth; a boot-time password agent querying the user
       directly on the console; an agent requesting password input via a wall(1) message; an agent suitable for running in a GNOME session; a
       command line agent which can be started temporarily to process queued password requests; a TTY agent that is temporarily spawned during
       systemctl(1) invocations.

       Additional password agents may be implemented according to the systemd Password Agent Specification[1].

       If a password is queried on a TTY, the user may press TAB to hide the asterisks normally shown for each character typed. Pressing Backspace
       as first key achieves the same effect.

OPTIONS

       The following options are understood:

       -h, --help
	   Prints a short help text and exits.

       --icon=
	   Specify an icon name alongside the password query, which may be used in all agents supporting graphical display. The icon name should
	   follow the XDG Icon Naming Specification[2].

       --timeout=
	   Specify the query timeout in seconds. Defaults to 90s. A timeout of 0 waits indefinitely.

       --no-tty
	   Never ask for password on current TTY even if one is available. Always use agent system.

       --accept-cached
	   If passed, accept cached passwords, i.e. passwords previously typed in.

       --multiple
	   When used in conjunction with --accept-cached accept multiple passwords. This will output one password per line.

EXIT STATUS

       On success, 0 is returned, a non-zero failure code otherwise.

SEE ALSO

       systemd(1), systemctl(1), plymouth(8), wall(1)

NOTES

	1. systemd Password Agent Specification
	   http://www.freedesktop.org/wiki/Software/systemd/PasswordAgents

	2. XDG Icon Naming Specification
	   http://standards.freedesktop.org/icon-naming-spec/icon-naming-spec-latest.html

systemd 208														   SYSTEMD-ASK-PASSWORD(1)
All times are GMT -4. The time now is 05:49 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy