Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

fbsql_select_db(3) [php man page]

FBSQL_SELECT_DB(3)							 1							FBSQL_SELECT_DB(3)

fbsql_select_db - Select a FrontBase database

SYNOPSIS
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 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)
Man Page

15 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Veritas or Legato??

Hi guys, What product would you suggest for a hot/on-line backup with an active oracle database ?? (6 Replies)
Discussion started by: guest100
6 Replies

2. Cybersecurity

get number of a port

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)
Discussion started by: hoang
2 Replies

3. UNIX for Dummies Questions & Answers

UNIX linked to Windows Urgent

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)
Discussion started by: akrum
1 Replies

4. Programming

database in C

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)
Discussion started by: sabari
3 Replies

5. Solaris

Port used needs to be killed

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)
Discussion started by: chrisanto_2000
2 Replies

6. HP-UX

UNIX memory problems

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)
Discussion started by: eddiej
3 Replies

7. HP-UX

know the size of database

Hi all , How to know the size of a oracle database running in hp-ux server. (1 Reply)
Discussion started by: megh
1 Replies

8. UNIX for Advanced & Expert Users

turning CIO on and how to monitor

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)
Discussion started by: hariza
1 Replies

9. AIX

turning CIO on and how to monitor

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)
Discussion started by: hariza
1 Replies

10. Shell Programming and Scripting

Moving a database from one server to another

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)
Discussion started by: Chimpie
4 Replies

11. Programming

Evaluated variables in PHP

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)
Discussion started by: JerryHone
2 Replies

12. Hardware

Raid 0 on database server

Hi guys. if we want to use SSD drives on a database server, can we use RAID 0 configuration because of their reliability? (3 Replies)
Discussion started by: majid.merkava
3 Replies

13. Shell Programming and Scripting

loop picks up password for 2 entry...how to avoid that ?

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)
Discussion started by: abdul.irfan2
5 Replies

14. UNIX and Linux Applications

Identify server.database connection

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)
Discussion started by: alexcol
1 Replies

15. UNIX for Advanced & Expert Users

Any quick way to determine if the communication is encrypted

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)
Discussion started by: mohtashims
1 Replies