importexportthruij.out

derby database source code.good for you.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ij> select Balance, Account, Company from Alt3 order by Balance;
BALANCE    |ACCOUNT    |COMPANY                            
-----------------------------------------------------------
ij> -- test remapping
-- test remapping
-- following case is commented because data has different seperator than the default one 
-- enable this case after rearranging the data (-suresht)
--create table tempAlt3(column1 varchar(1000) , column3 varchar(1000) , column9 varchar(1000));
--call SYSCS_UTIL.SYSCS_IMPORT_DATA (null, 'tempAlt3' , 
--    				   null , '2,3,9',
--				   'extin/Alt3.asc' , 
--				   null, null, null, 0) ;
--select * from tempAlt3;
---
---  SQL anywhere table
---
drop table sqlAnywhere1;
ERROR 42Y55: 'DROP TABLE' cannot be performed on 'SQLANYWHERE1' because it does not exist.
ij> create table sqlAnywhere1 (
	Id	int,
	Name	varchar(40),
	Title	varchar(40),
	Company	varchar(50),
	Address	varchar(80),
	City	varchar(30),
	State	varchar(30),
	Zip	varchar(30),
	Country varchar(30),
	phone1	varchar(50),
	phone2	varchar(30),
	email	varchar(80),
	web	varchar(50));
0 rows inserted/updated/deleted
ij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'SQLANYWHERE1' ,
                                  null , '1,2,3,4,5,7,8,9,10,11,12,13,14', 
	 		          'extin/sqlAnywhere1.utf' , 
				  '|', '''', 'ASCII', 0) ;
0 rows inserted/updated/deleted
ij> select Company, Country from sqlAnywhere1 where country not like 'U%S%A%' and country is not null;
COMPANY                                           |COUNTRY                       
---------------------------------------------------------------------------------
Dow Jones Interactive Publishing                  |                              
Electric Press                                    |                              
Los Alamos National Lab                           |                              
SoftCom                                           |                              
Kinetoscope                                       |                              
Npulse Software                                   |                              
Penetics                                          |                              
Columbia University                               |                              
Visionary Information Systems, Inc.               |                              
Micro Computer Systems                            |                              
Gemini Systems                                    |                              
Crossroads Technologies                           |                              
Silverstream Software, Inc.                       |                              
Rexton Interactive                                |                              
Tilden Park                                       |                              
Blue Lobster Software                             |                              
Novera                                            |                              
Verix Software                                    |                              
Lotus                                             |                              
Background Profiles                               |                              
Weblogic                                          |                              
Marimba                                           |                              
MECA Software                                     |                              
Pervasive Software, Inc.                          |                              
Neuron Data                                       |                              
Tandem                                            |                              
Verge Software Corporation                        |                              
Computer Curriculum Corporation                   |                              
Omix                                              |                              
Noblestar                                         |                              
Highmark, Inc.                                    |                              
Learncom                                          |                              
Molecular Simulations                             |                              
Progress Software                                 |                              
Skunk Technologies                                |                              
Sterling Software                                 |                              
Sun Microsystems                                  |                              
Thought, Inc.                                     |                              
Internet Image                                    |                              
Database Advisor Magazine                         |                              
Rogue Wave                                        |                              
Creative Concepts Corporation                     |                              
Visa International                                |                              
Object Systems, Inc.                              |                              
Dynavent Software                                 |                              
Telecallaction                                    |                              
Cybered Corp                                      |                              
ADC Kentrox                                       |                              
Sprocket Interactive Solutions                    |                              
Kenetiks, Inc.                                    |                              
Infospace, Inc.                                   |                              
Open Horizon                                      |                              
WebMethods, Inc.                                  |                              
Sovereign Bank                                    |                              
NetNumina Solutions                               |                              
Interactive Education                             |                              
LiveMedia                                         |                              
Sun Microsystems                                  |                              
Grandview DB/DC Systems                           |                              
Mage Lang Institute, Ltd.                         |                              
List Foundation                                   |                              
Shafir Inc.                                       |                              
Great Northwest Design                            |                              
Inovie Software Inc.                              |                              
LANQUEST                                          |                              
Sprint Paranet                                    |                              
Orbital Technologies                              |                              
Biss GmbH                                         |                              
GRC International, Inc.                           |                              
Painted Word, Inc.                                |                              
Isadra, Inc.                                      |                              
Delphi Solutions                                  |Switzerland                   
FieldWorker Products Ltd.                         |                              
Fiberlane Communications Canada, Inc.             |CANADA                        
Novell                                            |                              
Platinum technology, Inc. ViaTech Development Lab |                              
IBM                                               |Switzerland                   
Manna Network Technologies                        |Israel                        
Advanced Workstation Solutions, Inc.              |                              
Cybotics Technologies Ltd.                        |Hong Kong                     
Intermedia Communications, Inc.                   |                              
Bay Networks, Inc.                                |                              
Charles River Associates, Inc.                    |                              
Scopus Technologies                               |                              
Net Dynamics                                      |US                            
Tomday                                            |US                            
Cerulean Technology, Inc.                         |                              
Pencom Web Works                                  |                              
Check Free                                        |                              
Cybered Corp.                                     |