Tip Bank

Question: How can we specify in a select statement to get first “n” records from the result set? E.g., select * from employee order by emp_num I just want the

Question: I am using Hyperscript Tools for Informix on a Unix platform. To receive the current date and time, the NOW() function is used to get a value between 0

Question: Does Informix 9.20 have a memory leak? We’ve doubled our physical memory since upgrading, taken a number of tuning actions, but the product keeps grabbing more memory. No appreciative

Question: When in production (several users), my Web application starts getting empty cursors when querying the Informix server. I’m sure the ‘right’ results are not empty. Also, I’ve seen, using

Question: What is the best way to backup and/or unload a table and restore/reload to a new dbtable with new extents? Answer: If you have enough drive space, do an

Question: How do I combine multiple text fields into a single field? For example, combining someone’s first, middle, and last name into a field called “full name”. I’ve done a

Question: When I use the BROWSE command it always displays the results in a normal window. Is there a command to maximize the browse window in the program? Answer: The

Question: I want to construct an SQL query or stored procedure that will order its result set based on a query parameter. Something like: SELECT *FROM customersORDER BY ? Unfortunately,

Question: I am using SQL Server 7 and would like to convert an uppercase string to proper case. Is there an easy way to do it? Answer: SQL Server has