FBSQL_SELECT_DB(3) 1 FBSQL_SELECT_DB(3)fbsql_select_db - Select a FrontBase databaseSYNOPSIS
bool fbsql_select_db ([string $database_name], [resource $link_identifier])
DESCRIPTION
Sets the current active database on the given link identifier.
The client contacts FBExec to obtain the port number to use for the connection to the database. If the database name is a number the sys-
tem will use that as a port number and it will not ask FBExec for the port number. The FrontBase server can be stared as FRontBase
-FBExec=No -port=<port number> <database name>.
Every subsequent call to fbsql_query(3) will be made on the active database.
PARAMETERS
o $database_name
- The name of the database to be selected. If the database is protected with a database password, the you must call fbsql_data-
base_password(3) before selecting the database.
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 TRUE on success or FALSE on failure.
SEE ALSO fbsql_connect(3), fbsql_pconnect(3), fbsql_database_password(3), fbsql_query(3).
PHP Documentation Group FBSQL_SELECT_DB(3)
Check Out this Related Man Page
FBSQL_DB_STATUS(3) 1 FBSQL_DB_STATUS(3)fbsql_db_status - Get the status for a given databaseSYNOPSIS
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)
Hello every one.
I work in a LAN with many application server.
Each one use a different port.
What command permit to obtain the number of these port.
thanks (2 Replies)
hey guys! I know this one is simple since you are the gurus. To make a long story short can i install an oracle database on a unix server and link to that server with a asystem that was written in Visual Basic 6?
Please help (1 Reply)
how can we connect to database(psql) using c language?.
Any one help.Pls say the hader file and function's avilable in C for database operation(like connecting,selecting,etc...). (3 Replies)
Hi,
We are using oracle 10g in a Solaris box. The same box has Informatica also installed. But it runs on port 6001. But whenever the server is restarted the Oracle database picks up the port 6001 and does not allow Informatica to be started. But I am have no clue of which Oracle process is... (2 Replies)
I don't know if this is better suited for the application section, but here goes.
We are currently running HP-UX 11 as our database server. The database is Progress version 9.1C.
As of late, some of our batch processes that run on the UNIX db server are erroring out because of what appear to... (3 Replies)
Hi Guys,
I have a database server where we run AIX 5.3 on a power5 box and we just turned on CIO (concurrent I/O) for the database filesystems. Now my assumption is that enabling CIO the database basically will bypass the filesystem cache releasing some extra memory that can be allocated... (1 Reply)
Hi Guys,
I have a database server where we run AIX 5.3 on a power5 box and we just turned on CIO (concurrent I/O) for the database filesystems. Now my assumption is that enabling CIO the database basically will bypass the filesystem cache releasing some extra memory that can be allocated... (1 Reply)
I hope I'm posting this in the correct section.
I'm trying to move a database from one server to another. This is the code I'm using...
tar czf - vbdatabase.sql | ssh username@full.domain.com 'cat > /home/cpanelusername/vbdatabase.tar.gz
... but all I'm getting is a ">" and then nothing... (4 Replies)
I'm putting my club's membership database online.
I have a Member table in the database with fields such as FirstName, LastName etc. I have a web form with matching input variables Member_FirstName, Member_LastName that's going to be used for inserting a new member into the database, so I'll be... (2 Replies)
hello all, i am trying to find a better to do what i am doing right now...
i have a file called sidlist...which has my database_name and password to the respective database
so something like below.. file is called sidlist and entry is below...
test, abc123
kes12, abcd12
pss, abcd1234... (5 Replies)
Good afternoon
i need your help, i am new at unix, in a ETL scenario like datastage is , there are a bunch of procesess (script shells) conecting to hetereogenius database source servers in order to extract information.
Ive got 2 questions
1. Using unix how can i identify exactly the... (1 Reply)
I have a java process running on serverA on port 9200
It connects & communicates with the database on serverB port 4222.
Earlier I had not enabled encryption between them but now I have specified the java process on serverA to encryption communication by specifying the following on the java... (1 Reply)