New to ISQL Post: 302910121

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

isql

What does the isql command do for solaris 8???? Is this something that comes with solaris because I have it at work but not at home. Plus does anyone know a good SQL site where I could learn all the sql commands thankx

2. UNIX for Dummies Questions & Answers

regarding isql

can anyone pls explain me the command $ isql -Usa -SIN63DS -Pgoalmal 1>load database STS_IN_PRD from "/STSDBBakup/ AEOD20030509" 2>go thx

3. Shell Programming and Scripting

isql - select ... where ...

Hi, Please help me to solve this problem on Unix isql. Following is an example table and expected select result. I need to select NAMEs where those NAMEs don't have a record which TYPE='T1'. I tried, but got both N2 and N3. NAME TYPE DATA --------------------- N1 T1 D11 N2...

4. Shell Programming and Scripting

isql output

hi all i m running following code # set up environment . /u/pimms/pimms_global.ksh echo "Get record from database" #echo ${PIMMS_ID} #echo ${PIMMS_PWD} #echo "1" isql -U${PIMMD_ID} -P${PIMMS_PWD} -S$SRV << eof > /sybase/applications/pimms/bin/automate1.txt use pimms ...

5. Shell Programming and Scripting

isql out in shell script

Hi I wrote a script for connecting isql(Sybase database) and stored the SQL output in Unix box. my script: isql -U${USER} -P${PASS} -S${SERVER} <<EOF > $WORK_DIR/out1.log go select convert(varchar(10),sdcurrent,101) from pr_sysdate go exit EOF Unfortunately, the output file not...

6. Shell Programming and Scripting

ISQL - SELECT AS

I have been given an SQL script I need to convert to ISQl. In the styatement it has the following line which is flagging an error: Select stocknum as 'bipart' this comes up with: 201: A syntax error has occurred Does ISQL support the SELCT AS statement and if not is there a simple...

7. Shell Programming and Scripting

ISQL syntax

Hi All, I'm niks and i'm a newbie here and newbie in shell, i'm just wondering what is the meaning of -U -P -S in the sample script below. "-U iccbs_dbo -P iccbsdbo -S CCB_REO" Thanks,

8. Shell Programming and Scripting

isql can't read code

Hi Guys, I'm a newbie here can you please help me reading this code. because i'm confuse. select b.field_value, b.cust_ac_no, b.net_svc_id, b.inst_seq_no, b.field_id, b.comp_status, b.inst_status, b.inststdt into bash_temp -- is this...

9. Shell Programming and Scripting

Need Help with isql in Shell Script

Hi Guys, I need help with my code. I am not able to find what the error is (tried debugging and everything). #! /bin/sh # MODSET_CLOSE # Usage: modset_close echo "Enter the Type of Modsets that needs to be Closed: " read mod_typ serv_name=`cat $mod_typ | awk '{ print $1 }'`...

10. Shell Programming and Scripting

Can't log in with -P for isql

Hi all, I am a newbie with isql, so couldn't find what is the problem by myself. I am writing script at Solaris which will log in to DB, run some SELECT queries and put in to some file. The problem is that whe I am trying to log in with: /eniq/sybase_iq/OCS-15_0/bin/isql -U username -P...

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)