Sybase | Forum profile

(The problem has nothing to do with table1 vs table2; just table2 and "how to get the report" you want, correct ?) You do not need to implement anything "fixed" or preconfigure anything. Forcing a main/sub breakdown by key is not necessary (it is a relational db, all columns are available via SQL). You need to Pivot the table, which is not too difficult, and will handle any data volumes. There are many...

Hi , Adding to the above if u are not mentioning size in create database command thn it will take the value as set from config parameter "default data size".So check wht is the value set . ya it should be greater than the size for model database.

Hi all, I am having user defined datatype, whose storage type is "text". I am unable to populate data not more than 32768 chars i.e (select @@textsize = 32768). Adding a new text dataype by default takes only length as 16 (i.e 16*2K = 16*2*1024 = 32768). Is there any way that i can set the lengh column to 32, so that the current column of that datatype accepts more characters. 1> sp_help T_SIGMA_FILE_TYPE 2> go...

Thanks Derek, was really ilustrative;

Derek Asirvadem, Please keep in mind that other users are reading this post. They are not interested in your personal grudge or opinion. Please send constructive feedback only... Please read the forum rules and abide by them.

I sugest you set JAVAHOME=<the_path_to_the_java_version_required_by _intall> then PATH=$JAVAHOME/bin:$PATH

I would guess that it is caused by corruption in the database transferred to dump.

Hi all, Here is the case. I want to present my data in a new table or view from another table. table1 (Existing) / main columns presented seq item main sub ... .. . I Want to move main , sub column to a new table or create a view. Don´t wish is the most efficient way. Code: CREATE TABLE custom.table2 ( obj_num INT NOT NULL DEFAULT AUTOINCREMENT, main CHAR (50), sub CHAR (50) ) After this I insert the values to table2 from table1 Code: INSERT...

The paging is not Sybase's fault on AIX - but rather how memory is managed there between applications and file system management and it initializes to be more beneficial to file systems - it's up to the Unix admin to set the minperm/maxperm/maxclient to fix it. But that's speculation. Ok - missed the one note - he did say OPEN CURSOR. That will be based on the SELECT that he cursor is designed on. WHo knows, could be something...

I haven't done it for MySQL to sybase but I had done it for SQL to sybase. I guess the process will be same. What I followed in my case is 1. Get the DDL of all the objects ie tables,stored procedures,indexes etc. of the Source Database 2. Get the data of all the tables in plain text files(in case of sql and sybase there is a utility BCP) 3. Create the database on target server. 4. Execute all the DDls on target DB. 5. From the plain text...