I'm facing an emergency situation, wherein I have to provide limited support to a Sybase DB temporarily as the DBA was fired. There is an urgent need of adding to users to the database. After some time on google, I was able to gather the below information on the database setup
I need to add a two users one similar to ascent_app and another similar to webascent. I have NO knowledge of sybase. Any help would be highly appreciated.
I am writing a shell script that verifies if a device is created on wrong mounts
1> sp_helpdevice
2> go | awk '{print $2}' | grep database | grep -v `df -k | grep /dev/dsk | awk '{print $6}'`
So if things are ok, the output should return nothing
If the result gives 1 or more entry, then... (1 Reply)
Hi,
Can any one please suggest me which version of Sybase 15.x I need to dowload for installing on my laptop(Dell Inspiron 1525) having Ubuntu8.1?
Thanks & Regards,
Siba Sankar Nayak (0 Replies)
hi,
I'd like to connect to a Sybase ASE 12 through a a graphic user interface (GUI) that run on windows and solaris10, because i need to do some querys.
The database is running on solaris 10.
I'm not an expert using databases, but i know how to use some SQL commands through command line... (3 Replies)
Hi,
How do i check if Sybase is installed on aix..The sybase guy is doing remote installation and i need to check if he has installed sybase or not.
ive tried the following approaches.
#lslpp -L "*Sybase*" # tried other strings like "*ybase*" , "*base*"
#lslpp -ha |grep syb # tried... (4 Replies)
I am trying to bcp in using sybase::bcp perl module. I can find we can give user, pwd and server name in the parameters.
How can I give database and table name? (1 Reply)
This is more a database problem than a shell one, but we have a problem affecting our scripts, so I'm stretching the limits a bit! ;)
We're in the process of migrating our application and a large number of associated scripts from Sybase 12.5.4 to Sybase 15. Scripts using 'isql' and 'bcp' include... (1 Reply)
I have requirement to connect to different sybase server's and store the data into flat file and load into oracle using sqlloader
for each day drop the table and re create it and load the data based on business date as parameter which was taking from parameter file.Any help on this should be... (0 Replies)
Discussion started by: mohan705
0 Replies
LEARN ABOUT PHP
mssql_fetch_object
MSSQL_FETCH_OBJECT(3)MSSQL_FETCH_OBJECT(3)mssql_fetch_object - Fetch row as objectSYNOPSIS
object mssql_fetch_object (resource $result)
DESCRIPTION mssql_fetch_object(3) is similar to mssql_fetch_array(3), with one difference - an object is returned, instead of an array. Indirectly,
that means that you can only access the data by the field names, and not by their offsets (numbers are illegal property names).
Speed-wise, the function is identical to mssql_fetch_array(3), and almost as quick as mssql_fetch_row(3) (the difference is insignifi-
cant).
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
RETURN VALUES
Returns an object with properties that correspond to the fetched row, or FALSE if there are no more rows.
EXAMPLES
Example #1
mssql_fetch_object(3) example
<?php
// Send a select query to MSSQL
$query = mssql_query('SELECT [username], [name] FROM [php].[dbo].[userlist]');
// Check if there were any records
if (!mssql_num_rows($query)) {
echo 'No records found';
} else {
// Print a nice list of users in the format of:
// * name (username)
echo '<ul>';
while ($row = mssql_fetch_object($query)) {
echo '<li>' . $row->name . ' (' . $row->username . ')</li>';
}
echo '</ul>';
}
// Free the query result
mssql_free_result($query);
?>
NOTES
Note
Field names returned by this function are case-sensitive.
Note
This function sets NULL fields to the PHP NULL value.
SEE ALSO mssql_fetch_array(3), mssql_fetch_row(3).
PHP Documentation Group MSSQL_FETCH_OBJECT(3)