注册 登录
编程论坛 → PowerBuilder

PB动态数据管道错误-13

呀儿呼嘿哟 发布于 2015-05-22 10:46， 2609 次点击
错误-13  需要关键字但未指定关键字，这个关键字是什么啊？有哪位大神知道吗？
2 回复
#2
呀儿呼嘿哟2015-05-22 10:55
PIPELINE(source_connect=orcl,destination_connect=orcl ,type=update,commit=100,errors=100,keyname=L_LABORDER)
SOURCE(name="L_LABORDER", COLUMN(type=decimal,name="LABORDER",dbtype="NUMBER(12)")
 COLUMN(type=decimal,name="LABORDERORG",dbtype="NUMBER(10)")
 COLUMN(type=decimal,name="STAYHOSPITALMODE",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="PATIENTID",dbtype="VARCHAR2(40)")
 COLUMN(type=decimal,name="SEX",dbtype="NUMBER(1)")
 COLUMN(type=datetime,name="BIRTHDAY",dbtype="DATE")
 COLUMN(type=varchar,name="CURRENTDEPARTMENT",dbtype="VARCHAR2(10)")
 COLUMN(type=varchar,name="CURRENTBED",dbtype="VARCHAR2(6)")
 COLUMN(type=varchar,name="SPECIMEN",dbtype="VARCHAR2(5)")
 COLUMN(type=varchar,name="EXAMITEM",dbtype="VARCHAR2(500)")
 COLUMN(type=varchar,name="TESTDESCRIBE",dbtype="VARCHAR2(500)")
 COLUMN(type=varchar,name="PATIENTNAME",dbtype="VARCHAR2(50)")
 COLUMN(type=datetime,name="OUTDATE",dbtype="DATE")
 COLUMN(type=decimal,name="PRINTFLAG",dbtype="NUMBER(1)")
 COLUMN(type=decimal,name="RECEIVEFLAG",dbtype="NUMBER(1)")
 COLUMN(type=decimal,name="TYPEFLAG",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="REQUESTER",dbtype="VARCHAR2(20)")
 COLUMN(type=datetime,name="REQUESTETIME",dbtype="DATE")
 COLUMN(type=varchar,name="EXECUTOR",dbtype="VARCHAR2(20)")
 COLUMN(type=datetime,name="EXECUTETIME",dbtype="DATE")
 COLUMN(type=decimal,name="EMERGENCY",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="NOTES",dbtype="VARCHAR2(50)")
 COLUMN(type=decimal,name="PRICE",dbtype="NUMBER(7,2)")
 COLUMN(type=decimal,name="FREQUENCYTIME",dbtype="NUMBER(5)")
 COLUMN(type=varchar,name="LABDEPARTMENT",dbtype="VARCHAR2(10)")
 COLUMN(type=varchar,name="DIAGNOSTIC",dbtype="VARCHAR2(100)")
 COLUMN(type=varchar,name="COMPUTERNAME",dbtype="VARCHAR2(20)")
 COLUMN(type=decimal,name="FEESTATUS",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="QBGSJ",dbtype="VARCHAR2(240)")
 COLUMN(type=varchar,name="QBGDD",dbtype="VARCHAR2(100)")
 COLUMN(type=varchar,name="QBGDT",dbtype="VARCHAR2(100)")
 COLUMN(type=varchar,name="SAMPLENO",dbtype="VARCHAR2(14)")
 COLUMN(type=decimal,name="REQUESTMODE",dbtype="NUMBER(1)")
 COLUMN(type=datetime,name="RECEIVETIME",dbtype="DATE")
 COLUMN(type=decimal,name="PATIENT_NO",dbtype="NUMBER(10)")
 COLUMN(type=decimal,name="INFANT_FLAG",dbtype="NUMBER(1)")
 COLUMN(type=datetime,name="CANCELTIME",dbtype="DATE")
 COLUMN(type=varchar,name="CANCELER",dbtype="VARCHAR2(20)")
 COLUMN(type=decimal,name="JSBZ",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="JSNO",dbtype="VARCHAR2(14)")
 COLUMN(type=varchar,name="EXESJ",dbtype="VARCHAR2(8)")
 COLUMN(type=varchar,name="JSZ",dbtype="VARCHAR2(10)")
 COLUMN(type=varchar,name="FSZ",dbtype="VARCHAR2(10)")
 COLUMN(type=varchar,name="TOPONYMY",dbtype="VARCHAR2(100)")
 COLUMN(type=decimal,name="CYCLE",dbtype="NUMBER(10)")
 COLUMN(type=varchar,name="QUERENZHE",dbtype="VARCHAR2(20)")
 COLUMN(type=datetime,name="QURENSJ",dbtype="DATE")
 COLUMN(type=varchar,name="FENYUANBH",dbtype="VARCHAR2(20)")
 COLUMN(type=varchar,name="BEIZHU",dbtype="VARCHAR2(100)")
 COLUMN(type=varchar,name="RONGQI",dbtype="VARCHAR2(10)")
 COLUMN(type=varchar,name="CAIXUELIANG",dbtype="VARCHAR2(20)")
 COLUMN(type=decimal,name="SHUNXUHAO",dbtype="NUMBER(6)")
 COLUMN(type=varchar,name="BINGANHAO",dbtype="VARCHAR2(10)")
 COLUMN(type=decimal,name="TESHUBZ",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="RENYUANID",dbtype="VARCHAR2(30)")
 COLUMN(type=varchar,name="BINGRENID",dbtype="VARCHAR2(10)")
 COLUMN(type=varchar,name="BINGRENZYID",dbtype="VARCHAR2(10)")
 COLUMN(type=varchar,name="YINGERID",dbtype="VARCHAR2(10)")
 COLUMN(type=varchar,name="SENDRY",dbtype="VARCHAR2(10)")
 COLUMN(type=datetime,name="SENDTIME",dbtype="DATE")
 COLUMN(type=decimal,name="KEZHIXBZ",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="JSPH",dbtype="VARCHAR2(20)")
 COLUMN(type=varchar,name="RECEIVER",dbtype="VARCHAR2(20)")
 COLUMN(type=varchar,name="YIZUOXM",dbtype="VARCHAR2(500)")
 COLUMN(type=varchar,name="BENCIXM",dbtype="VARCHAR2(200)")
 COLUMN(type=varchar,name="TMPRINTER",dbtype="VARCHAR2(20)")
 COLUMN(type=datetime,name="TMPRINTTIME",dbtype="DATE")
 COLUMN(type=decimal,name="CAIJIBZ",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="KSJSR",dbtype="VARCHAR2(20)")
 COLUMN(type=datetime,name="KSJSSJ",dbtype="DATE")
 COLUMN(type=varchar,name="FUJIAXX",dbtype="VARCHAR2(100)")
 COLUMN(type=datetime,name="QBGRQ",dbtype="DATE")
 COLUMN(type=varchar,name="TONGHAO",dbtype="VARCHAR2(20)")
 COLUMN(type=decimal,name="WAISONGBZ",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="CURBQ",dbtype="VARCHAR2(20)")
 COLUMN(type=varchar,name="JIUZHENID",dbtype="VARCHAR2(30)")
 COLUMN(type=varchar,name="SENDERCIRY",dbtype="VARCHAR2(20)")
 COLUMN(type=datetime,name="SENDERCITIME",dbtype="DATE")
 COLUMN(type=varchar,name="BAOCUNRY",dbtype="VARCHAR2(20)")
 COLUMN(type=datetime,name="BAOCUNSJ",dbtype="DATE")
 COLUMN(type=varchar,name="BAOFEIRY",dbtype="VARCHAR2(20)")
 COLUMN(type=datetime,name="BAOFEISJ",dbtype="DATE")
 COLUMN(type=varchar,name="TESTDESCRIBE_JHLB",dbtype="VARCHAR2(600)")
 COLUMN(type=datetime,name="CHECKTIME",dbtype="DATE")
 COLUMN(type=varchar,name="SONGJIANDW",dbtype="VARCHAR2(20)")
 COLUMN(type=decimal,name="SENDFLAG",dbtype="NUMBER(1)")
)
RETRIEVE(statement="PBSELECT(TABLE(NAME=~"L_LABORDER~") COLUMN(NAME=~"L_LABORDER.LABORDER~") COLUMN(NAME=~"L_LABORDER.LABORDERORG~") COLUMN(NAME=~"L_LABORDER.STAYHOSPITALMODE~") COLUMN(NAME=~"L_LABORDER.PATIENTID~") COLUMN(NAME=~"L_LABORDER.SEX~") COLUMN(NAME=~"L_LABORDER.BIRTHDAY~") COLUMN(NAME=~"L_LABORDER.CURRENTDEPARTMENT~") COLUMN(NAME=~"L_LABORDER.CURRENTBED~") COLUMN(NAME=~"L_LABORDER.SPECIMEN~") COLUMN(NAME=~"L_LABORDER.EXAMITEM~") COLUMN(NAME=~"L_LABORDER.TESTDESCRIBE~") COLUMN(NAME=~"L_LABORDER.PATIENTNAME~") COLUMN(NAME=~"L_LABORDER.OUTDATE~") COLUMN(NAME=~"L_LABORDER.PRINTFLAG~") COLUMN(NAME=~"L_LABORDER.RECEIVEFLAG~") COLUMN(NAME=~"L_LABORDER.TYPEFLAG~") COLUMN(NAME=~"L_LABORDER.REQUESTER~") COLUMN(NAME=~"L_LABORDER.REQUESTETIME~") COLUMN(NAME=~"L_LABORDER.EXECUTOR~") COLUMN(NAME=~"L_LABORDER.EXECUTETIME~") COLUMN(NAME=~"L_LABORDER.EMERGENCY~") COLUMN(NAME=~"L_LABORDER.NOTES~") COLUMN(NAME=~"L_LABORDER.PRICE~") COLUMN(NAME=~"L_LABORDER.FREQUENCYTIME~") COLUMN(NAME=~"L_LABORDER.LABDEPARTMENT~") COLUMN(NAME=~"L_LABORDER.DIAGNOSTIC~") COLUMN(NAME=~"L_) COLUMN(NAME=~"L_LABORDER.FEESTATUS~") COLUMN(NAME=~"L_LABORDER.QBGSJ~") COLUMN(NAME=~"L_LABORDER.QBGDD~") COLUMN(NAME=~"L_LABORDER.QBGDT~") COLUMN(NAME=~"L_LABORDER.SAMPLENO~") COLUMN(NAME=~"L_LABORDER.REQUESTMODE~") COLUMN(NAME=~"L_LABORDER.RECEIVETIME~") COLUMN(NAME=~"L_LABORDER.PATIENT_NO~") COLUMN(NAME=~"L_LABORDER.INFANT_FLAG~") COLUMN(NAME=~"L_LABORDER.CANCELTIME~") COLUMN(NAME=~"L_LABORDER.CANCELER~") COLUMN(NAME=~"L_LABORDER.JSBZ~") COLUMN(NAME=~"L_LABORDER.JSNO~") COLUMN(NAME=~"L_LABORDER.EXESJ~") COLUMN(NAME=~"L_LABORDER.JSZ~") COLUMN(NAME=~"L_LABORDER.FSZ~") COLUMN(NAME=~"L_LABORDER.TOPONYMY~") COLUMN(NAME=~"L_LABORDER.CYCLE~") COLUMN(NAME=~"L_LABORDER.QUERENZHE~") COLUMN(NAME=~"L_LABORDER.QURENSJ~") COLUMN(NAME=~"L_LABORDER.FENYUANBH~") COLUMN(NAME=~"L_LABORDER.BEIZHU~") COLUMN(NAME=~"L_LABORDER.RONGQI~") COLUMN(NAME=~"L_LABORDER.CAIXUELIANG~") COLUMN(NAME=~"L_LABORDER.SHUNXUHAO~") COLUMN(NAME=~"L_LABORDER.BINGANHAO~") COLUMN(NAME=~"L_LABORDER.TESHUBZ~") COLUMN(NAME=~"L_LABORDER.RENYUANID~") COLUMN(NAME=~"L_LABORDER.BINGRENID~") COLUMN(NAME=~"L_LABORDER.BINGRENZYID~") COLUMN(NAME=~"L_LABORDER.YINGERID~") COLUMN(NAME=~"L_LABORDER.SENDRY~") COLUMN(NAME=~"L_LABORDER.SENDTIME~") COLUMN(NAME=~"L_LABORDER.KEZHIXBZ~") COLUMN(NAME=~"L_LABORDER.JSPH~") COLUMN(NAME=~"L_LABORDER.RECEIVER~") COLUMN(NAME=~"L_LABORDER.YIZUOXM~") COLUMN(NAME=~"L_LABORDER.BENCIXM~") COLUMN(NAME=~"L_LABORDER.TMPRINTER~") COLUMN(NAME=~"L_LABORDER.TMPRINTTIME~") COLUMN(NAME=~"L_LABORDER.CAIJIBZ~") COLUMN(NAME=~"L_LABORDER.KSJSR~") COLUMN(NAME=~"L_LABORDER.KSJSSJ~") COLUMN(NAME=~"L_LABORDER.FUJIAXX~") COLUMN(NAME=~"L_LABORDER.QBGRQ~") COLUMN(NAME=~"L_LABORDER.TONGHAO~") COLUMN(NAME=~"L_LABORDER.WAISONGBZ~") COLUMN(NAME=~"L_LABORDER.CURBQ~") COLUMN(NAME=~"L_LABORDER.JIUZHENID~") COLUMN(NAME=~"L_LABORDER.SENDERCIRY~") COLUMN(NAME=~"L_LABORDER.SENDERCITIME~") COLUMN(NAME=~"L_LABORDER.BAOCUNRY~") COLUMN(NAME=~"L_LABORDER.BAOCUNSJ~") COLUMN(NAME=~"L_LABORDER.BAOFEIRY~") COLUMN(NAME=~"L_LABORDER.BAOFEISJ~") COLUMN(NAME=~"L_LABORDER.TESTDESCRIBE_JHLB~") COLUMN(NAME=~"L_LABORDER.CHECKTIME~") COLUMN(NAME=~"L_LABORDER.SONGJIANDW~") COLUMN(NAME=~"L_LABORDER.SENDFLAG~"))")
DESTINATION(name="L_LABORDER", COLUMN(type=decimal,name="LABORDER",dbtype="NUMBER(12)")
 COLUMN(type=decimal,name="LABORDERORG",dbtype="NUMBER(10)")
 COLUMN(type=decimal,name="STAYHOSPITALMODE",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="PATIENTID",dbtype="VARCHAR2(40)")
 COLUMN(type=decimal,name="SEX",dbtype="NUMBER(1)")
 COLUMN(type=datetime,name="BIRTHDAY",dbtype="DATE")
 COLUMN(type=varchar,name="CURRENTDEPARTMENT",dbtype="VARCHAR2(10)")
 COLUMN(type=varchar,name="CURRENTBED",dbtype="VARCHAR2(6)")
 COLUMN(type=varchar,name="SPECIMEN",dbtype="VARCHAR2(5)")
 COLUMN(type=varchar,name="EXAMITEM",dbtype="VARCHAR2(500)")
 COLUMN(type=varchar,name="TESTDESCRIBE",dbtype="VARCHAR2(500)")
 COLUMN(type=varchar,name="PATIENTNAME",dbtype="VARCHAR2(50)")
 COLUMN(type=datetime,name="OUTDATE",dbtype="DATE")
 COLUMN(type=decimal,name="PRINTFLAG",dbtype="NUMBER(1)")
 COLUMN(type=decimal,name="RECEIVEFLAG",dbtype="NUMBER(1)")
 COLUMN(type=decimal,name="TYPEFLAG",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="REQUESTER",dbtype="VARCHAR2(20)")
 COLUMN(type=datetime,name="REQUESTETIME",dbtype="DATE")
 COLUMN(type=varchar,name="EXECUTOR",dbtype="VARCHAR2(20)")
 COLUMN(type=datetime,name="EXECUTETIME",dbtype="DATE")
 COLUMN(type=decimal,name="EMERGENCY",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="NOTES",dbtype="VARCHAR2(50)")
 COLUMN(type=decimal,name="PRICE",dbtype="NUMBER(7,2)")
 COLUMN(type=decimal,name="FREQUENCYTIME",dbtype="NUMBER(5)")
 COLUMN(type=varchar,name="LABDEPARTMENT",dbtype="VARCHAR2(10)")
 COLUMN(type=varchar,name="DIAGNOSTIC",dbtype="VARCHAR2(100)")
 COLUMN(type=varchar,name="COMPUTERNAME",dbtype="VARCHAR2(20)")
 COLUMN(type=decimal,name="FEESTATUS",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="QBGSJ",dbtype="VARCHAR2(240)")
 COLUMN(type=varchar,name="QBGDD",dbtype="VARCHAR2(100)")
 COLUMN(type=varchar,name="QBGDT",dbtype="VARCHAR2(100)")
 COLUMN(type=varchar,name="SAMPLENO",dbtype="VARCHAR2(14)")
 COLUMN(type=decimal,name="REQUESTMODE",dbtype="NUMBER(1)")
 COLUMN(type=datetime,name="RECEIVETIME",dbtype="DATE")
 COLUMN(type=decimal,name="PATIENT_NO",dbtype="NUMBER(10)")
 COLUMN(type=decimal,name="INFANT_FLAG",dbtype="NUMBER(1)")
 COLUMN(type=datetime,name="CANCELTIME",dbtype="DATE")
 COLUMN(type=varchar,name="CANCELER",dbtype="VARCHAR2(20)")
 COLUMN(type=decimal,name="JSBZ",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="JSNO",dbtype="VARCHAR2(14)")
 COLUMN(type=varchar,name="EXESJ",dbtype="VARCHAR2(8)")
 COLUMN(type=varchar,name="JSZ",dbtype="VARCHAR2(10)")
 COLUMN(type=varchar,name="FSZ",dbtype="VARCHAR2(10)")
 COLUMN(type=varchar,name="TOPONYMY",dbtype="VARCHAR2(100)")
 COLUMN(type=decimal,name="CYCLE",dbtype="NUMBER(10)")
 COLUMN(type=varchar,name="QUERENZHE",dbtype="VARCHAR2(20)")
 COLUMN(type=datetime,name="QURENSJ",dbtype="DATE")
 COLUMN(type=varchar,name="FENYUANBH",dbtype="VARCHAR2(20)")
 COLUMN(type=varchar,name="BEIZHU",dbtype="VARCHAR2(100)")
 COLUMN(type=varchar,name="RONGQI",dbtype="VARCHAR2(10)")
 COLUMN(type=varchar,name="CAIXUELIANG",dbtype="VARCHAR2(20)")
 COLUMN(type=decimal,name="SHUNXUHAO",dbtype="NUMBER(6)")
 COLUMN(type=varchar,name="BINGANHAO",dbtype="VARCHAR2(10)")
 COLUMN(type=decimal,name="TESHUBZ",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="RENYUANID",dbtype="VARCHAR2(30)")
 COLUMN(type=varchar,name="BINGRENID",dbtype="VARCHAR2(10)")
 COLUMN(type=varchar,name="BINGRENZYID",dbtype="VARCHAR2(10)")
 COLUMN(type=varchar,name="YINGERID",dbtype="VARCHAR2(10)")
 COLUMN(type=varchar,name="SENDRY",dbtype="VARCHAR2(10)")
 COLUMN(type=datetime,name="SENDTIME",dbtype="DATE")
 COLUMN(type=decimal,name="KEZHIXBZ",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="JSPH",dbtype="VARCHAR2(20)")
 COLUMN(type=varchar,name="RECEIVER",dbtype="VARCHAR2(20)")
 COLUMN(type=varchar,name="YIZUOXM",dbtype="VARCHAR2(500)")
 COLUMN(type=varchar,name="BENCIXM",dbtype="VARCHAR2(200)")
 COLUMN(type=varchar,name="TMPRINTER",dbtype="VARCHAR2(20)")
 COLUMN(type=datetime,name="TMPRINTTIME",dbtype="DATE")
 COLUMN(type=decimal,name="CAIJIBZ",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="KSJSR",dbtype="VARCHAR2(20)")
 COLUMN(type=datetime,name="KSJSSJ",dbtype="DATE")
 COLUMN(type=varchar,name="FUJIAXX",dbtype="VARCHAR2(100)")
 COLUMN(type=datetime,name="QBGRQ",dbtype="DATE")
 COLUMN(type=varchar,name="TONGHAO",dbtype="VARCHAR2(20)")
 COLUMN(type=decimal,name="WAISONGBZ",dbtype="NUMBER(1)")
 COLUMN(type=varchar,name="CURBQ",dbtype="VARCHAR2(20)")
 COLUMN(type=varchar,name="JIUZHENID",dbtype="VARCHAR2(30)")
 COLUMN(type=varchar,name="SENDERCIRY",dbtype="VARCHAR2(20)")
 COLUMN(type=datetime,name="SENDERCITIME",dbtype="DATE")
 COLUMN(type=varchar,name="BAOCUNRY",dbtype="VARCHAR2(20)")
 COLUMN(type=datetime,name="BAOCUNSJ",dbtype="DATE")
 COLUMN(type=varchar,name="BAOFEIRY",dbtype="VARCHAR2(20)")
 COLUMN(type=datetime,name="BAOFEISJ",dbtype="DATE")
 COLUMN(type=varchar,name="TESTDESCRIBE_JHLB",dbtype="VARCHAR2(600)")
 COLUMN(type=datetime,name="CHECKTIME",dbtype="DATE")
 COLUMN(type=varchar,name="SONGJIANDW",dbtype="VARCHAR2(20)")
 COLUMN(type=decimal,name="SENDFLAG",dbtype="NUMBER(1)")
)
#3
呀儿呼嘿哟2015-05-22 10:55
缺少什么关键字啊？
1
©2024, BCCN.NET
电脑版