db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "DerbySQLroutines" by DonaldMcLean
Date Tue, 18 Jul 2006 19:17:52 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by DonaldMcLean:
http://wiki.apache.org/db-derby/DerbySQLroutines

------------------------------------------------------------------------------
  
  Up until at least 10.1.3, attempting to call a procedure with the wrong number of parameters
causes an SQL exception: "ERROR 42Y03: 'SYSCS_UTIL.SYSCS_IMPORT_DATA' is not recognized as
a function or procedure.".
  
+ === SYSCS_IMPORT_DATA
+ 
+ The last line of data must be terminated with an end-of-line (possibly system dependant)
or you will get an exception: "ERROR 38000: The exception 'SQL Exception: Read endOfFile at
unexpected place on line 3.' was thrown while evaluating an expression."
+ 
+ The table and field names must be given in ALL UPPER CASE. Otherwise you will get "ERROR
XIE0M: Table 'property' does not exist." or "ERROR XIE08: There is no column named: set_id."
+ 

Mime
View raw message