|
Ok, as I think about it....
I could create a new SQL table object, then a logical file with the
name of the old physical and the same fields ect...such that the
format level ID is the same.
I think that takes care of problem 1.
Problem 2, I think will be ok as Aldon does support SQL DDL defined objects.
So I think I'll be able to do something like so:
create table &LIB.ITEMMSTR (
itemnbr decimal (6,0),
descr char(30),
primary key (itemnbr)
);
call qsys.qcmdexec('call pgm(QDB2TX/DB2TX) PARM(''enable text column
&LIB.ITEMMSTR descr handle myhandle'')'
, 0000000087.00000);
Isn't that just lovely. Maybe I can define QDB2TX/DB2TX itself as a
stored proc....
Wonder how the triggers that the system creates over the table will be
handled by Aldon??? I think that's still going to be a problem as the
trigger names are generated....
I thought the "i" stood for integrated????
Well something to play with this weekend anyway...
Still would like to hear from anyone using the text extender.
Charles
On Thu, Jul 8, 2010 at 11:52 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:
All,
Playing around with the 5722-DE1 Text Extender, hoping to allow for
"fuzzy" searching over the description and other fields in an item
master file.
One problem, when you enable a column for searching, ie. build a text
extender index on that column, the system alters the table structure
by adding a new column to the table of type DB2TEXTH.
Two issues with this:
1) Kind of screws up all the RPG program accessing the file doesn't it?
2) What about the CMS (Aldon in this case)? I get the distinct
impression that a file so altered isn't going to play nicely with the
CMS.
Has anybody used the text extenders in either scenario?
Thanks!
Charles
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.