Questions tagged [sybaseiq]
a column-based, relational database used for business intelligence
18
questions
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....
- 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 ...
- 21
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.
...
- 101
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 ...
- 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 ...
- 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 ...
- 85
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 ...
- 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() ...
- 85
-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?
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 ...
- 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 ...
- 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 ...
- 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 ...
- 131
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 ...
- 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 ...
- 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 ...
- 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....
- 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 ...
- 499