09-26-2016
Thanks Ravinder
But I wanna run in Sybase SQL server using queries .
Can you help on this ?
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I am passing a filename to a script to draw parameters from it. However, I want to use part of the filename as a parameter. The filename is transfer_ccf_3731_10.sh but I only need the 3731_10 part of it.
Is this possible? Any help or suggestions would be appreciated!
Regards,
J. (4 Replies)
Discussion started by: JWilliams
4 Replies
2. Shell Programming and Scripting
Hello
I am currently working on a shell script which actually needs to pull some file
from a server ,
The filenames will have the extension with date/time stamp , i need to trim that and name it to proper format
Example :
xyz_20091108_22142365.gzip
i need to remove the... (5 Replies)
Discussion started by: ranga27
5 Replies
3. UNIX and Linux Applications
i'm looking for an installer of Sybase ASE 11.9.2.6 for HP-UX. tried buying from the local distributor but he can only give me the latest version. can anyone point me to where i could possibly get it? (0 Replies)
Discussion started by: sam_salazar
0 Replies
4. 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
5. Programming
Hi Team -
I am using Sybase ASE 15.7 version. Below query is throwing an error
stating Error : incorrect syntax near the keyword 'OVER'
SELECT
EMPLOYEE_ID ,
EMPLOYEE ,
Department,
CAST( Salary as DECIMAL( 10, 2 ) ) AS Salary
CAST(AVG( Salary) OVER ( PARTITION... (3 Replies)
Discussion started by: Perlbaby
3 Replies
6. Programming
Hi Team ,
I am new to Sybase Adaptive Server Enterprise/15.7 (ASE) and need some guidance to find the different values in serial format column.
SELECT DISTINCT SERIAL_FORMAT FROM PRODUCTS
It has values with below format which contains 12 digits hexadecimal characters with... (2 Replies)
Discussion started by: Perlbaby
2 Replies
7. Programming
Dear Team
I am using Sybase Adaptive Server Enterprise/15.7 (ASE). Trying my luck on SOUNDEX function to get unique records
Though the command works for characters and provides unique code for similar outputs.
But when i try with Starting numbers ( Followed with Street address ) , soundex... (1 Reply)
Discussion started by: Perlbaby
1 Replies
8. Programming
Dear Team
Please provide suggestion on below query which is used in Sybase Adaptive Server Enterprise/15.7 (ASE).
Query takes more time > 30 Mins to 1 Hr
All required indexes are built
Can we have any efficient approach to get the data retrieval faster for below query.Any help... (0 Replies)
Discussion started by: Perlbaby
0 Replies
LEARN ABOUT SUSE
apache::session::lock::sybase
Session::Lock::Sybase(3) User Contributed Perl Documentation Session::Lock::Sybase(3)
NAME
Apache::Session::Lock::Sybase - Provides mutual exclusion using Sybase
SYNOPSIS
use Apache::Session::Lock::Sybase;
my $locker = new Apache::Session::Lock::Sybase;
$locker->acquire_read_lock($ref);
$locker->acquire_write_lock($ref);
$locker->release_read_lock($ref);
$locker->release_write_lock($ref);
$locker->release_all_locks($ref);
DESCRIPTION
Apache::Session::Lock::Sybase fulfills the locking interface of Apache::Session. Mutual exclusion is achieved through the use of Sybase's
sp_getapplock and sp_releaseapplock functions. Sybase does not support the notion of read and write locks, so this module only supports
exclusive locks. When you request a shared read lock, it is instead promoted to an exclusive write lock.
CONFIGURATION
The module must know how to connect to your MySQL database to acquire locks. You must provide a datasource name, a user name, and a
password. These options are passed in the usual Apache::Session style, and are very similar to the options for
Apache::Session::Store::Sybase. Example:
tie %hash, 'Apache::Session::Sybase', $id, {
LockDataSource => 'dbi:sybase:database',
LockUserName => 'database_user',
LockPassword => 'K00l'
};
Instead, you may pass in an already opened DBI handle to your database.
tie %hash, 'Apache::Session::Sybase', $id, {
LockHandle => $dbh
};
AUTHOR
This module was written by Oliver Maul <oli@42.nu>.
SEE ALSO
Apache::Session
perl v5.12.1 2007-10-02 Session::Lock::Sybase(3)