CR #426349
Description: Enterprise Explorer and Database Explorer may show stored procedures as user-defined functions when you create a new Sybase IQ 12.5 or Adaptive Server Anywhere 9.0.2 database from an existing database server.
Workaround: After you create the database, and before you run any existing stored procedures or functions, run asa_sql.sql to correct the display. This script is in the directory where jConnect 6 is installed.
Correctly displaying IQ 12.5 or ASA 9.0.2 stored
procedures and functions
In Database Explorer, right-click the newly created Sybase ASIQ or ASA connection profile, and choose Connect from the context menu.
From the main menu bar choose Window | Preferences, expand Sybase, Inc. and Database Development in the left frame of the Preference dialog box, and choose Connection Level Options.
In the Sybase IQ_12.6.x or Adaptive Server Anywhere_9.x tab, click the Quoted identifier check box, then click Apply and OK.
Click on the main toolbar in the Database Development perspective.
In the Choose a .sql File to Execute dialog box, browse to the appropriate sql_asa.sql script:
For IQ, browse to: <jConnect-6_installation_directory>\sp, and open sql_asa.sql.
For ASA, browse to: <sybase_installation_directory>\WorkSpace\DevRuntimes\ASA \scripts, and open sql_asa.sql.
In the Select Profile for the Editor dialog box, enter the appropriate database type:
For IQ, enter Sybase
IQ_12.6.x for Database type.
For Adaptive Server Anywhere, enter Adaptive
Server Anywhere_9.x for database type.
Enter the newly created ASIQ or ASA profile name for the connection profile name, and click OK.
Ignore any error dialogs that indicate tables are in use or already exist, and click OK to continue executing the SQL file. Database Explorer and Enterprise Explorer show stored procedures and user-defined functions correctly.
Choose Window | Preferences, expand Sybase, Inc. and Database Development, and choose Connection Level Options. In the Sybase IQ_12.6.x or Adaptive Server Anywhere_9.x tab, click the Quoted identifier check box to restore its original setting. Click Apply and OK.
