www.javadevhome.com

Google
   

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 :