Questions tagged [sybaseiq]

a column-based, relational database used for business intelligence

Filter by
Sorted by
Tagged with
1 vote
0 answers
438 views

Another form of WHERE NOT EXIST

I have two complex queries and I have to filter out the results from the second one, it looks something like this: SELECT STH INTO #temp_table_1 FROM TABLE1, TABLE2, TABLE3 WHERE TABLE1.ID = TABLE2....
user avatar
  • 111
2 votes
0 answers
127 views

Sample Sybase ASE 15.0.3 database

We are trying to migrate a database from Sybase ASE Server 15.0.3 to SQL Server 2016 with the help of a migration assistant application. We tried doing this by creating sample databases in the Sybase ...
user avatar
0 votes
0 answers
1k views

UPDATE JOIN VS UPDATE WITH SUB QUERY

I have 2 tables : Table A ID int, Name varchar, Address varchar Table B ID int, Name varchar, Address varchar, Col1... ... Col100 I want to update A.Name with B.Name based on both table's ID. ...
user avatar
1 vote
0 answers
317 views

Sybase IQ cannot select by a calculated date

Question: I have a query to select rows dated "last Friday from a given date", using the dateadd/datepart/modulo 7 trick. It works fine in Sybase ASE, but returns 0 rows in Sybase IQ. If I hard code ...
user avatar
  • 167
1 vote
2 answers
63 views

How to identify when to move all or part of the data from Sybase ASE to Sybase IQ?

Is there an easy way that any of you guys use to determine this? Ok, we have more than x gb of data, we should go for IQ! Ok, we have more than x reports going, we should go for IQ! Ok, we have a lot ...
user avatar
  • 255
0 votes
1 answer
41 views

Why does a query on 4 times more data take 300 times more processing?

To score the price preference of our individual customers in, we run the below query. Basically it is a weighted average of a product score. The score depends on the product group and the packaging ...
user avatar
2 votes
0 answers
107 views

Sybase IQ identify hot partitions

I need to identify hot partitions of Sybase IQ table (Sybase IQ 16). In Sybase ASE i can use MDA tables (monOpenPartitionActivity), is there any way to measure logical, physical reads for individual ...
user avatar
  • 155
3 votes
1 answer
1k views

Find the number of rows in a table from metadata

I want to write a single select statement to determine the number of rows in a set of tables in Sybase IQ. In SAS, I write this as CREATE TABLE dsnobs as SELECT libname,memname,nlobs, datetime() ...
user avatar
-1 votes
2 answers
680 views

How can we connect and execute oracle database objects from Sybase database objects [closed]

Could you please anybody let me know how to connect to oracle database and execute the stored procedure/function from Sybase database objects?
user avatar
0 votes
1 answer
996 views

Best way to move sybase IQ table to Sybase ASE

I use bcp to copy Sybase IQ table to sybase ASE server. Actually bcp first creates some bulk file with extracdet sybase IQ table there, and after just loads that file to Sybase ASE. Is it the one and ...
user avatar
  • 153
1 vote
1 answer
149 views

Sybase IQ cache database result

I'm using a query that calculates some values on a table with about 11 millions rows. And I need to display the results in real time (on my site), but this calculations need about 1min to execute. The ...
user avatar
  • 153
0 votes
2 answers
734 views

SAP Sybase IQ 16: Missing DATEROUND()

I'm just wondering what might can be wrong I was trying to round a date by its quarter. Beside some hacks I found the function DATEROUND, which I was thinking of based of documentation is able to do ...
user avatar
  • 499
2 votes
1 answer
148 views

Find efficient way of migration 2TB GBK table in SybaseIQ to UTF-8 files

My project need to migrate more than 2TB raw data from SybaseIQ to another Database. SybaseIQ using GBK, the target Database using UTF-8, the target database can only load from UTF-8 files. We use ...
user avatar
5 votes
1 answer
2k views

How to configure connection accessing Sybase Anywhere from Sybase IQ via ODBC on Linux

I'm trying to access an ASA16 server from IQ16 via ODBC driver. Both servers are installed on the same Linux box. I've installed unixodbc-bin and added a file .odbc.init into home of user running ...
user avatar
  • 499
-1 votes
1 answer
137 views

Sybase: Replacement for TimeSeries()

Is there any build in replacement which is doing similar to TimeSeries() of MS SQL on Sybase ASA/IQ? I'm having a starttime and an endtime as well as an intervall and needs to generate a list of all ...
user avatar
  • 499
0 votes
1 answer
1k views

How to add a column with computed columns with values of row on Sybase IQ [closed]

How to add a computed column to a table referring a field from current row at Sybase IQ 16 Here is want I want to achieve: When inserting a new row (or updating a row) I want to have a column ...
user avatar
  • 499
1 vote
1 answer
10k views

How to get list of tables, views etc. a users has rights to on Sybase IQ?

I'm looking for a way to get a list of views, tables, procesdures etc, a user has been granted to. A select onto SYSROLEGRANTS helped me to find basic role of users -- but not more like this. So e.g....
user avatar
  • 499
3 votes
2 answers
325 views

What's the best way to get data for sampling points within a timeframe

I'm looking for some advice how to set up a set of queries which check for an aggregated value for sampling points within a time period. This should run at an IQ-server, so maybe not this many ...
user avatar
  • 499