peteryangsf 发表于 2009-12-09 18:49

informix dbschema导出问题

使用dbschema命令导出表结构时，提示-284 - A subquery has returned not exactly one row.informix@SMP2> dbschema -d sms@idssmp2-t all -s all -ss sms_dbschema.sql

DBSCHEMA Schema Utility       INFORMIX-SQL Version 7.30.UC7
Copyright (C) Informix Software, Inc., 1984-1998
Software Serial Number AAC#J605196
-284 - A subquery has returned not exactly one row.
informix@SMP2> tail -100 sms_dbschema.sql
...
create cluster index "smp2".index_1 on "smp2".db_test (field_one);
   
{ TABLE "smp2".pn_cancel_log row size = 129 number of columns = 18 index size = 27
            }
create table "smp2".pn_cancel_log
(
    serialno serial not null ,
    canceltime char(14),
    usernumber char(15),
    operatorname char(20),
    hardwareno char(14),
    usertype integer,
    cancelamount integer,
    activetype integer,
    barringflag integer,
    callbarring integer,
    undisturb integer,
    msgsend integer,
    vmswitch integer,
    timeroutestate integer,
    forwardseq integer,
    settype integer,
    lastmonthconsume integer,
    arreartime char(14)
) extent size 16 next size 16 lock mode page;
revoke all on "smp2".pn_cancel_log from "public";

vbirding 发表于 2009-12-11 16:46

会不会是因为sms@idssmp2这个资料库中根本没有synonym的原因？

peteryangsf 发表于 2009-12-13 14:22

有的。比如ACR_RECORD表就是某个ACR_RECORD_YYYYMM的synonym。
页: [1]
查看完整版本: informix dbschema导出问题