ASE Isql: Sybase ASE isql (SQL Advantage replacement)

ASE Isql: Sybase ASE isql (SQL Advantage replacement)

Why? As for me, the SQL Advantage is not handy. So I decide to create my own ASE Isql.

Note: project has been moved to code.google.com/p/aseisql

Features:
- Unicode support (UTF8)
- Marker management.
- Folding: expand/collapse BEGIN-END sections.
- SQL object context menu (like "Open procedure" if proc name is selected).
- Trigger support
- Now Sybase debugger (sqldbgr) integrated
- Read carefully What's New section because it's the only HELP document for this product.
Screenshot:

Download : please visit the new project home downloads

Known Issues

ASE ISQL will not connect to a Sybase database using the Sybase 15 client.
o Workaround: In the Sybase 15 release, Sybase renamed libct.dll and libcs.dll to libsybct.dll and libsybcs.dll, respectively. Sybase has provided a batch command that will rename the files to pre-15 names. It's located in c:\sybase_client_install_folder\locs-15_0\scripts and the file name is copylibs.bat

Future plans:

Autocompletion with object/column names
Working on Resultsets in text mode...
SCC support for files.
still Thinking about workspace...

Whats New:

2007-11-19
Corrected: comma was absent in Table DDL if more then one constraint.
2007-11-01
Corrected "Tools\Export Data to SQL": Exported files contains zero char.
Corrected: Procedures saved from the database into a file, has no final "go".
2007-10-12
Corrected "Tools\Export Data to SQL" menu.
Added "Encrypt Password" connection parameter.
2007-10-02
New: Information tab-page on the connection screen. Displays sybase client version and environment information.
Bug corrected: re-execute menu has been disabled.
Removed calling of sp_server_info procedure.
2007-09-13
New: menu "Tools\Export Data to SQL" that allows to export data from needed tables to sql insert statements (restriction: 32k per row data).
2007-07-20
New: Find dialog now initiated with text selected in the editor.
New: "Find Selected" item added in the editor context menu.
New: "View - Show Spaces" menu item.
Bug corrected: Hangs if "Suicide process" used.
2007-07-11
New: if "for browse" clause specified in the select, then resultset will be named by the name of the first table in "from" clause (I did not found other way to get table name for the resultset)
New: added "View Data top 100" menu item for tables, views, ...
2007-06-15
Bug corrected: "View Process" sql absent in stubs.sql
New: Objects in browser displayed with owner name (to support not only dbo user).
New: Table DDL sql modified to support tables of different users (here could be some bugs).
2007-06-14
Moved query for "View Processes" menu to stubs.sql. Now you can customize it by overwriting it in ustubs.sql.
New: If ustubs.sql is located in the same directory AseIsqlSetup.exe then setup will use it during installation. This is to create common ustubs.sql for your company.
2007-06-11
New: It's possible to change format of DateTime data types from NATIVE to SQL (YYYY-MM-DD hh:mm:ss)
2007-06-04
New: F5 key shortcut to reExecute query
New: Valid space sizes 3-12 (requested by SqlAdvantage users)
New: Copy templates and columns activated for views
2007-05-11
New: parameter for tab size added
New: added two columns into "process view": physical_io, logged_in_datetime
2007-04-19
Bug corrected: sp_showplan has been executed with wrong number of parameters
2007-04-11
Bug corrected in index for table ddl generation (problem with unique,clustered)
Info: Stupid behavior of PB10: if during cursor execution there is a server warning incoming, then PB breaks the cursor each 100 fetches.
2007-03-21
Extended history up to 26 items (englisg alphabet)
pbacc100.dll included into a delivery for "vista x64"
2007-03-19
Corrected getting of the server names, so, now correctly working with LDAP.
Corrected retrieving of the time datatype (truncated before).
2007-03-11
The key shortcut (ESC) for "canceling the resultset" and "reseting filter" appeared to be the same, so, now if you use filter, there is a small button appeared that resets the filter.
New option parameter "Font" for the resultset.
2007-03-02
PB Code Problem: extremly slow string parsing algorithm now optimized, but it seems it's still slow and I have to rewrite it using C++...
2007-02-27
Bug corrected: there was an error in command terminator parser. "go" inside comment block has been recognized as terminator.
2007-01-25
Toolbar moving now enabled.
Added a new connection parameter "Hostname".
2007-01-18
Bug corrected: the name of the stored procedure was not displayed in server messages (print or error).
2007-01-16
Bug corrected: when retrieving compute, resultset disappeared.
2007-01-13
Change the work with float and real datatypes. Not using cs_set_convert(ctx, CS_SET, CS_FLOAT_TYPE, CS_CHAR_TYPE,&ConvertFloat2Char) because in different versions of ctlib there are different bugs.
From now the display format for float and real is "%g.18"
The SQL for "Kill Process" now moved to stubs.sql file. So you can override it by your own (for example execute sp_kill with special rights )
2006-12-18
Sybase 15.0 bug: with utf8 charset the query select colid,char_length(text),text from syscomments where id=object_id('...') ORDER BY colid2,colid returns wrong char_length for char fields ended with space. Removed ORDER BY to retrieve object text to avoid this bug.
2006-12-04
corrected bug of sybase client: if we are connected to the unicode server with nonunicode charset, and there are some chars that could not be converted, sybase will not add null terminated char
2006-11-28
corrected bug of powerbuilder: if charset=utf8 then old-version datawindows sometimes has strange message.
corrected resultset view for the nonstandard font size (120 and more DPI)
added Escape shortcut for resultset canceling.
2006-11-23
Dll missing in the delivery (GdiPlus.dll)
Used English language for help compilation (before it was Russian).
2006-11-20
Bug corrected: during file save as ansi used system charset instead of user charset (bug of PowerBuilder).
2006-11-15
corrected debug for unicode version.
toolbar divided on two parts: common and database.
2006-11-03
New: UNICODE!!!. Finally. Editor is all the time in unicode. Conversion ANSI-Unicode-ANSI done during file and database operations.
New: Receive drag and drop files into editor.
New: Connection profiles.
2006-07-01
New: sql datatype displayed in tooltip over column name
2006-06-05
New: Highlighted database selection in the status bar... A lot of people can't find it
New: Added database selection in object browser
New: "Save" icon "greyed out" when editor is at the "save point".
Bug corrected: If a query is currently running, and you double-click the results-tab while it is still running, the program will crash.
Minor corrections
2006-05-26
Minor corrections
2006-04-11
New: Ctrl+New Session = Duplicate Session
2006-04-03
New: A test version of the workspace save/load.
New: Find in the resultset.
New: Cancel ALL resultsets support.
Coloring corrections.
2006-02-06
New: On "Query" save, open saved file in a separated tab.
2006-02-06
New: if Shift is pressed during open object (procedure, trigger), then it will be opened in background.
New: Ctrl+Space inserts the predefined construction from the Stubs (stubs.sql and ustubs.sql): type "select" or "cursor" in the editor and press Ctrl+Space
New: Ctrl+Click on the stored procedure or view opens this object
2006-01-28
New: server information in the tooltip over server name in the status bar.
New: Current charset information in the statusbar (on servers under version 12.0 not updated after command execution).
New: now you can use meta characters of operator like in the object search.
New: you can use object filter instead of object search.
Changed shortcut for "Delete Line" to Ctrl+L
Ctrl+Y now used for Redo action
Added save ressources screen.
2005-11-27
New: Sybase debugger (sqldbgr) integrated ... ( found some bugs in it. read help before using. )
New: Help (ASE Quick reference).
New: word chars now include '@' symbol.
New: Installation created.
2005-09-30
New: continue with connection if database not found.
New: Comment/Uncomment selected block.
New: some context menu items moved to stubs.sql and ustubs.sql files. Now you can add your custom items into ustubs.sql
Example:
```
--<Menu\Column information>--
--EX: U,P
exec col '%PARM:Object name%'
```
U,P means that this item is valid only for User tables and Stored procedures.
2005-09-08
Bug corrected: result set copy bugs corrected.
2005-09-06
New: Copy Headers for result set.
New: Copy Comma Delimited Data for result set if one column is selected.
2005-08-29
Bug corrected: config search limit ignore.
Bug corrected: Find/Replace dialogs could be opened at the same time.
New: New option "Save file on execute".
New: Delete current line (Ctrl+Y).
New: Execute current line (Alt+F9).
2005-07-25
Bug corrected: No cursor hscroll.
2005-07-25
Bug corrected: No browser refresh on database change
2005-07-24
New: Move options into separated dialog. Allow to customize font and colors.
New: Substitute NULL value with a custom string like "<NULL>".
New: Resultset column width autosize.
New: Add current tabpage name into a main window title.
New: Prompt to save changed object/file.
New: Separate "Save" and "Save As..." actions for files.
New: Find/Replace dialog.
New: File roots in object browser (to be extended in the future).
New: Select, Insert, Update templates in the table context menu.
New: Show/Hide Log (Alt+2).
New: Show/Hide Browser (Alt+3).
Features not documented in the past:
Resultset: Alt+Left Click on header = Sort (String sort!)
Resultset: Alt+Left Click on value = Fast filter (keep the rows that contains only clicked value). Escape to reset filter.
Editor: Alt+Mouse select = Select vertical block
2005-02-01
Added a check for object edit page (procedure, view, trigger) if it contains "create object" script.
Bug corrected: if no exec is on, ASE Isql could hang or crash.
Bug corrected: float datatype supported in resultsets
New: compute by support
New: Auto reconnect after suicide process
2005-01-27
New command line parameters: -Sserver -Ddatabase -Uuser -Ppassword -Jcharset
Bug corrected: application crash when rightclick on a resultset when disconnected
2004-12-03
Bug corrected: system error on log double click (if object was selected).
2004-11-15
Triggers are included in the browser as a separate folder (same level as User Tables).
Views have the "Open View" option, allowing the user to see/modify the SQL that created the view.
Size of retrieval buffer (maximum data size) = 32767.
Now supports Sybase 12.5 "long char" data retrieval (if you have 12.5 client installed).
PowerBuilder 9.0 used to compile this application (for Sybase 12.5 client support).
2004-11-01
Now Line Endings option affect only on file save and on script execution.
Added information about line endings to the status bar. You can click on it to change.
2004-10-27
Added Line Endings option (Windows/Unix).
2004-10-26
This log was started.

Created by Dmitry Lukyanov dlukyanov@ukr.net

top | control panel