• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • 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

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: mgo_rc, Volume 2, Number 91 -- December 6, 2002

    Sponsored by
    Rocket Software

    Disrupt Without Disruption

    For over 35 years, Rocket Software’s solutions have empowered businesses to modernize their infrastructure, unlock data value, and drive transformation – all while ensuring modernization without disruption.

    Learn How

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    LIKE is Like, Confusing, Man! SBMJOB’s RQSDTA Parameter

    Leave a Reply Cancel reply

MGO Volume: 2 Issue: 91

This Issue Sponsored By

    Table of Contents

    • Reader Feedback and Insights: One-Row Table Still Needed
    • Get Rid of Old IFS Files, Take Two
    • Performance of the SQL LIKE Predicate

    Content archive

    • The Four Hundred
    • Four Hundred Stuff
    • Four Hundred Guru

    Recent Posts

    • To Comfort The Afflicted And Afflict The Comfortable
    • How FalconStor Is Reinventing Itself, And Why IBM Noticed
    • Guru: When Procedure Driven RPG Really Works
    • Vendors Fill In The Gaps With IBM’s New MFA Solution
    • IBM i PTF Guide, Volume 27, Number 27
    • With Power11, Power Systems “Go To Eleven”
    • With Subscription Price, IBM i P20 And P30 Tiers Get Bigger Bundles
    • Izzi Buys CNX, Eyes Valence Port To System Z
    • IBM i Shops “Attacking” Security Concerns, Study Shows
    • IBM i PTF Guide, Volume 27, Number 26

    Subscribe

    To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

    Pages

    • About Us
    • Contact
    • Contributors
    • Four Hundred Monitor
    • IBM i PTF Guide
    • Media Kit
    • Subscribe

    Search

    Copyright © 2025 IT Jungle