sybase-iq

Sybase IQ and Encrypted Passwords

I have need to use the ENP (Encrypted Password) parameter with Sybase IQ. The documentation has a good reference on how to use it but not how to generate the password ... so how does one generate the encrypted password for use with the ENP connection parameter?? Thanks in advance ...

Archiving from mySQL to Sybase using Powercenter, problem converting varchar to bit

I have to different databases one is mySQL and the other is Sybase IQ. Both have the same table layout and datatypes. One of the fields has a bit datatype. Unfortunately when I pull the mySQL table into Powercenter it makes it converts it to a string(1). Now when I am trying to write the data from Powercenter to the Sybase IQ table u...

Are these tables too big for SQL Server or Oracle

Hey all, I'm not much of a database guru so I would like some advice. Background We have 4 tables that are currently stored in Sybase IQ. We don't currently have any choice over this, we're basically stuck with what someone else decided for us. Sybase IQ is a column-oriented database that is perfect for a data warehouse. Unfortuna...

cryptic error message: Length of Bind host variable exceeds MaxLength

Hi, I've encountered a cryptic error message thrown by Sybase IQ server. com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -1001019: Function not supported on varchars longer than 255 Length of Bind host variable exceeds MaxLength , -- (df_Heap.cxx 2145) at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2636) at com.sybase.j...

Sybase IQ: How to create a DBSPACE with raw device?

I'm on Sybase Iq 15.1 and try to add a dbspace to a demo database, using a raw device on Linux. I always get SQL error 1010000, file already exists: CREATE DBSPACE KLMTEST USING FILE DF1 '/dev/disk/by-id/scsi-1HITACHI_730109670008' IQ STORE; Could not execute statement. The file '/dev/disk/by-id/scsi-1HITACHI_730109670008' already exis...

How should i execute and get the result of a query which is stored in a column as a data value

How do I execute a Sybase query which is stored in a column of another Sybase table? Suppose that "SELECT COLa FROM TABLE_A" is stored in a column called 'command' in a separate table (table_log). I want to find a way that allows me to execute this query and get the answer. ...

How do you LOAD TABLE in Sybase IQ from a client using Java?

Is it possible to load a file from a client computer into a table in Sybase IQ, using the LOAD TABLE ... USING CLIENT FILE statement? The data does not come from a database, but rather an external source. Can this be done using a JDBC driver in Java, and having the file only on the client computer? If so, how? ...

Sybase IQ - how to show stored procedure without wrapping text?

Hello. Using Sybase IQ v12.7. Executing sp_helptext ProcedureName shows the text of the stored procedure which is fine. However it wraps lines at 80 characters. The question is, how to show text text of a stored procedure without wrapping? In Sybase Central Java Edition there is a feature see the text of a stored procedure (Tranact-...