10 More Discussions You Might Find Interesting
1. Emergency UNIX and Linux Support
Hi,
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
... (1 Reply)
Discussion started by: maverick_here
1 Replies
2. Shell Programming and Scripting
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
3. Shell Programming and Scripting
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)
Discussion started by: JerryHone
1 Replies
4. Shell Programming and Scripting
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)
Discussion started by: Deei
1 Replies
5. AIX
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)
Discussion started by: muzahed
4 Replies
6. Shell Programming and Scripting
I am trying this
>$ /usr/sybase/bin/isql -UABC -Pdef -SXYZ -b
Getting the following error.
Help is appreciated (1 Reply)
Discussion started by: pinnacle
1 Replies
7. Windows & DOS: Issues & Discussions
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)
Discussion started by: danin
3 Replies
8. Ubuntu
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)
Discussion started by: siba.s.nayak
0 Replies
9. Shell Programming and Scripting
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)
Discussion started by: melanie_pfefer
1 Replies
10. Solaris
Dear All
I have a problem that I can't connect from VB to Sybase 11.
Could you help me? (2 Replies)
Discussion started by: Than Chanroeun
2 Replies
SYBASE_UNBUFFERED_QUERY(3) SYBASE_UNBUFFERED_QUERY(3)
sybase_unbuffered_query - Send a Sybase query and do not block
SYNOPSIS
resource sybase_unbuffered_query (string $query, resource $link_identifier, [bool $store_result])
DESCRIPTION
sybase_unbuffered_query(3) sends a query to the currently active database on the server that's associated with the specified link identi-
fier. If the link identifier isn't specified, the last opened link is assumed. If no link is open, the function tries to establish a link
as if sybase_connect(3) was called, and use it.
Unlike sybase_query(3), sybase_unbuffered_query(3) reads only the first row of the result set. sybase_fetch_array(3) and similar function
read more rows as needed. sybase_data_seek(3) reads up to the target row. The behavior may produce better performance for large result
sets.
sybase_num_rows(3) will only return the correct number of rows if all result sets have been read. To Sybase, the number of rows is not
known and is therefore computed by the client implementation.
Note
If you don't read all of the resultsets prior to executing the next query, PHP will raise a warning and cancel all of the pending
results. To get rid of this, use sybase_free_result(3) which will cancel pending results of an unbuffered query.
PARAMETERS
o $query
-
o $link_identifier
-
o $store_result
- The optional $store_result can be FALSE to indicate the resultsets shouldn't be fetched into memory, thus minimizing memory
usage which is particularly interesting with very large resultsets.
RETURN VALUES
Returns a positive Sybase result identifier on success, or FALSE on error.
EXAMPLES
Example #1
sybase_unbuffered_query(3) example
<?php
$dbh = sybase_connect('SYBASE', '', '');
$q = sybase_unbuffered_query('select firstname, lastname from huge_table', $dbh, false);
sybase_data_seek($q, 10000);
$i = 0;
while ($row = sybase_fetch_row($q)) {
echo $row[0], ' ', $row[1], '<br />';
if ($i++ > 40000) {
break;
}
}
sybase_free_result($q);
sybase_close($dbh);
?>
NOTES
Note
This function is only available when using the CT library interface to Sybase, and not with the DB library.
SEE ALSO
sybase_query(3).
PHP Documentation Group SYBASE_UNBUFFERED_QUERY(3)
