sybase

• sybase Questions

• • Accessing 2 sybases databases thru ODBC

    We currently have a problem accessing 2 Sybase databases on the same ASE(12.0) thru the use of ODBC ...

    By bartlemmens

  • WHERE clasue order problem. Sybase 12.5 Bug or con...

    Take a look at the following example:create table #tableA(ID int, MYNUMBER char(10))create table #ta...

    By manuel

  • Will SQL Anywhere 5.0 for Netware run on the same ...

    The two products are on different servers. SQL Anywhere is running on a Netware box; SQL 2000 is on ...

    By richard_tocci

  • Wildcard query problem with ASE12.5 cp874

    Hi Guys..I am using ASE 12.5 with codepage cp874 (Thai char set id=101) and sort order is IBM dictio...

    By squee

  • Why is batching in Sybase apparently so pathetic?

    All,can someone please me to some sort of documentation (for Java) thatdiscussesbatching in Sybase e...

    By darthmind_gmail_com

• • @@servername question

    how do you ensure that your @@servername matches your servername in the interfaces file?I have tried...

    By wale, 4 Comments

  • Wrong Trace Flag

    Dear All,I started my ASE 12.0.3 with a wrong trace flag: -T7209 instead of-T7109. Will there be som...

    By hbb, 2 Comments

  • What is the fastest way to retrive the number of r...

    I have a table with indexed colom, if ISelect count() from mytable where myfield='AAA'it r...

    By herry, 2 Comments

  • Where clause for a timestamp field.

    Hello group.I am trying to pull data from a sybase server into MSSQL. I have itworking, to a point.H...

    By ujjc001_charter_net, 5 Comments

  • Virtual memory error on IQ 12.6

    I have encountered the following error when attempting to run a stored proc...It appears to happen w...

    By tedzonk, 1 Comments

• sybase: is the Category's subject.It's has 7,252 questions,this is No.363 pages.
• What is the OS-level login SYBASE used for?
• The DBA's insist that they need access to the OS-level login "sybase"in order to perform their tasks.In fact, they've said that there are specific tasks that they do thatrequire the use of this OS login rather than having a personal accountwith membership in the sybase group.The only r...
• byrocat, Fri, 12 Mar 2010 01:33:00 GMT, 780 bytes, 9 Answer
• why is datapages-only locking not default ?
• Hi All,I was wondering how many sites out there that are using datapages-onlylocking (don't confuse it with row-level locking) scheme as defaultlocking scheme.I think old fashioned all-pages locking scheme has many negativeimpacts on concurrency since it locks index pages along with datapag...
• ibrahim_dogan, Thurs, 11 Mar 2010 22:21:00 GMT, 1,844 bytes
• Change character Set
• HiCan anybody suggest me steps for changing the character set in the existing database server.(ASE 12.5)?ThxWilson...
• wilson77, Thurs, 11 Mar 2010 20:52:00 GMT, 144 bytes, 3 Answer
• Accessing iAnywhere from command line
• Hi,I am a complete newbie to Sybase. I just installed the iAnywhere version on my Mac. Found the bundled apps like Interactive SQL etc to access the data. But I want to be able to get into the database and execute queries from the command line (the SQL prompt as we call it). I looked through the...
• imsathya, Thurs, 11 Mar 2010 20:52:00 GMT, 444 bytes, 3 Answer
• [ASE12.5-win2k] DBCC soft fault not displayed
• After executing a sp_dbcc_runcheck cdb (cdb = dbname) I get the following record (amongst others)Database Name Start time End Time Operation ID Hard Faults Soft Faults Text Columns Abort Count User Name - - ...
• martijnvs, Thurs, 11 Mar 2010 18:45:00 GMT, 1,574 bytes
• WorkStationID fails on Win2K
• Using ODBC 3.50.00.10 on an Win2000 Pro SP4, I'm setting the WorkStationIDfield in the ODBC datasource but when I connect using my application andselect 'select host_name()', I get back WinNT. This seems to work propertlyon an XP box. Any ideas?ThanksScott,-- Quote of the Minute -...
• scott_kellish, Thurs, 11 Mar 2010 18:44:00 GMT, 778 bytes, 1 Answer
• Where to download ASE 10??
• Hi,Does anyone know where to download ASE 10'Thank you....
• max, Thurs, 11 Mar 2010 16:41:00 GMT, 76 bytes
• why doesn't File DSN work for me?
• I created File DSN to connect to Sybase server using SybaseSystem 11 driver.When I tried to link tables in Access using File DSN Icreated, I get error msg 'Reserved error (-7778); there isno message for this error.' However,when I use User DSN orSystem DSN, it works. How can I fix this...
• sybaseuser, Thurs, 11 Mar 2010 11:51:00 GMT, 674 bytes, 7 Answer
• XA interface CICS
• Hello,We are trying to run the XA interface for Sybase/CICS, with COBOL appications. We think we have everything running (the CICS is starting now, which we couldn't start before).When we try to do EXEC SQL SET CONNECTION CONN1 END-EXEC. we get: -033620271jcs_objects: cslib user api layer:...
• mrozenhart, Thurs, 11 Mar 2010 04:56:00 GMT, 475 bytes
• what is the output format of a backup
• Hi,When we do a backup of a data base ASA what is the output format (txt,ASCII...)?Tkanks for your help....
• rabaaoui_abdelhak, Thurs, 11 Mar 2010 04:53:00 GMT, 116 bytes, 1 Answer
• Versant to Sybase port
• Does anyone have any experience they would like to share regardingporting a C++ application written against Versant to a Sybase ASE backend? Are there any tools out there that would help?Would a hacked reimplementation of the PObject class be the bestapproach - or is it better just to bite the b...
• chris_jack_msn_com, Thurs, 11 Mar 2010 01:14:00 GMT, 406 bytes
• Wierd error after installing Windows Service Pack 2 in my application
• HiMy application uses Sybase ASA 9.0.1 as backend.It was running perfectly fine.But after installation of Windows Service Pack 2 on my Tablet PC,some of the pages of the application have started giving wierd errors.The error reads iAnywhere.Data.AsaClient.AsaException :Result set not permitted...
• tanmayasaxena, Thurs, 11 Mar 2010 00:26:00 GMT, 515 bytes
• Sybase dated diff function fails
• In old Sybase versions there was an occasionally failure for thedatadiff function, does this still exists in the new Sybase versions?is there any new issues ?Any help would be greatThanksTeresa...
• teresa, Wed, 10 Mar 2010 18:14:00 GMT, 217 bytes, 3 Answer
• Sybase IQ - system table update
• Hi,Is it possible to update password column of SYS.SYSUSERPERM in Syabse IQ?or for that matter, can a DBA issue a DML statement on IQ system tables?Please suggest!Thanks...
• wilson77, Wed, 10 Mar 2010 16:21:00 GMT, 209 bytes
• Why sybase didnt use nonclustered index?
• My table has a nonclustered index.But where i use search arguments of the indexed column.Sybase didn't use the nonclusterd index,but did a full table scan.Create Table Test(c1 int not null,c2 money default 0,c3 varchar(20),constraint PK_Test primary key(c1))gocreate index ind_c2_Test on Te...
• enhydraboy, Wed, 10 Mar 2010 16:20:00 GMT, 941 bytes, 2 Answer
• Windows 2000 and Sybase ASE 11.5.1
• Is there a way to set the ASE 11.5.1 sort order outside of using theServer Configuration tool?I've been asked to install a copy of sybase ASE 11.5.1 on a testserver. That test server is running Windows 2000.I saw that 11.5.1 is not supposed to work on Win2K. It does seem torun but I can...
• steveg, Wed, 10 Mar 2010 12:17:00 GMT, 1,269 bytes, 2 Answer
• Very High Insert Times Root Cause Analysis?
• We have a Sun E4500 running Solaris 8, 6GB RAM, HDS SAN running Sybase 12.5.X for OLTP workload.We're frequently getting insert execution times of single rows which take upwards of 5 seconds and sometimes higher than 100 seconds--normally, these take a few miliseconds.There is no perceivabl...
• mudfoot, Wed, 10 Mar 2010 12:17:00 GMT, 1,356 bytes, 2 Answer
• A variable table for a cursor
• Hi,I use ASE 12.5.0.2I need to make a procedure with a cursor with a variable table.like this:DECLARE cur_TABLE CURSOR FOR select FIELD,VALUE FROM @TABLEWhen I put the declaration the cursor in a exec('...'), I can't use it in the body of the procedure.Did someone has an idea?th...
• fredyzz, Mon, 08 Mar 2010 13:32:00 GMT, 373 bytes, 1 Answer
• "select ... from ... where a *= b" - what does it mean
• Hi All!I've found a such Sybase SQL-query:select ...from ...where a *= bIs it mistake or it's some operation I don't know?Please advise.Thanks a lot in advance.John.:confused:...
• johnsmith, Mon, 08 Mar 2010 09:56:00 GMT, 273 bytes, 1 Answer
• @@sqlstatus
• whenever i added while @@sqlstatus = 0 to my Sp it gives me an error that diallowed me to save my Sp_what can i do with it in order to check the statushere part of my Sp_//Declare cursor DECLARE MeterInfoCursor CURSOR FOR SELECT count(*) as Count, Meter_ID, Meter_Reading, NoFlowDays, PeakBackFl...
• jlim, Mon, 08 Mar 2010 09:28:00 GMT, 1,013 bytes, 3 Answer
• «««353354355356357358359360361362363