Report on individual password expiration intervals in Sybase ASE 12.5
I want to run a report to make sure the password of every user is set to expire every 30 days, but the expiration interval doesn't seem to be stored in syslogins? ...
sybase
Inserting Japanese characters to Sybase db from Excel
I can see the Japanese test in the excel cells. I've built the insert query using ADO. It does the insert in the DB, but Japanese characters are simply represented as "????" Any help would be appreciated. ...
call a sql with a compute clause in C#
Does anybody know how to call a sql with a compute clause in C#? I got internal error 30016. my Database is sybase 12.5.4. ...
Sybase ASE 15.x ODBC driver on Windows 7 64bit
I have trouble getting the Sybase ASE ODBC drivers to work on Windows 7 64bit. I have a 64bit version for Sybase ASE 15.0.1. However the installation fails. After selecting a "Custom" installation, and selecting all the options required for the client, the Java-based installer just disappears into thin air when clicking NEXT. I have tr...
Check constraint to make sure values in a character column are all digits.
This is similar to http://stackoverflow.com/questions/1167767/check-constraint-of-string-to-contain-only-digits-oracle-sql but I want to do this for Sybase. I have a character column 'colExp' (8 characters). I want to put a check constraint to make sure values for this column are all digits. How can I do this? This will work but its n...
How can I do paging in Sybase without making temp table? (oracle rownum issue)
In Oracle, usually query like this for paging. SELECT * FROM (SELECT *, rownum rid FROM TABLEA WHERE rownum <= #pageend#) WHERE rid > #pagestart# However, there is no "rownum" function in Sybase DBMS. How can I do that query exactlly same in Sybase? I found some ways. use "rowcount" set rowcount 10 select * from TABLEA use iden...
Sybase IQ and Encrypted Passwords
I have need to use the ENP (Encrypted Password) parameter with Sybase IQ. The documentation has a good reference on how to use it but not how to generate the password ... so how does one generate the encrypted password for use with the ENP connection parameter?? Thanks in advance ...
How to force table select to go over blocks
How can I make Sybase's database engine return an unsorted list of records in non-numeric order? ~~~ I have an issue where I need to reproduce an error in the application where I select from a table where the ID is generated in sequence, but the ID is not the last one in the selection. Let me explain. ID STATUS _____________ 1234 ...
Is it possible to recoverDB File in sybase? i have lost my db file
I have lost my "Trak.db" there is log file is available is it possible to recover this one through log file? use of Log files? ...
adding lock option to Create Table statement in Sql Server 2005
I am busy creating tables in Sql Server from a Sybase database. In the Sybase database when the tables are created an option 'lock allpages' was used, how can I replicate this when creating the tables in Sql Server 2005. ...
Sybase ASA 9 Stored procedure, use default parameter
I have a stored procedure'test' in Sybase ASA with for example 4 parameters. par1 INT = 0, par2 VARCHAR(50) = NULL, par3 VARCHAR(100) = NULL, par4 VARCHAR(10) = '' Now I want to execute this stored procedure with par1 as its default value. call test(NULL, 'test') But the actual value of par1 i not 0, but 1! I also tried call t...
sybase - showplan drops estimated I/O greatly by adding another table to query
The application of the query has been changed, but the theory is the same. 4 tables: states - list of states (index on state) stores - stores, and the state they're in (separate indexes on state, store) store_orders - ties an order to a store (separate indexes on store, order) order_statuses - has order and status (separate indexes on ...
Can Sybase Sql Anywhere be deployed like VistaDB (or MSAccess)?
Hello all, The context : My current project uses VistaDB as it really fits the main scenario: the user log into the application, selects the DB (file on HDD or Network drive), does his job, then logs off. The DB (a single file) can be copied (email, usb dongle, cd ...) and transfered to colleagues or to the headquarters. And, best of al...
Create dynamic cursor in sybase asa
Hi all, I need to create a dynamic resultset in a stored procedure in Sybase ASA 9. Lets say I have a query: 'SELECT '+@Description+', '+@Id+' From '+@Table; I need to create a cursor to get all values of that query. How? ...
Is KPID globally unique within Sybase?
Can a KPID (as select kpid from master..sysprocesses) be assumed to be globally and always unique? (I've found that for my small sample set KPID(n+1) ~= KPID(n) + 65536 (2^16) but I want to know if I can assume, previous db connections kpid is unique, even if it's previous loginame and spid match a new loginame and spid) Cheers. BLT....
creating sybase stored procedure that returns jdbc statement.getWarning
I am creating a sybase stored prodedure that is being called through JDBC. Under certain error conditions i want my stored procedure to return a warning to the JDBC caller. What do i need to add to the stored procedure so Statement.getWarnings() returns a SqlWarning that contains an error message of my choice? ...
Database transaction only partially committing
I've got a T-SQL stored procedure running on a Sybase ASE database server that is sometimes failing to commit all of its operations, even though it completes without exception. Here's a rough example of what it does. BEGIN TRANSACTION UPDATE TABLE1 SET FIELD1 = @NEW_VALUE1 WHERE KEY1 = @KEY_VALUE1 IF @@error <> 0 OR @@rowcount <> 1 BE...
Any drivers available for ODBC to Sybase that can be used with QTP?
I am looking for drivers that can be used to connect to sybase database from QTP. ...
From a Sybase Database, how I can get table description ( field names and types) ?
I have access to command line isql and I like to get Meta-Data of all the tables of a given database, possibly in a formatted file. How I can achieve that? Thanks. ...
Slow SQL update could use some help.
An ex-coworker of mine wrote the following UPDATE as part of a data import script and it takes nearly 15 minutes to complete on a table of 92k rows. UPDATE table SET name = ( SELECT TOP 1 old_name FROM ( SELECT SUM(r) rev, number, name, intermediate_number, interm...