ChinaUnix.net
相关文章推荐:

load565rleimage

在create database命令中for load选项说的是跳过页面清除这一步,哪位大哥能具体说一下这个步骤的作用吗?或者直接解释一下为什么要设置for load选项呢?是减少create database的时间吗?

by ywtmh - Sybase - 2004-05-13 10:12:26 阅读(938) 回复(4)

相关讨论

load时如果字段中有“/”就会被过滤掉

by lichg - Informix - 2008-11-02 21:34:26 阅读(1517) 回复(0)

各位大侠: 小弟有以下问题,希望各位能给以解决,谢谢 load 的时候发现以下错误: 805: Cannot open file for load.

by 东西仓库 - Informix - 2007-08-22 16:39:14 阅读(2753) 回复(8)

unload to 1111.txt select mxbz,kh_kh,je,polno,kh_mc,jylx,by1,by2,by3,by4 from XXXXXX where time = today 我想在这个1111.txt 文件的第一行加上一条汇总数据所写sql如下 unload to 11111.txt select hzbz,gsdm,ssjph,sfbz,zjs,zje,by1,by2,'','' from XXX_hz where time = today union select mxbz,kh_kh,je,polno,kh_mc,jylx,by1,by2,by3,by4 from XXXXXX where time = today 但是xxx_hz中的jssph和xxxxx中的je 还有xxx...

by tolerances - Informix - 2007-06-27 11:00:09 阅读(1952) 回复(5)

我现在要装一台备份机,开始从要备份的机器中导出sybase数据库agentdb结构和数据: isql -Uagent -Ptzagent 1>dump database agentdb to '/tmp/agentdb' 2>go 然后将agentdb取到备份机器/tmp/,执行: isql -Uagent -Ptzagent 1>load database agentdb from '/tmp/agentdb' 2>go 报错: Msg 3101,Level 16,State 1: Line 1: Database in use.A user with System Adminstrator (SA) role must have exclusive uSE OF DATABASE TO RUN LOA...

by lxr01 - Sybase - 2006-12-04 22:07:36 阅读(1630) 回复(2)

load时候用不用建设备,还是装sybase后直接load就ok了?

by jsc_flying - Sybase - 2005-01-08 10:41:55 阅读(1066) 回复(4)

I had created a db2 script which will load data from 1 server to another server. My problem is whenever my load process failed then it will lock the tablespace so I wonder is there any way to avoid this problem? I means is there any code can auto fire whenever there is a tablespace state fall into load pending? Please advise

by toms1981 - DB2 - 2004-11-01 13:25:35 阅读(651) 回复(0)

在redhat下安装ASE12.5后,load database 时出现如下问题,请教如何解决?谢谢. Apr 7 00:46:48 2004: Backup Server: 4.145.2.73: [0] Error for device '/data/dumpdev.dat'. Pipe I/O returned 0 bytes Apr 7 00:46:48 2004: Backup Server Internal Error: 4.62.3.4: Multibuffering subprocesses died, archive /data/dumpdev.dat. Apr 7 00:46:48 2004: Backup Server Internal Error: 4.62.3.3: Multibuffering subprocesse...

by ytmxaq - Sybase - 2004-06-23 14:24:10 阅读(1305) 回复(2)

如果UNL文件的分隔符是方匡,也就是TAB格,在DELIMITER后输入什么?如 MISKQSHICU*A* 用load form "aaa.unl" insert into aaa时说COLUMN数不同 我如何做? load from "aaa" delimiter ? insert into aaa;delimiter参数如何输?

by yujun0512 - Informix - 2004-03-03 11:08:08 阅读(722) 回复(8)

load average: 5.94, 5.94, 5.91 5 users, load average: 7.72, 7.36, 6.96 怎么这么高呀。。2 CPU P4 XEON 2.4 G 3G MEM :em06:

by diag - Linux论坛 - 2003-12-11 23:32:54 阅读(633) 回复(6)

基本语法: load data [low_priority] [local] infile 'file_name txt' [replace | ignore] into table tbl_name [fields [terminated by't'] [OPTIONALLY] enclosed by ''] [escaped by'\' ]] [lines terminated by'n'] [ignore number lines] [(col_name, )] load data infile语句从一个文本文件中以很高的速度读入一个表中。使用这个命令之前,mysqld进程(服务)必须已经在运行。为了安全原因,当读取位于服务器上的文本文...

by 流星陨落 - MySQL文档中心 - 2009-07-11 14:32:04 阅读(1104) 回复(0)