Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [sybaseiq]

a column-based, relational database used for business intelligence

a column-based, petabyte scale, relational database software system used for business intelligence

18 questions
5
votes
1 answer

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 the…
frlan
  • 499
  • 4
  • 26
3
votes
2 answers

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 procedure calls would be cool ;) I had a look into the…
frlan
  • 499
  • 4
  • 26
3
votes
1 answer

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() format DATETIME16. as timestamp FROM…
Dirk Horsten
  • 85
  • 8
2
votes
1 answer

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 The Extract Options to extract data to GBK files…
Jaugar Chang
  • 131
  • 5
2
votes
0 answers

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 Server and then migrating it to the SQL Server…
C V KASHYAP
  • 21
  • 1
2
votes
0 answers

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 partitions in Sybase IQ? I tried sp_iqsysmon, but…
Alex
  • 155
  • 1
  • 6
1
vote
1 answer

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 table content changes each 30 mins, so I don't…
Daria
  • 153
  • 1
  • 7
1
vote
1 answer

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. Having this: create or replace view myFancyView…
frlan
  • 499
  • 4
  • 26
1
vote
0 answers

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.ID, TABLE2.ID = TABLE3.ID, TABLE3.STATUS =…
Quentin
  • 111
  • 1
1
vote
0 answers

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 the date into the query, it works in IQ as well,…
RToyo
  • 167
  • 1
  • 9
1
vote
2 answers

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 of data archived and need better timings…
aF.
  • 255
  • 4
  • 10
0
votes
1 answer

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 the best (considering accuracy, speed) way to do…
Daria
  • 153
  • 1
  • 7
0
votes
2 answers

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 so. So I've build up a little test: SELECT…
frlan
  • 499
  • 4
  • 26
0
votes
1 answer

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

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 updated based on a function referencing another field.…
frlan
  • 499
  • 4
  • 26
0
votes
0 answers

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. UPDATE A SET A.NAME = B.NAME FROM A JOIN…
EagerToLearn
  • 101
  • 2
1
2