×
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.
what exactly would make it fail on the first rename when you are building
the INSERT on the fly? here is a sample program i wrote years ago that
does this type of thing and haven't had a problem ever...
http://code.midrange.com/694959ec58.html
Thanks,
Tommy Holden
From: "Dennis Lovelady" <iseries@xxxxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 03/16/2010 07:44 AM
Subject: RE: Select mytable name from mytable?
Sent by: midrange-l-bounces@xxxxxxxxxxxx
file names but the same thing would work) create the output table with
an
additional field, do your insert with blanks in the column for the
table
An interesting approach, but it will fall apart on the first file rename.
One thing you might do, though, (after adding that column) is have a
BEFORE
READ trigger on such a table, and the BEFORE READ would fill in the
column.
Then it wouldn't matter what data actually existed there. That would be
fairly easily accomplished.
Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
Life would be so much easier if we could just look at the source code.
As an Amazon Associate we earn from qualifying purchases.