DERBY
|
http://db.apache.org/derby Basic Commands |
||
|
java -jar %DERBY_HOME%\lib\derbyrun.jar server start java -jar -Dderby.system.home=C:\myDBpath %DERBY_HOME%\lib\derbyrun.jar server start java -jar %DERBY_HOME%\lib\derbyrun.jar server shutdown connecting to derby server : C:\>ij ij> connect 'jdbc:derby://localhost:1571/myDBname;create=true'; ij> connect 'jdbc:derby://localhost:1571/myDBname'; connecting to mysql server : add the following line to %DERBY_HOME%\bin\derby_common.bat : set LOCALCLASSPATH=%LOCALCLASSPATH%;C:\mysql\mysql-connector-java-3.0.14-production\mysql-connector-java-3.0.14-production-bin.jar C:\>ij ij> driver 'com.mysql.jdbc.Driver'; ij> connect 'jdbc:mysql://localhost:3306/myDBname?user=root'; Export Table : SYSCS_UTIL.SYSCS_EXPORT_TABLE (IN SCHEMANAME VARCHAR(128), IN TABLENAME VARCHAR(128), IN FILENAME VARCHAR(32672), IN COLUMNDELIMITER CHAR(1), IN CHARACTERDELIMITER CHAR(1), IN CODESET VARCHAR(128)); Example : CALL SYSCS_UTIL.SYSCS_EXPORT_TABLE (null,'STAFF','myfile.del',null,null,null); Import Table : SYSCS_UTIL.SYSCS_IMPORT_TABLE (IN SCHEMANAME VARCHAR(128), IN TABLENAME VARCHAR(128), IN FILENAME VARCHAR(32672), IN COLUMNDELIMITER CHAR(1), IN CHARACTERDELIMITER CHAR(1), IN CODESET VARCHAR(128), IN REPLACE SMALLINT); Example : CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE (null,'STAFF','myfile.del',null,null,null,0); Example : |
||