×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Forgive my cluelessness, but I don't understand what you are trying to
accomplish. I understand that Rob's suggestion works for you, and I'm
glad for that, but for my own edification, I'd like to follow up a
little:
I can conceptualize three components or aspects of what you *might* be
trying to do: (1) get data into a table that lives in QTEMP, (2) have
that insertion show up in a journal, (3) have the insertion not "take
effect" until explicit commit.
Even before you got any help from Rob, it sounded like you had no
trouble with (1), based on the following:
I can use the "with none" clause to insert a row into a table in QTEMP using SQL INSERT.
But I can't tell if you are even trying to accomplish (2) or (3). Or
perhaps something else entirely. And I can't tell what the global
temporary table gets you that you didn't have before. Note that I
don't fully understand global temporary tables either. From what I can
gather, they seem kind of like a pure-SQL construct which provides the
same behavior as what traditional midrange programmers would use QTEMP
files for. (Each job gets its own; when the job ends, it goes away.)
John Y.
midrange.com
