Reader Feedback and Insights: One-Row Table Still Needed

December 6, 2002 Timothy Prickett Morgan

Hey, Ted:

In the article, “Overlooking the Obvious,” which published in the November 8 issue of Midrange Guru, you asked the question, “does anybody have a use for a one-row, one-column table?”

I’ll still need one for the near future.

• I don’t have a C compiler or interactive SQL, so I’m stuck without variables.
• I run a lot of test scripts initially in Operations Navigator (cwbundbs), and it’s handy for testing the duration of things:

select 'start',now() from onerec;
update some long thing with a few statements;
select 'end',now() from onerec;

ONEREC is my one-row table. I created it before you published your tip.

It’s also handy to have a one-row table when I need to test an ODBC or OLE or DDM connection in some fashion. It’s faster and easier to display or update ONEREC than a real table.

— Scott

Sponsored By ADVANCED SYSTEMS CONCEPTS

Business Analytics – Practical – – Cost Effective – – Easy to Deploy – SEQUEL FYI User Quote: “I love SEQUEL FYI because it lets me look at the data any way I need to see it, instantly. This is the easiest tool to manage complex product relationships that I have ever seen.” SEQUEL FYI offers outstanding OLAP business intelligence functionality for a fraction of the cost of comparable solutions. Read More > View Streaming Video