07-07-2010
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I know htis isnt exactly unix.... but hopefully someone can help me or direct me someplace to get help.
I can run sql queries in scripts against my informix db using:
dbaccess mydb myquery.sql >> sql.output
I need to write my script to select based on todays date. Its very... (5 Replies)
Discussion started by: MizzGail
5 Replies
2. Shell Programming and Scripting
Hi,
I need to get the value from the table using the sql command and store this value into the unix variable so that i can use this value for furthure use..
Please can any body help me in this regards
Thanks & Regards
Abdul Hafeez Shaik (17 Replies)
Discussion started by: abdulhafeez
17 Replies
3. Shell Programming and Scripting
Hi All
I have a requirement where in I am stuck. There is a shell script that is being developed by me. It consist of the sql stmt also. I need to export a variable called HOMEPAGE with a value say www.abc.com. and then use this $HOMEPAGE variable in the sql stmt. My ultimate aim is to fetch all... (1 Reply)
Discussion started by: amitsinha
1 Replies
4. Shell Programming and Scripting
Hi Guys,
I am trying to pass a string variable from Unix shell script to sqlplus as a parameter.
I have tried using single quotes with the variable name but it does not work. Please help me with it.
I am using BASH.
My code:
Your help is much appreciated.
Thanks,
shil (2 Replies)
Discussion started by: infintenumbers
2 Replies
5. Shell Programming and Scripting
Hi,
I have a requirement to store oracle sqlplus output to some unix variable, count the records and then print the output on the screen.
Can you please point me to any sample program for reference purpose.
Thanks a lot for your time. (0 Replies)
Discussion started by: bhupinder08
0 Replies
6. Shell Programming and Scripting
The following is my script :
#!/bin/bash
echo "please give app_instance_id"
read app_instance_id
echo "id is $app_instance_id"
export app_id=app_instance_id
sqlplus -s nnviewer/lookup@//nasolora008.enterprisenet.org:1521/LOAD3 @test.sql<<EOF
SPOOL /home/tibco/MCH/Data/qa/raak/name.xls... (4 Replies)
Discussion started by: raakeshr
4 Replies
7. Shell Programming and Scripting
I have a sql statement , i need to assign to a variable in Unix
sel count(*) AS num_files from TABLE_A;
i need to use "num_files" in unix statements. let me know how to assign unix variable to above num_files (1 Reply)
Discussion started by: nani1984
1 Replies
8. Shell Programming and Scripting
Hi
I am new to UNIX. I am trying the below and getting the error.
I am trying to assign the variable with the value of the query result. I want this value to use in the next steps.
Created UNIX file (Batch.sh) as below
#!/bin/ksh
sqlplus callidus/callidus4u@attstcal @Batch.sql
... (2 Replies)
Discussion started by: KrishBalu
2 Replies
9. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I am trying to extend unix variable value with mysql resultset. It's working fine in terminal but not working in shell script.
#!/bin/bash
export prcs_nm=$1
export tbl_nm=$2
export rslt=$(
mysql -sN -u root -proot123 -e "
select sql_query
from retail_db.config where prcs_nm =... (3 Replies)
Discussion started by: Prasad
3 Replies
LDBDEL(1) User Commands LDBDEL(1)
NAME
ldbdel - Command-line program for deleting LDB records
SYNOPSIS
ldbdel [-h] [-H LDB-URL] [dn] [...]
DESCRIPTION
ldbdel deletes records from an ldb(7) database. It deletes the records identified by the dn's specified on the command-line.
ldbdel uses either the database that is specified with the -H option or the database specified by the LDB_URL environment variable.
OPTIONS
-h
Show list of available options.
-H <ldb-url>
LDB URL to connect to. See ldb(7) for details.
ENVIRONMENT
LDB_URL
LDB URL to connect to (can be overrided by using the -H command-line option.)
VERSION
This man page is correct for version 4.0 of the Samba suite.
SEE ALSO
ldb(7), ldbmodify, ldbadd, ldif(5)
AUTHOR
ldb was written by Andrew Tridgell.
If you wish to report a problem or make a suggestion then please see the : http://ldb.samba.org/ web site for current contact and
maintainer information.
ldbdel was written by Andrew Tridgell.
This manpage was written by Jelmer Vernooij.
Samba 3.5 06/18/2010 LDBDEL(1)