Questions tagged [sybaseiq]
a column-based, relational database used for business intelligence
19
questions
1
vote
0answers
230 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....
1
vote
0answers
108 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 ...
0
votes
0answers
502 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.
...
1
vote
0answers
246 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 ...
1
vote
2answers
50 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 ...
0
votes
1answer
39 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 ...
2
votes
0answers
95 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 ...
3
votes
1answer
960 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() ...
-1
votes
2answers
603 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
1answer
886 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 ...
0
votes
1answer
134 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 ...
0
votes
1answer
228 views
SAP Control Center unable to recognize IQ version string [closed]
On a fresh installed SCC with SAP Sybase IQ on localhost I'm getting this error while connecting to localhost running scc agent for IQ.
SCC agent localhost:9999 does not know Sybase IQ version ...
0
votes
2answers
589 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 ...
0
votes
1answer
134 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 ...
4
votes
1answer
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 ...
-1
votes
1answer
127 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 ...
0
votes
1answer
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 ...
1
vote
1answer
7k 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....
3
votes
2answers
324 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 ...
