|
From: Gerd W. <bir...@t-...> - 2006-08-17 09:53:26
|
Hi Melinda, when using sql2ins SQuirreL just doesn't care for the row limit. I'm not even sure if it should. Perhaps it will be switchable one day. Most SQL dialects allow to limit rows using a special SQL syntax quite often this is like "select top 20 * from table_a" on db2 it is "select * from table_a fetch first 20 rows only". Hope this helps. Gerd Savoy, Melinda wrote: > I started using Squirrel SQL Client Version 2.2 final a couple of months > ago and it works great. We're having to connect to a M204 database, > something weird, and I am having a problem whereby I have written a > simple select statement in the SQL editor and set the "Limit rows:" to > 20 and pressed the CTRL-T key to get to the tools and select "sql2ins" > and hit the enter key. > > However I am getting 138 records (rows) back instead of the 20. > > Any direction or help would be appreciated. > > Thanks. > > Melinda Savoy > Sr. Programmer Analyst > Enterprise Systems > > > The information contained in this message and any attachments is > intended only for the use of the individual or entity to which it is > addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL, > and exempt from disclosure under applicable law. If you are not the > intended recipient, you are prohibited from copying, distributing, or > using the information. Please contact the sender immediately by return > e-mail and delete the original message from your system. > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > Using Tomcat but need to do more? Need to support web services, security? > Get stuff done quickly with pre-integrated technology to make your job easier > Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 > > > ------------------------------------------------------------------------ > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
