Shell Script: want to insert values in database when update script runs Post: 302142193

10 More Discussions You Might Find Interesting

1. Solaris

Sunsolaris shell script runs only as super user

Hi Friends, I am new to Sun solaris unix.I am facing problem while runing my kornshell script just as an ordinary user.The script works fine while i am working as a super user.the script just uses awk to check the first charcter of a file and then copies the file to another folder. Do i...

2. Shell Programming and Scripting

Shell script which runs sql script

Hi all, I need a shell script which runs a sql script but I couldn't find how to finish it. This is the code that I have: #! /usr/bin/ksh export SHELL=/bin/ksh export ORACLE_SID=database export ORACLE_HOME=/opt/oracle/product/9.2.0.8 sqlplus user <<EOF @/path/path/path/scriptname.sql...

3. Shell Programming and Scripting

insert values into sqlplus database using shell script

hello all, I am new to shell scripting and to unix... so the following is my assignment.. here i am trying to insert a values into sqlplus database using shell script. the following is my shell script InsertDelete.sh #! /bin/sh echo "*********The MENU******** 1.Insert The Values...

4. Shell Programming and Scripting

shell script to insert data from gps.txt to mysql database

Hi, I have gps receiver, by using gpsd data i can read gps log data to my database(my sql). Steps: 1. telenet localhost 2947 > gps.txt (press enter) 2. r (press enter) //then i will get the data like below in gps.txt file Trying 127.0.0.1... Connected to localhost....

5. Shell Programming and Scripting

Shell script that runs a random shell script

Hi, im trying to make a shell script that basically runs a random shell script form a list of shell scripts i specify. Im not very good at writing shell scripts, and am new to linux. Thanks in advance :)

6. Shell Programming and Scripting

Korn shell program to parse CSV text file and insert values into Oracle database

Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database. I need to write the korn shell program on Red Hat Enterprise Linux server. Oracle database is 10g.

7. AIX

Script runs in shell but not cron

We run some menu driven software that has the ability to batch menu paths and generate reports quickly. Normally you run a batch like: $ BATCH BATCHNAME The batch program then prompts you for the date you want the report run for. I got some help from some folks on IRC to do the following: BATCH...

8. Shell Programming and Scripting

Shell script for insert multiple records into a Database

I have a table in an Informix DB into which I want to insert multiple records at a time. Data for one of the column should be unique & other column data may be the same for all the records I insert Typical Insert Statement I use to insert one row : insert into employee(empid, country, state)...

9. Shell Programming and Scripting

Need help on Insert data to phpMyAdmin mySQL database from Shell Script

Sorry to disturb you, I would like to seek help on inserting data whenever the switch is on or off to my phpMyAdmin mySQL database from my Shell Script. I'm using Raspberry PI as my hardware and I have follow this LINK: instructables.com/id/Web-Control-of-Raspberry-Pi-GPIO/?ALLSTEPS to create my...

10. Shell Programming and Scripting

Intelligent Script to Insert Records in Database Table

Hello All Members, I am new to this forum and to the shell scripting. I want to write a shell script to do the following: Scenario: I have a pipe delimited .txt file with multiple fields in it. The very first row of the file contains the name of the column which resembles the name of the...

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)

10 More Discussions You Might Find Interesting

1. Solaris

Sunsolaris shell script runs only as super user

Discussion started by: gjithin

2. Shell Programming and Scripting

Shell script which runs sql script

Discussion started by: Geller

3. Shell Programming and Scripting

insert values into sqlplus database using shell script

Discussion started by: pradeept

4. Shell Programming and Scripting

shell script to insert data from gps.txt to mysql database

Discussion started by: gudivada213