📄 importexportthruij.out
字号:
The Weizmann Institute of Science |Israel Tridium, Inc. | Omron Corporation |Japan Nob Systems Corp. | Software Tecnologia Y Servicios S.A. |Colombia IBM | Gunn Software Pty Ltd. |Australia en Vise Corporation |Canada University of Maryland, UMBC |US Temple Games, Inc. |US Food and Agriculture Organization |Italy Adobe Systems |US Trefoil Computers Ltd |UK University of Economics |AT Acriter Systems BV |Netherlands NetBeans, Inc. | Sundayta Ltd |United Kingdom Synthese S.A. | ij> drop table sqlAnywhere2;ERROR 42Y55: 'DROP TABLE' cannot be performed on 'SQLANYWHERE2' because it does not exist.ij> create table sqlAnywhere2 ( Fname varchar(30), Lname varchar(30), email varchar(40), phone varchar(30));0 rows inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'SQLANYWHERE2' , null , '3, 4, 7, 5', 'extin/sqlAnywhere2.utf' , '|', '''', 'ASCII', 0) ;0 rows inserted/updated/deletedij> select count(*) from sqlAnywhere2;1 -----------204 ij> ------ MS access text file--- default text format is compatible with ours except their record seperator--- is CR-LF instead of LF-- data does not seem to match above description , only problem I see--- is delimiters inside the data , which gets fixed with double delimters--- check the intended case -sureshtdrop table HouseHoldItem;ERROR 42Y55: 'DROP TABLE' cannot be performed on 'HOUSEHOLDITEM' because it does not exist.ij> create table HouseHoldItem ( Category int, RoomId int, Description varchar(255), Model varchar(50), ModelId varchar(50), SerialNumber varchar(50), DayPurchase date, PurchasePrice decimal(8,2), Insured smallint, Note varchar(512));0 rows inserted/updated/deletedij> -- import it first with just LF as record seperator, we should be seeing -- ^M's at the end of note field.call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'HOUSEHOLDITEM' , null , '2,3,4,5,6,7,8,11,14', 'extin/Access1.txt' , null, null, null, 0) ;ERROR 38000: The exception 'SQL Exception: The number of values assigned is not the same as the number of specified or implied columns.' was thrown while evaluating an expression.ERROR 42802: The number of values assigned is not the same as the number of specified or implied columns.ij> select * from HouseHoldItem;CATEGORY |ROOMID |DESCRIPTION |MODEL |MODELID |SERIALNUMBER |DAYPURCHA&|PURCHASEPR&|INSUR&|NOTE --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ij> -------- test export ----call SYSCS_UTIL.SYSCS_EXPORT_TABLE (null, 'T1' , 'extinout/t1.dump' , '|','''', 'ASCII') ;0 rows inserted/updated/deletedij> create table imp_temp(column2 varchar(200), column3 varchar(200), column4 varchar(200), column5 varchar(200), column6 varchar(200));0 rows inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_IMPORT_DATA(null, 'IMP_TEMP' ,null, '2, 3, 4, 5, 6', 'extinout/t1.dump', '|', '''', 'ASCII', 0) ;0 rows inserted/updated/deletedij> select * from imp_temp ;COLUMN2 |COLUMN3 |COLUMN4 |COLUMN5 |COLUMN6 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------Bugs |Bunny |Warner Brothers | -- Rabbit Hole -- |Los Angeles Bobbi |Arndt |Market Place |1000 S Nicolet Rd |Sametown Bruce |Beecher |Madson & Huth Communication Co |1037 W Wisconsin Ave |Smithville Bruce |Beyer |La Salle Clinic |108 E Wisconsin Ave |Jonestown Butch |Bobbi |Town & Country Electric Inc. |108 Hillock Ct |Smithville Calla |Boshers |Saturn of Appleton |110 Fox River Dr |Smithville Carol |Brauer |Bemiss Corp. |110 W North Water St |Jonestown Carol |Braun |AAL Member Credit Union |1115 E Glendale Ave |Smithville Cheri |Buksyk |Office Support |1122 Milwaukee St |Jonestown Chuck |Buss |EAA |1134 S Franklin St |Overton Chuck |Carpenter |Kurz Electric |115 S Drew St |Smithville Chuck |Carr |Alpha 1 |1151 Valley Fair Mall |Jonestown Colleen |Casperson |Valley Trust Corporation |120 N Morrison St |Smithville Connie |Catterton |Fox Community Credit Union |1200 N Perkins St |Smithville Connie |Clay |Valley Lawn Care |121 N Douglas St # R |Smithville Craig |Collar |Network Health Plan |1216 W Wisconsin Ave |Moretown Dan |Coppenger |Kolosso Toyota |1221 N Lawe St |Smithville Dan |Dag |AAL |1222 N Superior St |Smithville Darlene |Dantzier |WDFF |124 W Wisconsin Ave |Dime Box Darlene |Dellenmann |AAL |130 E Franklin St |Smithville Darren |Dinkl |Novus Health Group |1300 E Calumet St |Smithville David |Dockry |AAL |1302 S Ritger |Smithville Debra |Dorsey |AAL Capital Management |1320 S Lincoln St |Smithville Denise |Richardson |AAL Printing/Distribution |1396 Ridgeway Court |Smithville Diane |Duginski |Lawrence University |144 N Mall Dr |Smithville Dick |Dunbar |Ken Gibson Assoc. |1461 Ashland Ave |Smithville Dinah |Duxbury |Menasha Employees Credit Union |1486 Earl St |Dime Box Dominic |Earl |UPIU |150 W Green Bay Rd |Lonesome Don |Ely |AAL |1620 S Lawe St |Smithville Donna |Erdmann |Fox Valley Technical College |1737 W Reid Dr |Smithville Donna |Esser |Bergstrom Air Force Base |1801 N Richmond St # 12 |Jonestown Duane |Feavel |Bank One |1818 N Meade St |Smithville Emmett |Forseth |Bergstrom Enterprises |1818 N Meade St |Smithville Erik |Francken |Fox Cities Bank |1825 N Bluemound Dr |Jonestown Father |Freitas |Town of Vandenbroek |1825 N Bluemound Dr |Smithville Gary |Garvey |Kitz Printing |1909 W 2nd St |Overton George |Gibson |Prime Control Systems |1965 Oshkosh Ave |Smithville Glenn |Gorman |Van Vreede's |1990 S Van Dyke Rd |Little Gorge Howard |Grennon |Insurance Brokerage Services |200 W College Ave |Smithville Ingrid |Guyette |Fox Valley Travel |2074 American Dr |Overton Jacquie |Hagen |M & M Advertising |21 Waugoo Ave |Smithville James |Hammer |University of Women |212 E College Ave |Overton Jan |Hanks ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -