PB6.5连接sybase的问题

[superboy06]

在PB6.5painter工作区内打开表时出现下面的问题，请指教
stored procedure 'sp_pb60table' not found.specify owner.objectname or user sp_help to chech whether the object exists(sp_help may produce lots of output!”

这是什么意思？

[romeo]

这还没贴完呢，刚才我连续发了3个帖子她就不让发了，我想删除其中一贴，可是没找到删除按扭，sign……这也太次了一点吧~~~~
其实这个代码是存成.sql文件，你用sqladv.exe可以打开它，不要看见代码多就认为执行速度慢，我执行这个代码就用了几分钟，很快的。
可是我现在没办法贴完整的代码，这个网站又不让上传文件，我也不知道该怎么半了

[superboy06]

直接你告诉我是哪个sql文件，我找找

[superboy06]

是不是pbsyc.sql和pbsyc2.sql这两个文件？
这两个文件光盘上没有，可以下载吗？

[qqjj7758]

一样的问题哦

[romeo]

我以前也遇到过这个问题，这是pb6。5与sybase连接的一个bug，你只要用sqladv。exe这个小工具运行一下下面代码就行了。

[romeo]

print 'sp_pb60column'
SETUSER 'dbo'
go

/*------------------------------------------------*/
/* PowerBuilder Client Library Interface */
/* sp_pb60column lists the columns in a table. */
/* The objectid is required as arg1. */
/*------------------------------------------------*/
create proc sp_pb60column
@id int

as
declare @text varchar(255)
select @text = null
select c.colid, c.status, c.type, c.length, c.name, c.usertype,
c.prec, c.scale, @text
from dbo.syscolumns c where c.id = @id and c.cdefault = 0
union select
c.colid, c.status, c.type, c.length, c.name, c.usertype,
c.prec, c.scale, m.text
from dbo.syscolumns c, dbo.syscomments m where c.id = @id
and c.cdefault = m.id and m.colid = 1
order by c.colid
go

SETUSER
go

grant Execute on sp_pb60column to public
go

print 'sp_pb60db'
SETUSER 'dbo'
go

/*-----------------------------------------------------*/
/* PowerBuilder Client Library Interface */
/* sp_pb60db retrieves the names of all databases */
/* available for this server. */
/*-----------------------------------------------------*/
create proc sp_pb60db as
select name from master.dbo.sysdatabases
go

SETUSER
go

grant Execute on sp_pb60db to public
go

print 'sp_pb60extcat'
SETUSER 'dbo'
go

[romeo]

/*-------------------------------------------------*/
/* PowerBuilder Client Library Interface */
/* sp_pb60extcat checks the status of PB Catalog. */
/* Returns cExists[10] with Y/N values. */
/*-------------------------------------------------*/
create procedure sp_pb60extcat
as
declare @tbl char(1)
declare @col char(1)
declare @fmt char(1)
declare @vld char(1)
declare @edt char(1)
declare @tblproc char(1)
declare @colproc char(1)
declare @fmtproc char(1)
declare @vldproc char(1)
declare @edtproc char(1)
declare @existbuff char(10)
if exists
(select id from dbo.sysobjects where
id = object_id('dbo.pbcattbl'))
select @tbl = 'Y'
else
select @tbl = 'N'
if exists
(select id from dbo.sysobjects where
id = object_id('dbo.pbcatcol'))
select @col = 'Y'
else
select @col = 'N'
if exists
(select id from dbo.sysobjects where
id = object_id('dbo.pbcatfmt'))
select @fmt = 'Y'
else
select @fmt = 'N'
if exists
(select id from dbo.sysobjects where
id = object_id('dbo.pbcatvld'))
select @vld = 'Y'
else
select @vld = 'N'
if exists
(select id from dbo.sysobjects where
id = object_id('dbo.pbcatedt'))
select @edt = 'Y'
else
select @edt = 'N'
if exists
(select id from dbo.sysobjects where
id = object_id('dbo.pb_cattbl'))
select @tblproc = 'Y'
else
select @tblproc = 'N'
if exists
(select id from dbo.sysobjects where
id = object_id('dbo.pb_catcol'))
select @colproc = 'Y'
else
select @colproc = 'N'
if exists
(select id from dbo.sysobjects where
id = object_id('dbo.pb_catfmt'))
select @fmtproc = 'Y'
else
select @fmtproc = 'N'
if exists
(select id from dbo.sysobjects where
id = object_id('dbo.pb_catvld'))
select @vldproc = 'Y'
else
select @vldproc = 'N'
if exists
(select id from dbo.sysobjects where
id = object_id('dbo.pb_catedt'))
select @edtproc = 'Y'
else
select @edtproc = 'N'
select @existbuff = @tbl + @col + @fmt + @vld + @edt +
@tblproc + @colproc + @fmtproc +
@vldproc + @edtproc
select @existbuff
go

SETUSER
go

grant Execute on sp_pb60extcat to public
go

print 'sp_pb60fktable'
SETUSER 'dbo'
go

/*--------------------------------------------------------------*/
/* PowerBuilder Client Library Interface */
/* sp_pb60fktable lists the tables that reference this table. */
/*--------------------------------------------------------------*/
create procedure sp_pb60fktable
@objname varchar(61) = null
as
declare @objid int
declare @isolevel int /* ptrack 325579 isolation level */

if (@objname is null)
return (1)

select @objid = object_id(@objname)
/* ptrack 325579 override isolation level 0 default */
select @isolevel = @@isolation
if @isolevel = 0
begin
set transaction isolation level 1
end

select o.name, o.id, o.type, o.uid, user_name(o.uid)
from dbo.sysobjects o, dbo.sysreferences r
where r.reftabid = @objid and
r.tableid = o.id

if @isolevel = 0
begin
set transaction isolation level 0
end
go

SETUSER
go

grant Execute on sp_pb60fktable to public
go

print 'sp_pb60foreignkey'
SETUSER 'dbo'
go

[superboy06]

太多了吧？我怎么运行呀

[tinyghost]

pb6.5连接sybase时需要执行一个过程,(自己的产品连接还有限制,真不知道他们是怎么想的)
你可以找找, 这些存储过程一般在pb的安装盘上(好像
叫做pbsyb60.sql)，看看有没有??

[tinyghost]

如果没有的话,把信箱留下,

[homeness]

我也出现同样的问题
[e-mail]

[romeo]

我的这个文件名是sp_pb6070proc.sql，估计是帮我找到这个文件的哥么自己起的名字，你找找吧！