Re: self referencing column

2010-02-01 Thread Dag H. Wanvik
joe writes: > Hi, > > i have to persist a simple state machine. > my problem is how to insert the first state which should reference itself. > > CREATE TABLE state > ( > ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, > INCREMENT BY 1) constraint STATE_ID_PK primary key, > NEX

Re: CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE

2010-02-01 Thread Dag H. Wanvik
Stefan Bühlmann writes: > Hi everybody! > > I'm using the wunderfull fast function SYSCS_IMPORT_TABLE to import > big csv data. Sadly the csv data isn't always correct: > > org.springframework.jdbc.UncategorizedSQLException: StatementCallback; > uncategorized SQLException for SQL [CALL SYSCS_UTIL

Re: IJ scripting (variables in IJ?)

2010-02-01 Thread Dag H. Wanvik
Sylvain Leroux writes: > Hi Thomas, > > Maybe you could use a temporary table to "emulate" variables in IJ? > In that case you will need to rewrite your procedures as functions. > > Regards, > Sylvain > > Thomas a écrit : >> Hi, >> I would like to execute a series of statements in IJ where the va

Re: pagesize for a given table

2010-02-01 Thread David Parker
perfect! Thanks! On Feb 1, 2010, at 5:26 PM, Knut Anders Hatlen wrote: > David Parker writes: > >> I am trying to address some insert performance issues we are having >> for a wide table by increasing the pagesize for that table. As far as >> I can tell, this means issuing a call to syscs_set_d

Re: pagesize for a given table

2010-02-01 Thread Knut Anders Hatlen
David Parker writes: > I am trying to address some insert performance issues we are having > for a wide table by increasing the pagesize for that table. As far as > I can tell, this means issuing a call to syscs_set_database_property > to set the desired pagesize, then creating the table. I'd kin

pagesize for a given table

2010-02-01 Thread David Parker
I am trying to address some insert performance issues we are having for a wide table by increasing the pagesize for that table. As far as I can tell, this means issuing a call to syscs_set_database_property to set the desired pagesize, then creating the table. I'd kind of like to be able to veri

Re: DERBY-4530: Unable to run derby as windows service

2010-02-01 Thread Bryan Pendleton
Could you pls help me in explaining the steps how to create derby service and run successfully? C:\Softwares\apache-tomcat-5.5.28\apache-tomcat-5.5.28\bin\tomcat5.exe //IS//DerbyServer1 --DisplayName="DerbyServer1" --StartMode=jvm --StopMode=exe --StartClass=org.apache.derby.drda.NetworkServer

DERBY-4530: Unable to run derby as windows service

2010-02-01 Thread Vijender Devakari (HCL Financial Services)
Hi,   Refering to the issue DERBY-187 Unable to run Derby as windows service. I have tried with below command as specified in the issue DERBY-187, but was able to create the service and unable to run the service. Could you pls help me in explaining the steps how to create derby service and

Re: self referencing column

2010-02-01 Thread Rick Hillegas
Hi Joe, If you remove the "not null" constraint from the next_state_id column then you will be able to insert your first row: create table state ( id integer not null generated always as identity (start with 1, increment by 1) constraint state_id_pk primary key, next_state_id integer const

self referencing column

2010-02-01 Thread joe
Hi, i have to persist a simple state machine. my problem is how to insert the first state which should reference itself. CREATE TABLE state ( ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1) constraint STATE_ID_PK primary key, NEXT_STATE_ID integer not null co