I am working in Sybase. I am using Embarcadero Rapid SQL version 7.4.2 to connect and manipulate my databases. The issue is whenever i try to extract a stored procedure: it doesn't come out right. When i state this, i mean something as follows (in the order they appear)
IF OBJECT_ID('dbo.abc') IS NOT NULL
DROP PROCEDURE dbo.pr_abc
IF OBJECT_ID('dbo.pr_abc') IS NOT NULL
PRINT '<<< FAILED DROPPING PROCEDURE dbo.pr_abc >>>'
PRINT '<<< DROPPED PROCEDURE dbo.pr_abc >>>'
CREATE PROCEDURE pr_GetRules
@DN VARCHAR( 200 ) = NULL,
@CN VARCHAR( 200 ) = NULL,
@RN VARCHAR( 200 ) = NULL,
@RT VARCHAR( 200 ) = NULL,
@RuT VARCHAR( 200 )0 ) = NULL,
@ReT VARCHAR( 200 ) = NULL,
@PI INT = NULL,
which anyone could say is not correct. My question is: How to solve this issue? Has anyone encountered this before? Please share...
Second question: As i am totally new to Embarcadero Rapid SQL. Please suggest as where am i going worng to write a simple "select" statement. I connect to the Datasource>then select the database>then go to >file> new> write a statement select * from abc .which inturn throws an error Number(208) Severity(16)State(1): table not found.