Dear All, I recently got job to maintain old 2000 server where I came across our old accounting software based on sybase version 5.5, As per my...

Ami

07-09-2010 10:59 AM
Rob V

Guys, I'm new with sybase, but I have bit of knowledge of DB2. I know that exist the "WITH" statement in DB2 to create a temporary table during the...

Rodrigo Cesar

07-02-2010 04:46 PM
Bret_Halford

We use dbschema.pl to reverse engineer our ASE databases, and it works like a charm. There are numerous alternatives as well (DDLgen, PowerDesigner,...

Keith

07-02-2010 09:37 AM
Keith

1) Are double quotes and square brackets fully interchangeable when used to quote identifiers? Are there instances where one or the other might not...

Matthew Persico

07-01-2010 11:58 AM
Bret_Halford

For those of your who take interest in excellent infographics and leading edge database reporting techniques.. check out this...

JTP PR

06-30-2010 07:30 AM
JTP PR

Watch the latest video in the DB2 vs. Oracle series. This one is an animated tale of two peasants from the “Village of Orrible” who want to break...

Anil Mahadev

06-02-2010 11:08 AM
Anil Mahadev

Top 10 Technical requirements for In-Memory Reporting With Gartner's Business Intelligence group listing In-Memory analytics at the top of their...

JTP PR

05-27-2010 07:16 AM
JTP PR

Since it's an MSA, "switch active" command is not applicable. I understand that I can trace the DSIs to see the number of active segments (which is...

simon

05-21-2010 04:05 PM
simon

Hello, Due to a hardware crash we are in the following situation: The last valuable DUMP(s) are on tape, but the tape drive can not be mounted on a...

rebelde

05-20-2010 03:11 PM
Bret_Halford

Greetings, I am getting a strange error while execution of an sp. Here is the basic flow. Procedure P1--> 1)Create #summary 2)---some business...

test

05-20-2010 12:54 PM
test

Hi guys, Am having a strange issue with sybase asa 9. I have this application that needs to be integrated with a fingerprint reader function...

larryj

05-19-2010 02:37 AM
Rob V

The evolution of reporting and analytics has seen dramatic changes in recent years. Starting with static “green bar” reports in the mid-to- late...

JTP PR

05-12-2010 06:10 AM
JTP PR

Yellowfin is set to redefine what BI users and IT Departments will expect from Business Intelligence vendors Leading Business Intelligence software...

JTP PR

05-04-2010 06:50 AM
JTP PR

Hi all, I created new instance with sybase ase 155 express edition. Everything looks normal and i can connect to new instance from where instance...

aykut

05-03-2010 08:55 AM
Rob V

I'm reading the Sybase's white paper on replication performance and they claim relatively low throughput, such as ~3000 rows/sec or ~5MB/min via...

simon

05-03-2010 08:54 AM
Rob V

Sybase Partner: Yellowfin Business Intelligence is offering customers,industry professionals, developers, OEMS and Vendors a chance to get a...

JTP PR

04-29-2010 07:11 AM
JTP PR

So far I've only been able to find an "installation manual", but not anything on upgrade live 12 to 15, in regards to Replication server...

simon

04-26-2010 04:15 PM
simon

Whitepaper - In-Memory Analytics Yellowfin has released its latest Business Intelligence Whitepaper, this time on "In-memory Analytics" * No...

JTP PR

04-26-2010 06:00 AM
JTP PR

I have a requirement in my project one column is getting values...

sandeep

04-15-2010 04:39 AM
Leonid Gvirtz

Hi, I have a problem when trying to use SSMA to migrate from Sybase 12.5 to SQL Server 2005. My problem is that the OLE DB provider, which SSMA is...

maghac

04-14-2010 08:48 AM
maghac

================================================================== 2010 International Congress on Computer Applications and...

Andrew

04-12-2010 12:40 AM
Andrew

It appears that dump marker pertains only to database subscriptions. We are using table subscriptions. How do I not lose data accrued during...

Tester

04-01-2010 05:34 PM
simon

The last best practices document that I saw for Sybase stated that SSL should be used for all database connections. Turns out that this got added to...

byrocat

03-25-2010 11:33 AM
byrocat

When I dump the queue using "sysadmin dump_queue" I see a ton of transactions wrapped in begin tran/commit that have nothing to do with the error...

simon

03-03-2010 01:14 PM
simon

The Yellowfin BI team have produced a new paper on "Location Intelligence", the mashup of BI with GIS Extract More than 70% of your organizational...

JTP PR

03-03-2010 04:05 AM
JTP PR

I'm replicating the entire database, and refresh the replica using dump marker method. After I load the replica and resume connection, all of a...

Axel

03-01-2010 01:42 PM
Axel

Hi everyone, first im sorry because i dont know how to explain my issue so i have to put a fragment of my code which is written in php and mysql, my...

Jorge Reyes

02-19-2010 12:13 PM
Jorge Reyes

Hi, There is a strange issue about sybase interfaces file. We have an application which is run on solaris sparc OS and this application uses open...

aykut

02-19-2010 05:38 AM
aykut

A legacy application uses Sybase 11.0.3 on OpenVMS. A process attempts to open a connection to the database using the dblibrary 'dbopen' function,...

Shad

01-08-2010 05:30 AM
Shad

Hi I have one of our accounting program working on sybase 6 uder linux. We would like to migrate databse engine to new serwer run by win2008. We are...

Bartek

01-07-2010 12:08 PM
Bartek

The normal way I've seen database schema versioning is to create a database version table and use an integer as the schema version. I've found a few...

David

01-03-2010 02:19 PM
David

Very cool design! I find very interesting information at this...

asdasd asdasdad

12-13-2009 04:43 AM
asdasd asdasdad

The Yellowfin BI team have produced a new paper on "Business Intelligence on Mobile devices". Anonymous Download Link...

JTP PR

12-08-2009 05:33 AM
JTP PR

Why am I getting different results from sp_server_info 2 and @@version? (@@version is correct). exec sp_server_info 2 attribute_id ...

Claret

12-07-2009 03:43 PM
Bret_Halford

Hi, How can I get the modified date for a table? sp_help shows only Creation Date. Thanks, Subind

Subind

11-26-2009 01:39 AM
Manish Negandhi [TeamSybase]

Bypassing the disk. Something like a batch select into dest_db..dest_table from src_db..src_table or insert select. Anything that does not involve...

Tester

11-19-2009 05:51 AM
Leonid Gvirtz

We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the...

Mia

11-18-2009 12:15 PM
Mia

Sybase Partner: Philippines, November 13, 2009 – leading Business intelligence (BI) firm, Yellowfin, today announced details of its exclusive...

JTP PR

11-18-2009 03:46 AM
JTP PR

I found this in an error log this morning on a 15.0.3 server: 04:00000:00393:2009/11/16 14:06:13.55 server Error: 335, Severity: 20, State:...

Daoud

11-17-2009 12:33 PM
Bret_Halford

Hi, looking at a table of sysloginroles, found several users with sa and sso roles; besides sa and other extra account , isn't it a security problem...

Bkiddo

11-05-2009 05:10 AM
Carl Kayser

Is different the information you get if you run: select * from master..sysprotects than the one you obtain from: select * from sysprotects ? I...

Bkiddo

11-04-2009 05:24 PM
Bret_Halford

Hello, we face in one of our installations errors like this: 00:00000:00018:2009/07/07 20:35:33.76 kernel timeslice -1501, current process...

rebelde

10-26-2009 09:59 AM
rebelde

Ladies, gentlemen, Upscene Productions is proud to announce the next version of the popular database development tool: " Database Workbench 3.4.1...

Martijn Tonies

10-26-2009 05:47 AM
Martijn Tonies

Hi, I have these two procs and I'm trying to catch the error number from the proc "call_error". But I always get 0 as the value. It may be bcoz of...

Subind

10-24-2009 02:07 AM
Subind

The nature of the Business Intelligence industry is changing. Major acquisitions of the past few years have seen most of the traditional players...

JTP PR

10-20-2009 04:46 AM
JTP PR

I am working with ASE 15 in my application and there is performance issue related with nested joins. I have stored procedure which selects 2 columns...

aykut

10-19-2009 05:12 AM
Rob V

hi, i am coding C with using open client for database jobs on sybase and i got some errors about charsets. My sybase server is ASE 15.02 and when i...

aykut

10-19-2009 12:50 AM
aykut

Hey Guys and Gals, mars:/sybase/sybase_125/REP-12_5 > /sybase/sybase_125/REP-12_5/ RUN_MARSTESTPRS1 ld.so.1: repserver: fatal: relocation error:...

Guto

10-16-2009 12:05 PM
SybaseNeal

We have a database that when dumped with the dbbackup command is a 67gb .db file and a 28gB .log file . It's becoming somewhat difficult to manage...

m

10-16-2009 10:30 AM
m

Hi! I'm new at Sybase, I want to make a query selecting fields from different databases, how can I make it? Thanks for your time!

yuriha

10-15-2009 07:49 AM
Carl Kayser