|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
can a shell script interact with database?
Post 302128334 by srikanthus2002 on Tuesday 24th of July 2007 07:16:08 AM
07-24-2007
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I am new to linux and also also to shell scripting.
I have one shell script which unpacks .tgz file and install software on machine.
When this script runs I want to insert id,filename,description(which will be in readme file),log(which will be in log file) and name of unpacked folder... (1 Reply)
Discussion started by: ring
1 Replies
2. Shell Programming and Scripting
Hi
when i am calling the shell script with two parameter like id and date it works fine.But the same shell script is call by java application it gives the error as shown below
Thu Jan 8 04:13:22 EST 2009|The Get Segment Process Failed: SP2-0306:
Invalid option.
Usage: CONN where <logon>... (1 Reply)
Discussion started by: ravi214u
1 Replies
3. Shell Programming and Scripting
hi,
I have a script that will logon to a database siebel and do the select query and then get the result in command prompt of unix.Below the script.
#!/bin/ksh
. $HOME/conf/systemProperties/EnvSetup.properties
#set -x
while read i
do
echo $i
connect1=`sqlplus -silent... (1 Reply)
Discussion started by: ali560045
1 Replies
4. Shell Programming and Scripting
Hello all!
I have a C program that runs on a loop, prompting the user for input until it is exited. I want to create a shell script that can run this program and provide input. How can I do this? I have investigated 'expect' and piping to stdin, but haven't had any success. Any help is... (2 Replies)
Discussion started by: radish04
2 Replies
5. Programming
Hi All,
I have to perform some tasks for database maintainace. I am using postgresql on RHEL 4.4.
1) I have to run "vacuumedb" on the database as postgres user.
2) I have to reindex the database as postgres user.
Now i want to write shell script to do these tasks one... (3 Replies)
Discussion started by: ashokkumar.p
3 Replies
6. Shell Programming and Scripting
Hi all,
This is my first ever post to any forum so, dont let this go in vain...........:)
Here is the scenario........
I have logged into the unix where oracle_sid is initialized for some X database in the .profile.
I have a unix script where some sql query which fetches data from X... (3 Replies)
Discussion started by: sachinkl
3 Replies
7. Shell Programming and Scripting
Hi
I'm working on an Expect script that is supposed to log-into a remote server and run some steps and exit. In the script I first spawn a 'ssh' session to the server and then after logging in I 'send' all the necessary steps ( with a '\r' at the end, so that they get automatically executed the... (3 Replies)
Discussion started by: clakkad
3 Replies
8. Programming
Hello,
I am new on PHP scripting .I have shell scripts which I an running currently from linux server but now I want to make a web portal from where I will run all my scripts but the problem is all my scripts ask for parameters so I am getting confused how could I run my shell script from web... (2 Replies)
Discussion started by: anuragpgtgerman
2 Replies
9. Shell Programming and Scripting
I have a long running ksh script that I need to run with "nohup" in the backgound which is all well and good but at the very start of the script it needes to output to the screen to query the user and accept a response before continuing.
Any thoughts on how to accomplish this other than... (11 Replies)
Discussion started by: twk
11 Replies
10. Shell Programming and Scripting
Hi Guys,
Further to my post yesterday I have got round the issue of not being able to use expect by using one of our unix machines to have the script running instead of the jumpbox itself. However my issue is I now have an extra bit it the script which is shh to the jumpbox which requires a ras... (1 Reply)
Discussion started by: mutley2202
1 Replies
LEARN ABOUT PHP
fbsql_db_status
FBSQL_DB_STATUS(3) 1 FBSQL_DB_STATUS(3) fbsql_db_status - Get the status for a given database SYNOPSIS
int fbsql_db_status (string $database_name, [resource $link_identifier]) DESCRIPTION
Gets the current status of the specified database. PARAMETERS
o $database_name - The database name. o $ link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if fbsql_connect(3) was called with no arguments. RETURN VALUES
Returns an integer value with the current status. This can be one of the following constants: o FALSE - The exec handler for the host was invalid. This error will occur when the $link_identifier connects directly to a database by using a port number. FBExec can be available on the server but no connection has been made for it. o FBSQL_UNKNOWN - The Status is unknown. o FBSQL_STOPPED - The database is not running. Use fbsql_start_db(3) to start the database. o FBSQL_STARTING - The database is starting. o FBSQL_RUNNING - The database is running and can be used to perform SQL operations. o FBSQL_STOPPING - The database is stopping. o FBSQL_NOEXEC - FBExec is not running on the server and it is not possible to get the status of the database. SEE ALSO
fbsql_start_db(3), fbsql_stop_db(3). PHP Documentation Group FBSQL_DB_STATUS(3)