Chinaunix

标题: ASE 12.5数据库做Generate database objects DDL出错！ [打印本页]

作者: ahua 时间: 2004-12-24 14:23
标题: ASE 12.5数据库做Generate database objects DDL出错！
我在用sybase central工具，对数据库做Generate database objects DDL提示：

server massage number:209
Ambiguous column name crdate!

数据库是ASE 12.5
有哪位知道这是什么问题吗？

作者: jasonshan 时间: 2004-12-24 14:49
标题: ASE 12.5数据库做Generate database objects DDL出错！
是对数据库还是对表或trigger做Generate DDL？
你有哪个表包含了crdate吗？那个表上有没有view、trigger之类的东东？检查一下吧，估计是哪个view或trigger或proc里的命令有点问题，同时连立了两个表，而两个表都有crdate字段
你可以分步Generate，先做所有表的、然后是view、proc、trigger，看哪一步出问题

作者: ahua 时间: 2004-12-24 15:12
标题: ASE 12.5数据库做Generate database objects DDL出错！
是对数据库，有太多表了，检查会晕的。我在网上搜了一下，有人也遇到过一样的问题，回复者的意思是老版本的CENTRAL有问题，要用12.5以后的版本，我找半天也找不着。
Re: ambiguous column name crdate

--------------------------------------------------------------------------------

Liza, A.S wrote:
  >;
  >; Hi,
  >;
  >; I try to generate the ddl and receive this error. What
  >; should I do?
  >;
  >; Thanks in advance.

In 12.5, a "crdate" field was added to sysindexes. Queries doing a join
between sysobjects and sysindexes that didn't specify the source of the
crdate field will raise this error. This is a particular problem using
older versions of Sybase Central against ASE 12.5. If that is what you
are
using, install a 12.5 version of Sybase Central.

-bret

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)