#5 I can make the index when using the RUNSQLSTM? I have been away from the
i for a few years before this assignment since May. But they keep me mainly
on the reporting tool. No not because I can't code in RPG but because of
On Thu, Jan 30, 2014 at 7:11 PM, Hoteltravelfundotcom <
right not. this table was created by a consultant. For purpose of
recreating many of our reports from the i, to the reporting tool.
I do not know much about what exactly he did there. I would need to review
the RPG programs we have seen in that list.
but for my purposes, I wanted to use in the reporting tool but as most
optimized as possible.THis table does exist. I believe there is a nightly
refresh to it.
On Thu, Jan 30, 2014 at 6:50 PM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>wrote:
One thing - CHECK WHETHER DTAWHS EXISTS ALREADY IN THAT LIBRARY
Please excuse the flaming - I'm not upset, just trying to make a very,
very strong point.
You probably do NOT want to wipe out existing data, right?
On 1/30/2014 5:47 PM, Vernon Hamberg wrote:
You're jumping over things again - there are important gaps in what wePROJ_MKWN1
1. This member is NOT where the data resides. If that is what you think,
then disavow yourself of that notion instantly
2. This member is the source code for CREATING the table where the data
a. That table is names DTAWHS and it is located in library
3. I'm glad you keep asking questions, BTW, because it seems things that
are "obvious" to those who've been on the platform for awhile - that
they are not "obvious" to you - maybe you've been pushed into doing
these tasks, I think you've hinted at that.
4. So you will need to use this member to create the table, and the
command for that is RUNSQLSTM, where you specify this member, and out
comes an SQL table (also know as a PF).
5. You CAN make an index on that table, and if you are at a newer
release, there is more you can do, but I don't think you will need to.
So now I have to ask, how does the data get into DTAWHS? Or does that
table already exist and has been in production?
On 1/30/2014 5:36 PM, Hoteltravelfundotcom wrote:
I wanted to index the invoice number as we are adding this processing.
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact