Highlights: Informix Developer and Innovator-C Editions Have Moved
Welcome to the International Informix Users Group (IIUG) Insider! Designed for IIUG members and Informix user group leaders, this publication contains timely and relevant information for the IBM Informix community.
Editorial
Looking at the RFE site we can see that 7 new requests for enhancements were added this month.
This means that our user community would like to see a new Informix version.
All I can say is that a new version is in the makes. We don’t have a release date, but it will be coming this year. So, stay tuned.
Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors
gary@iiug.org
Highlights
Informix Developer and Innovator-C Editions Have Moved
Informix Developer and Innovator-c Editions have moved from DockerHub to IBM Container Registry.
The IBM Informix Developer Edition (non-production) and Innovator-C Edition docker containers are moving out of dockerhub and into the IBM Container Registry (ICR).
The repositories on docker hub will be removed in the very near future.
| If you are pulling the container from here: | Switch to this as soon as possible |
| docker.io/ibmcom/informix-innovator-c | icr.io/informix/informix-innovator-c |
| docker.io/ibmcom/informix-developer-database | icr.io/informix/informix-developer-database |
docker pull icr.io/informix/informix-innovator-c
docker pull icr.io/informix/informix-developer-database
To be able to use the docker pull command you need to have Docker Desktop or something similar like podman (opensource) on your machine first. Here is the IBM doc page listing out the options available:
https://cloud.ibm.com/docs/Registry?topic=Registry-getting-started#gs_registry_images_pulling
Karen Qualley
HCL
Informix Corner
Informix Tech Talks on YouTube
Upcoming Informix Tech Talks
Title: 25 Years of Informix Here, There and Everywhere
Speaker: Mark Scranton
Date/Time: March 9, 2023, 2:00 PM EST
Description: “Road Stories: 25 Years of Informix Here, There and Everywhere” Real life stories from consulting, education and coffee breaks in the IDS world. Technical challenges, mysteries and “really?” scenarios from the world of Informix.
Speaker Bio: Mark started with Informix in 1995 and has been doing only IDS and XPS work ever since. Consulting and education for Informix Corp., IBM, Xtivia and independently. Still enjoying Informix work after all these years.
Register for 25 Years of Informix Here, There and Everywhere
Title: Informix SQL Performance Tuning Tips
Speaker: Jeff Filippi
Date/Time: April 6, 2023, 2:00 PM EDT
Description: Learn how to improve your Informix SQL statements to optimize performance on your Informix Database system.
Speaker Bio: Jeff Filippi(Integrated Data Consulting, LLC) has worked with Informix products for 30+ years and is an IBM Business partner and IBM Champion.
Register for Informix SQL Performance Tuning Tips
Last Informix Tech Talks Replay
Replay of the Last Informix TechTalks February 2, 2023: Informix Sysmaster Database Queries for Monitoring and Performance Tuning – Lester Knutsen
Past Informix Tech Talks Replays
Visit WAIUG’s website for more information.
All Informix Tech Talks replays are available at: https://www.iiug.org/en/category/techtalks/
And on YouTube at: https://www.youtube.com/c/InformixTechTalksbytheIIUG
Rhonda Hackenburg
Informix Tech Talks YouTube Channel
We now have 356 subscribers to our YouTube channel.
We have 95 videos on YouTube on our Channel.
Our Channel has received over 9,000 views so far!
Informix Tech Talk YouTube Channel Videos
Past Informix Tech Talks Replays
Bruce Simms
In Search of Tech Talks Speakers
We are looking for additional speakers and especially any new speakers to share your Informix knowledge with our user Community via the IIUG Tech Talks. We will assist you in preparing for your Tech Talks presentation by prerecording your session. This will allow you to be available to answer any questions that come up in the chat during you presentation.
If you are interested in producing a 15 – 45-minute presentation, please contact either Bruce Simms or Rhonda Hackenburg for additional information.
Rhonda Hackenburg
IIUG Board
leolo Informix MasterMind Conference 23
The conference is set to take place on June 5-6, 2023, at the Interalpen Hotel Tyrol in Austria. The event is expected to feature a range of topics related to the future of data security, AI, and predictive analytics, among others.
Attendees will have the opportunity to meet and learn from some of the leading international experts and speakers in these fields. The conference is designed to provide valuable insights into the latest trends and developments in data security, AI, and predictive analytics, as well as to showcase innovative solutions and technologies.
Preregistration is currently open, and interested individuals can contact Leolo IT for more information about the conference, including registration details, the full list of speakers, and the conference agenda. With its focus on cutting-edge technologies and emerging trends, the Leolo IT/Informix Mastermind conference promises to be a must-attend event for anyone interested in the future of data security, AI, and predictive analytics.
Call for speakers is open. Please submit your 40-minute Informix topic. Selected speakers will receive one complementary night at Tyrol Interalpen Hotel!
Rooms are limited, preregister to reserve your room.
You can preregister, submit your presentation request, or learn more at leolo Informix Mastermind Conference 23.
CTO – Senior Consultant – Data Scientist
leolo IT & Media Consulting GmbH
Post your IBM Informix review on Gartner Peer Insights (GPI)
- Reviews are completely anonymous – neither you nor your company will be identified in the published review.
- Simply use this custom, Gartner-generated URL, which takes you directly to the Cloud Database Management Systems Market on the Gartner Peer Insights platform.
- Register with your business email or LinkedIn profile – Gartner validates the authenticity of the reviewer (Gartner will reject Gmail or other freemium email).
- If your review is accepted and publishes using the custom URL above, you are eligible to receive a $25 USD gift card, remitted by Gartner. Or you can donate the proceeds to a charity found on the Gartner platform.
Client Advocacy, IBM Software
Informix Videos by Carlton Doe, IBM
Carlton Doe is an Informix Database Specialist at IBM He has prepared several videos for your review.
| What is Informix? | An introduction to what is the Informix database software is. |
| What is Informix? Short Introduction | A shorter introduction to what Informix is. |
| Informix edge to the corporate server | Carlton demonstrates the full progression of real-time data from capture to analytics using features in Informix v.14.10. |
| Introduction to Informix TimeSeries | An introduction to Informix TimeSeries. Carlton discusses and illustrates the TimeSeries features in Informix v.14.10. |
| Using the Informix 14 Edition Installer | How to use the Informix 14 Edition Installer. Carlton discusses the changes in installing Informix v.14.10 and later. He briefly illustrates the one or two-step installation process. |
View Carlton’s videos
Rhonda Hackenburg
IIUG Board
IIUG Board Member Profile
Here it is again — time for a new board and new profiles… Let’s discover together board member Tom Beebe.
Q: How do you use Informix in your “real” job (DBA, Consultant, Developer, etc.)?
A: I am an Informix consultant. My day job has me supporting a wide variety of clients on a wide range of Informix versions. Currently I am supporting everything from SE to the latest 14 releases. So, it is an interesting mix of Informix environments, both for small and large clients. Every day is different.
Q: How long have you been using Informix products?
A: I started using Informix working with Lester Knutsen about 20 years ago.
Q: What is your role on the IIUG Board?
A: Besides annoying Stuart, the role I see for myself on the board is bringing a wide variety of Informix backgrounds in when looking at the product and the user group and what is offered. I am also hoping to help support the user groups IT infrastructure.
Q: Why did you volunteer to be on the board?
A: I wanted to step up and help, I have previously been on the board and stepped down due to lack of time to be able to dedicate to it.
Q: What do you want to accomplish this year on the Board?
A: I want to help do more IT infrastructure progress to make the website more usable for members.
Q: Where are you from?
A: Washington DC area (USA)
Q: Best Informix story?
A: I got brought in to a customer because their Informix instance stopped working. Did some digging, it had 900 days of uptime as 9.4 on Windows. After troubleshooting I found it was simply due to a windows account issue from when they upgraded their domain controller, it didn’t have anything to do with Informix at all. They also had not had an admin in the office for over 6 years at that point. The Informix system has been almost entirely hands off since then many, many years later.
Q: Worst Informix nightmare.
A: Two of them. First one is seeing an admin accidentally oninit -i on a production system (v10), and then finding there were no good backups. The other was seeing someone (I am that someone) accidentally knock the IIUG server with his knee as he went out to lunch, and not notice he had just powered it off…
Q: Can you tell us about your family and hobbies outside of IIUG?
A: I am recently married to my longtime partner. We share our house with two geriatric kitties and a way too energetic teenager who is somehow now in her 20s. In my free time I do hobbyist photography and am slowly getting into both climbing and blacksmithing. My hands and forearms do not like me some days.
Informix Training
Free Informix Tutorials Videos – a step by step approach to using Informix Database Servers are available at https://advancedatatools.com/tech-info/informix-tutorials/
Lester Knutsen
RFE Corner
IBM has an RFE – Request For Enhancements website.
https://ibm-data-and-ai.ideas.aha.io/?project=INFX
Please visit this site to vote for your favorite enhancements and place new requests. It is friendly and has a nice look and feel.
Recent
ifxclone to not change BUFFERPOOLS
Provide the DBA with detailed connection information
Add onmode -F <type> to free only certain memory e.g. vpcache.
Add onstat -g vpcache detail to show breakdown of usage e.g. smx buffers
Implement nested loop join of external and indexed tables
Automátic column-level encryption at rest
Popular (Over 50 votes)
Obtain the query plan of a running query
Many times a DBA is called to check upon a slow process. Most of the times those processes are running a slow query.
Sometimes it’s hard to know if the query is using the best query plan or not. A DBA can reproduce the query, but it it was prepared without values or if the statistics were changed after it started there is no guarantee that the query plan seen by the DBA is the same as the running query.
We have “onstat -g pqs” which sometimes can give us a clue, but it’s mostly cryptic and undocumented. If a user has X-Windows he can try xtree, but it’s a bit strange for todays standards.
We also have SQLTRACE, but if it was not set when the query was launched it will not capture the info (and besides, due to the circular nature of the buffer it may not be there at the time we need it).
A simple pseudo-table in sysmaster could probably implement this with ease.
It could also be extended to support the “last” query plan making it easy to get the query plan in any tool
Votes: 104 (+0)
Created: December 24, 2018
Status: Future consideration
Informix should be able to change owner on tables and any other objects
If user=informix creates all database and all tables, then programmer creates table but user=informix cannot change it. Only drop it.
Votes: 98 (+0)
Created: December 24, 2018
Status: Future consideration
Backup Individual database, not entire instance
Need a mechanism, similar to ontape, to backup a live database (as opposed to entire instance), without locking it.
Votes: 88 (+0)
Created: December 24, 2018
Status: Future consideration
Gary Ben-Israel
IBM Informix Forum Corner
Join and visit the IBM Informix community forum at http://www.iiug.org/community
Recent Posts
Index shrinks an entire b-tree level when removed/rebuilt….
1 —
Last night I had a production system run out of space when the engine decided to consume 50,000+ pages in a dbspace for an index out of the blue. During the review of what was going on, I noticed this table had an index with a 5 level b-tree, which immediately caught my eye, especially when this index itself was larger than the table data (1.3gb vs 1.1gb) which made no sense with an index with only about 1/8 of the rows in the table in int.
On a test system, dropping this index and re-creating it changed it to a 4 level b-tree and obviously removed tremendous space from this index. We fixed our problem by doing this same thing on our prod system and restarting the job.
My follow-up today is running into a lot of barriers though.
1 – Why didn’t the btree scanner handle this? Shouldn’t it have realized at some point over multiple months this index was far too big vs what it was?
2 – Our theory is the db ran out of space because it wanted to go down to a 6th level for this index…..any ideas what can make Informix do this
3 – I need to find all the indexes in the system that might meet the same criteria. At this point the only way I know is to run oncheck -pe and parse the entire database output. Is there a better way?
I just read another question that is very similar to mine on here, however, that one Art references the index having a serial key in it. Mine doesn’t have the serial in the index in question, but it seems to be exhibiting the same behavior.
Jared Heath
2 —
Per database on your system: select * from database_name:sysindexes where levels >= 4; will give you all of indexes per database that have 4 or higher levels.
You can repack the index as well via SQLADMIN API: https://www.ibm.com/docs/en/informix-servers/14.10?topic=saaf-index-compress-repack-shrink-arguments-optimize-storage-b-tree-indexes-sql-administration-api please read up on it.
Scott Pickett
3 —
- I am not sure it will always merge all pages, it is more focused on removing deleted entries from pages e.g. it will only look at pages with deleted rows. There is an option to repack indexes.
- If in a part of the index a page becomes full and a new row needed to be inserted the page will be split and another level created. The level does not have to be the same in all branches of an index.
David Williams
4 —
Correct David. The btree cleaner threads only merge adjacent nodes that are both less than 50% full. It will not merge a 60% node with a 10% node.
Art Kagel
Address sanitizer error in ESQL/C client library when invalid login/pswd
Informix IDS 10 – Windows 32 bits – ontape – recomendation
DRDA connection to Informix 10.00.UC5W5
onstat -g ses returns “Changing data structure forced command termination”
ALTER TABLE removes it from audit trail
Incompatible blade version to migrate a database from informix 12.10 FC15 to informix 14.10 FC9.
Gary Ben-Israel
Informix Resources
Not a member, become an IIUG member and keep updated on all things Informix. It’s free.
Not a member, join The IBM Informix community and connect with other Informix data experts.
Informix Requests for Enhancements.
Technical Articles
https://www.oninitgroup.com/technical-articles/
https://www.oninitgroup.com/faq-items/cloud-backups-with-informix-14-10/
Over 10 Years of Informix Webcast Replays
Over 30 Years of Informix Blog Posts
Social Media
| YouTube |
Forums, Groups, Videos, and Magazines
- The IIUG old forums at http://www.iiug.org/forums/technical.php *** NO LONGER ACTIVE ***
- Informix Marketing channel on YouTube http://www.youtube.com/user/informixmarketing?feature=results_main
Closing and Credits
The International Informix Users Group (IIUG) is an organization designed to enhance communications between its worldwide user community and IBM. The IIUG’s membership database exceeds 25,000 entries and enjoys the support and commitment of IBM’s Information Management division. Key programs include local user groups and special interest groups, which we promote and assist from launch through growth.
Sources: IIUG Board of Directors
IBM Corp.
Editors: Gary Ben-Israel, Rhonda Hackenburg
For comments, please send an email to gary@iiug.org or rhonda@iiug.org
Highlights: IBM Community Update – Changes to the Data & AI Communities
Welcome to the International Informix Users Group (IIUG) Insider! Designed for IIUG members and Informix user group leaders, this publication contains timely and relevant information for the IBM Informix community.
Editorial
2023 has begun. So far, I have heard very little from IBM or HCL.
Maybe they are extending the holiday season. You guys are not sending me content either.
So, most of my work is searching. This month Art came to my rescue.
I’m doing the best I can to providing you content. If you have anything you think is of value to other users, please send it to me.
Gary Ben-Israel
IIUG Insider Editor
IIUG Board of Directors
gary@iiug.org
Highlights
IBM Community Update – Changes to the Data & AI Communities
Hello Everyone,
On behalf of the IBM Community team, we’d like to wish you Happy New Year! The community continues to evolve and grow, and we wanted to let you know about some upcoming changes that we are making to the community of IBM products within the Data and AI division.
Under the guidance of our leader, Marius Ciortea, we are introducing the new Data and AI community and there will be 5 topic areas that are within it. And within the topic areas are the existing product/solution topic communities. As a part of the new structure some topic groups will be merged with others, and some will be archived.
These changes will help to keep the communities invigorated by bringing similar topics together and enabling improved discussions for broader benefit. The refreshed Data and AI Community will be structured as follows:
These changes will go into effect on or around Jan. 30th, and we will send out another notification immediately prior to the changes going live. Note that your current bookmarks and links will be rerouted automatically, so you will still be able to find all the information in the system.
Your IBM Community team (Sonia Singh and Nickolus Plowden) welcomes your comments and feedback as we continue to evolve the Data and AI Community.
Of course, you can still go direct to the IBM Informix community via special link at www.iiug.org/community any time.
Informix Corner
Informix Tech Talks on YouTube
Past Informix Tech Talks Replays
Replay of the Last Informix TechTalks: WAIUG Virtual Meeting December 8, 2022:
Welcome and Doing Storage Better by Art Kagel
Informix HQ by Shubham Kapoor
Explaining Explain Plans by Mike Walker
Conclusion, Oracle Style Global Temp Tables by Art Kagel
Visit WAIUG’s website for more information.
All Informix Tech Talks replays are available at: https://www.iiug.org/en/category/techtalks/
And on YouTube at: https://www.youtube.com/c/InformixTechTalksbytheIIUG
Informix Tech Talks YouTube Channel
We now have 345 subscribers to our YouTube channel.
We have 89 videos on YouTube on our Channel.
Our Channel has received over 8,342 views so far!
Informix Tech Talk YouTube Channel Videos
Past Informix Tech Talks Replays
Bruce Simms
In Search of Tech Talks Speakers
We are looking for additional speakers and especially any new speakers to share your Informix knowledge with our user Community via the IIUG Tech Talks. We will assist you in preparing for your Tech Talks presentation by prerecording your session. This will allow you to be available to answer any questions that come up in the chat during you presentation.
If you are interested in producing a 15 – 45-minute presentation, please contact either Bruce Simms or Rhonda Hackenburg for additional information.
Rhonda Hackenburg
IIUG Board
Create an Orable style Global Temp Table — ASK
Here is a way to create Oracle style Global Temp Tables. Those are tables that are permanent but their contents are only visible to the session that created them and only for the duration of the session that inserted the data.
The only difference between these “global temp table” and Oracle’s version is that the contents are not automatically deleted at the end of the transaction or of the session that loaded them. We can get around clearing the global temp table at the end of the session by calling the delete function from the sysdbclose() routine for specific users that access the global temp table or in the generic one.
Instructions, notes, and a sample table are included in the following script.
Art
Steps:
Create the table with an extra BIGINT column to hold the session id
Create the table with a different name, say __gtt_
. Create an index on the session id column and a UNIQUE index on the key column(s).Create a VIEW with the desired name of the Global Temp Table that selects all columns EXCEPT the session id column and a filter like: sid = DBINFO( ‘sessionid’ )Create a stored procedure that takes all of the columns of the table except for the session id column and inserts to all columns including inserting DBINFO( ‘sessionid’ ) to the session id columnCreate an INSTEAD OF INSERT trigger on the VIEW that calls the insert stored procedure in the FOR EACH ROW () clause.Create a stored procedure to delete all rows in the base table that takes the primary key column(s) of the temp table as its arguments. The procedure will include: WHERE sid = DBINFO( ‘sessionid’ ) ANDCreate an INSTEAD OF DELETE trigger on the VIEW that calls the delete stored procedure in the FOR EACH ROW () clause passing in the key column(s).Remove data distributions from the temp table: Consider naming the underlying real table something unusual such as beginning the name with one or more underscores.If you will have many sessions using the Global Temp Table, consider creating the index on session id as a Forest of Trees index hashing on the session id with a prime number of buckets.To emulate how Oracle Global Temp Tables remove rows inserted by a session at the end of the session, you can call the procedure from the sysdbclose() routine for those user ids that may be using that temp table of inthe global sysdbclose() routine.CREATE TABLE “informix”.__gtt ( sid BIGINT, key SERIAL(6) NOT NULL, value CHAR(10)) IN datadbs_1 EXTENT SIZE 16 NEXT SIZE 16 LOCK MODE ROW;{ Please review extent sizing and adjust to allow for growth.}REVOKE ALL ON “informix”.__gtt FROM public AS “informix”;GRANT SELECT, UPDATE, INSERT, DELETE, INDEX ON “informix”.__gtt TO “public” AS “informix”;CREATE INDEX __gtt_i1 ON __gtt( sid );CREATE UNIQUE INDEX __gtt_pk ON __gtt( key );UPDATE STATISTICS LOW FOR TABLE __gtt DROP DISTRIBUTIONS;CREATE VIEW “informix”.global_temp_table ( key, value)ASSELECT x0.key ,x0.value FROM “informix”.__gtt x0 WHERE (x0.sid = DBINFO (‘sessionid’) ) ; CREATE PROCEDURE “informix”.insert_gtt ( akey int, avalue char(10) )insert into __gtt values ( dbinfo( ‘sessionid’ ), akey, avalue );END PROCEDURE;REVOKE EXECUTE ON PROCEDURE “informix”.insert_gtt(integer,char) FROM “public” AS “informix”;GRANT EXECUTE ON PROCEDURE “informix”.insert_gtt(integer,char) TO “public” AS “informix”;CREATE TRIGGER “informix”.i_global_temp_table INSTEAD OF INSERT ON “informix”.global_temp_table REFERENCING NEW AS neu FOR EACH ROW ( EXECUTE PROCEDURE “informix”.insert_gtt(neu.key,neu.value ));GRANT SELECT, UPDATE, INSERT, DELETE ON “informix”.global_temp_table TO “informix” WITH GRANT OPTION AS “informix”;CREATE PROCEDURE clear_global_temp_table( akey int );DELETE FROM __gtt WHERE sid = DBINFO( ‘sessionid’ ) and key = akey;END PROCEDURE;CREATE TRIGGER d_global_temp_table INSTEAD OF DELETE ON “informix”.global_temp_table REFERENCING OLD as alt FOR EACH ROW ( EXECUTE PROCEDURE clear_global_temp_table( alt.key ) ) ;Informix TrainingFree Informix Tutorials Videos – a step by step approach to using Informix Database Servers are available at https://advancedatatools.com/tech-info/informix-tutorials/Lester KnutsenRFE CornerIBM has an RFE – Request For Enhancements website.https://ibm-data-and-ai.ideas.aha.io/?project=INFXPlease visit this site to vote for your favorite enhancements and place new requests. It is friendly and has a nice look and feel.RecentAllow INSERT to write to external tablesEncrypting and Decrypting Stored ProceduresAllow renaming a database when BTS Index is definedAdd option to remove last 20 terminated sessions from onstat outtputPopular (Over 50 votes)Obtain the query plan of a running queryMany times a DBA is called to check upon a slow process. Most of the times those processes are running a slow query.Sometimes it’s hard to know if the query is using the best query plan or not. A DBA can reproduce the query, but it it was prepared without values or if the statistics were changed after it started there is no guarantee that the query plan seen by the DBA is the same as the running query.We have “onstat -g pqs” which sometimes can give us a clue, but it’s mostly cryptic and undocumented. If a user has X-Windows he can try xtree, but it’s a bit strange for todays standards.We also have SQLTRACE, but if it was not set when the query was launched it will not capture the info (and besides, due to the circular nature of the buffer it may not be there at the time we need it).A simple pseudo-table in sysmaster could probably implement this with ease.It could also be extended to support the “last” query plan making it easy to get the query plan in any toolVotes: 104 (+0)Created: December 24, 2018Status: Future considerationInformix should be able to change owner on tables and any other objectsIf user=informix creates all database and all tables, then programmer creates table but user=informix cannot change it. Only drop it.Votes: 98 (+0)Created: December 24, 2018Status: Future considerationBackup Individual database, not entire instanceNeed a mechanism, similar to ontape, to backup a live database (as opposed to entire instance), without locking it.Votes: 88 (+0)Created: December 24, 2018Status: Future considerationGary Ben-IsraelIBM Informix Forum CornerJoin and visit the IBM Informix community forum at http://www.iiug.org/communityRecent PostsLong Running Query thru shell Script INSERT data to a table and file both INFORMIX -> INSERT data to a table and file both1 –Dear Friends,
IDS 14.10.FC6 We need to INSERT data to a table and the same time we need the same data to write to a file.We cannot do this activity from the application end since there are different types of applications doing the INSERT operation.So, we have to run this activity from DB end only.Thanks !
Best Regards,
Indika Jinadasa2 –Indika:
One would think that one could simply create an external table SAME AS the original table with the desired format (you have a choice between DELIMITED, FIXED field, and INFORMIX (binary data) format. Then create an INSERT trigger on the original table that copies the inserted data to the external table.Unfortunately each INSERT to an external table truncates the file. If it is a multi-row insert those rows all get inserted to the file, but a subsequent insert, even from the same session, will truncate the file first and overwrite it. So this will not work.You could install the UTL_FILE datablade extension (see the Database Extension manual or search online) which contains the following functions:FCLOSE procedure – Closes a specified file.
FCLOSE_ALL procedure – Closes all open files.
FFLUSH procedure – Flushes unwritten data to a file.
FOPEN function – Opens a file.
GET_LINE procedure – Gets a line from a file.
NEW_LINE procedure – Writes an end-of-line character sequence to a file.
PUT procedure – Writes a string to a file.You could, again, create an INSERT trigger on the table in which you call a stored procedure that builds a string or several strings from the inserted columns and writes the string out to a file. You could format the string(s) as a delimited, fixed field, XML, or JSON record for consumption by whatever application needs to read it.Another alternative would be to write your own database extension using “C” or Java to create a function to open a file in append mode from the BEFORE section of the trigger, format and write a row of data from the ON EVERY ROW section, and to close the file in the AFTER section of the trigger. It would not be difficult to do.Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.comGary Ben-IsraelInformix ResourcesIIUG WebsiteNot a member, become an IIUG member and keep updated on all things Informix. It’s free.IBM Informix CommunityNot a member, join The IBM Informix community and connect with other Informix data experts.IBM Informix RFEInformix Requests for Enhancements.Technical Articleshttps://www.oninitgroup.com/technical-articles/https://www.oninitgroup.com/faq-items/cloud-backups-with-informix-14-10/Over 10 Years of Informix Webcast ReplaysOver 30 Years of Informix Blog PostsSocial Media
YouTube
LinkedIn
Twitter
FacebookForums, Groups, Videos, and Magazines
The IIUG old forums at http://www.iiug.org/forums/technical.php *** NO LONGER ACTIVE ***
Informix Marketing channel on YouTube http://www.youtube.com/user/informixmarketing?feature=results_mainClosing and CreditsThe International Informix Users Group (IIUG) is an organization designed to enhance communications between its worldwide user community and IBM. The IIUG’s membership database exceeds 25,000 entries and enjoys the support and commitment of IBM’s Information Management division. Key programs include local user groups and special interest groups, which we promote and assist from launch through growth.Sources: IIUG Board of DirectorsIBM Corp.Editors: Gary Ben-Israel, Rhonda HackenburgFor comments, please send an email to gary@iiug.org or rhonda@iiug.org