Hi
At work we're doomed to use something called Winsql to trawl through a pretty large DB/2 database of financial transactions.
There has frankly got to be something better out there than this, brief list of gripes:
- The drop-down list for changing from one search window to another is as small as possible, so when you have 6 or so windows open, the only way to navigate back to a set of data you've pulled up, and are trying to use to compare against info from another table, is a to figure out which of the 6 dropdown options all named "set schema..." is the one you want.
- When you start a search, it cannot be stopped until it starts displaying data, so if you realised you have a terrible logic error, you can't do anything except wait for it to finish, or alt-ctrl-del
- Can't search through multiple schema's for a particular table name
- When you're displaying a list of schema's/tables, it won't show any example data, so if numbers are being stored as text or numbers, you don't know until you start pulling out examples. As a result of this and because the the db has been a work in progress for years, there may be multiple tables named "payments", you won't know which one is current and in use until you start pulling out info.
Any recommendations for better programs? We also use SQL developer for Oracle stuff, but it's not needed nearly as often so any limitations aren't as apparent.
Thanks
At work we're doomed to use something called Winsql to trawl through a pretty large DB/2 database of financial transactions.
There has frankly got to be something better out there than this, brief list of gripes:
- The drop-down list for changing from one search window to another is as small as possible, so when you have 6 or so windows open, the only way to navigate back to a set of data you've pulled up, and are trying to use to compare against info from another table, is a to figure out which of the 6 dropdown options all named "set schema..." is the one you want.
- When you start a search, it cannot be stopped until it starts displaying data, so if you realised you have a terrible logic error, you can't do anything except wait for it to finish, or alt-ctrl-del
- Can't search through multiple schema's for a particular table name
- When you're displaying a list of schema's/tables, it won't show any example data, so if numbers are being stored as text or numbers, you don't know until you start pulling out examples. As a result of this and because the the db has been a work in progress for years, there may be multiple tables named "payments", you won't know which one is current and in use until you start pulling out info.
Any recommendations for better programs? We also use SQL developer for Oracle stuff, but it's not needed nearly as often so any limitations aren't as apparent.
Thanks
