Enter Keywords:
1 - 10 of 11(0.006 seconds)
Sort By:
 
hi experts, (sybase sql anywhere 10 db) i'd like to extract a wee bit of data from one table by using SELECT 'INSERT INTO...' via Interactive SQL. unfortunately i'm struggling with the SQL. someb...
Zones: SybaseDate Answered: 07/23/2008 Rating: 6.6 Views: 0
Hi, I brand new to Sybase and the specific flavour of SQL. What is the syntax for creating a temporary table from a select statement. That is a temp table is created already populated with ro...
Zones: SybaseDate Answered: 11/21/2008 Rating: 9.0 Views: 12
Hi:    I am creating an application in powerbuilder 6.5 and I am using Sybase SQL anywhere as my database. I am creating a datawindow that requires sorting of the data. I tried all means but nothi...
Zones: SybaseDate Answered: 04/12/2006 Rating: 8.4 Views: 0
Hi Experts, Can you please help to wrtie a query in sybase database. For example result Select * from emp returns 100 rows. I need queries to display first 1 to 20 and another query to displ...
Zones: SybaseDate Answered: 12/03/2007 Rating: 8.8 Views: 0
I am getting an error while executing a simple query in java. Database is sybase. i am new to sybase. what should i do? I am getting the following error: com.sybase.jdbc3.jdbc.SybSQLException: ...
Zones: Java, SybaseDate Answered: 01/05/2009 Rating: 8.6 Views: 0
I have to execute many updates on a table using java batch updates, but i when i try to execute my code on 22,000 records, it just hangs. How can i optimize the updates to not use NOARCHIVELOG, ...
Zones: Sybase, J2SE, JavaDate Answered: 03/06/2009 Rating: 7.8 Views: 55
Hi, I have a problem  related to stored procedure.We are using a cross database query inside a stored procedure. Our database is sybase. Example: INSERT into archive.dbo.employee           ...
Zones: SybaseDate Answered: 07/03/2004 Rating: 7.8 Views: 0
Hello Experts, I am creating a SQL query in Crystal Reports to run against a Sybase db. The data is information about individuals. The Address table contains Street addresses, both business and res...
Zones: Databases, SybaseDate Answered: 08/02/2007 Rating: 8.2 Views: 0
I have an insert statement from powerbuilder, that is throwing a database error. This started happening after PB9 to PB11 migration of the application. It was working fine in PB9. Does it have anyt...
Zones: PowerBuilder, ...Date Answered: 10/30/2008 Rating: 9.0 Views: 0
Hi Guys, I am new to put my hands in tuning techniques. I have learned Sybase Manual of performance tunning which explains the methods to read the showplan output, how to partition the tables, u...
Zones: SybaseDate Answered: 01/30/2007 Rating: 8.2 Views: 8