Recent content by bschechter

We definitely could create a stored procedure for this work. The problem is that we do not seem to be able to come up with a syntax for the drop index statement that works even if the user is dba. If you know of a set of stored procedure commands that would work for our situation, it would...

If we create the index using syntax, CREATE INDEX index1 on dba.table1 We can not drop the index using if we are connected as dba: DROP INDEX table1.index1 It works if we leave the dba out when creating the table. It appears that the table is then created as dbo owner.

Yes. We have only one connection to DBMS (SQLCA) that we are using for all the SQL. Brian

Starg, Yes SYBASE does not like the syntax if we use: DROP INDEX dba.table1.index1 And SYBASE can not find the object if we use: DROP INDEX table1.index1 Regards, Brian

SYBASE ASE only requires index names to be unique for a particular table. In fact, many tables in our schema have the same index name, so we need to indicate which table.

Ladies and Gentlemen, We want to drop and recreate indexes via PowerBuilder powerscript using SYBASE ASE 12.0, but we are having problems with the drop side. We can create them using: ls_sql = "CREATE INDEX index1 on dba.table1" EXECUTE IMMEDIATE :ls_sql; However the drop SQL does...

Ladies and Gentlemen, We want to drop and recreate indexes in powerscript using SYBASE ASE 12.0, but we are having problems with the drop side. We can create them using: ls_sql = "CREATE INDEX index1 on dba.table1" EXECUTE IMMEDIATE :ls_sql; However the drop SQL does not work...

I select a datawindow object on the library painter. This brings up the print options dialog. I select only the 4 script options and hit print. However I allows get all the sections (pictures, attributes, etc)? How can I eliminate these sections?