Informix

lg_IIUG_url_text_logo.gif

Announcements

  • Please vote for Informix in the 2020 DBTA Reader’ Choice Awards!

    We need you to help show you love of Informix.  DBTA has opened up their Annual voting for information management solutions, products, and services.  Hurry a place you vote, voting closes Wednesday, May 8th.  Thanks for your support.

Latest Posts

  • Thanks Markus, this one is neat �� Beautiful one liner ! And thank you for the other solutions too ( Lester, Art, Doug ) I have been rude not to thank you, but a bit overload here. Thanks all!

  • OOps - bugfix: $ dbschema -d $DATABASE -hd all | nawk 'BEGIN{S="UPDATE STATISTICS %s FOR TABLE %s(%s) DISTRIBUTIONS ONLY;\n";printf("SET PDQPRIORITY 25;\nUPDATE STATISTICS LOW DROP DISTRIBUTIONS;\n")}{if($1~/^Distribution/){split($3,T,".");OT=T[1]"."T[2];C=C","T[3]};if($0~/ ...

  • and if someone prefer multi column update stats: dbschema -d DATABASE -hd all | nawk 'BEGIN{S="UPDATE STATISTICS %s FOR TABLE %s(%s) DISTRIBUTIONS ONLY;\n";printf("SET PDQPRIORITY 25;\nUPDATE STATISTICS LOW DROP DISTRIBUTIONS;\n")}{if($1~/^Distribution/){split($3,T,".");OT=T[1]"."T[2];C=C","T[3]};if($0~/ ...

Latest Articles

  • In today’s world, companies need to be able to derive insights from their data no matter where it is – and that’s what Informix is all about. No matter the complication, Informix is built to be your partner on the journey towards maximizing your data. ...

Community Members
339 Members
group Admin
group Admin
group Admin
group Admin
group Admin
Hidden Member
group Admin