This is a discussion on Re: How can I tell when a column was added to a table? within the Informix forums, part of the Database Server Software category; --> --0__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDF E7406A Content-type: multipart/alternative; Boundary="1__=88BBE4ECDFE7406A8f9e8a93df938690918c 88BBE4ECDFE7406A" --1__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDF E7406A Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Hi Gary, For the when part, ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| --0__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDF E7406A Content-type: multipart/alternative; Boundary="1__=88BBE4ECDFE7406A8f9e8a93df938690918c 88BBE4ECDFE7406A" --1__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDF E7406A Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Hi Gary, For the when part, you can probably look through the logs to see when t= he ALTER TABLE was done. (look for PTALTER and the partnum of the table). = For the who part, you will probably need to use the ONAUDIT tool (actually,= you can get the when part from that as well). For what columns have changed ...that's a bit tricky (until and unless = u keep a history of dbschema outputs) .. I think the partition pages do s= tore the information in Slot #6 but its not straightforward ..it would requi= re interpretation until and unless someone's got a tool to interpret that information. HTH Thanx much, Rajib Sarkar Advisory Software Engineer (RAS) IBM Data Management Group If we all did the things we are capable of doing, we would literally astound ourselves. -- T. Edison = Gary Quiring = <gquiring@msn.com = > = To Sent by: informix-list@iiug.org = owner-informix-li = cc st@iiug.org = Subj= ect How can I tell when a column was= 04/23/2004 10:42 added to a table? = AM = = = Please respond to = Gary Quiring = = = Is there a way to tell who and when a column or other properties were changed on a table using IDS 7.3? Thanks Gary Quiring = --1__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDF E7406A Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>Hi Gary,<br> For the when part, you can probably look through the logs to see when t= he ALTER TABLE was done. (look for PTALTER and the partnum of the table= ). For the who part, you will probably need to use the ONAUDIT tool (ac= tually, you can get the when part from that as well). <br> <br> For what columns have changed ...that's a bit tricky (until and unless = u keep a history of dbschema outputs) .. I think the partition pages do= store the information in Slot #6 but its not straightforward ..it woul= d require interpretation until and unless someone's got a tool to inter= pret that information.<br> <br> HTH<br> <br> Thanx much,<br> <br> Rajib Sarkar<br> Advisory Software Engineer (RAS)<br> IBM Data Management Group <br> <br> <br> If we all did the things we are capable of doing, we would literally as= tound ourselves. -- T. Edison<br> <br> <img src=3D"cid:10__=3D88BBE4ECDFE7406A8f9e8a93df938@us .ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for Gary Quiring <gq= uiring@msn.com>">Gary Quiring <gquiring@msn.com><br> <br> <br> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE4E= CDFE7406A8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">Gary Quiring <gquiring@msn.com></font></b= ><font size=3D"2"> </font><br> <font size=3D"2">Sent by: owner-informix-list@iiug.org</font> <p><font size=3D"2">04/23/2004 10:42 AM</font> <table border=3D"1"> <tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"= center"><font size=3D"2">Please respond to<br> Gary Quiring</font></div></td></tr> </table> </ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE4ECDFE7406A8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D88BBE4ECDFE7406A8f9e8a93df938@us .ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">informix-list@iiug.org</font></td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE4ECDFE7406A8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D88BBE4ECDFE7406A8f9e8a93df938@us .ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE4ECDFE7406A8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D88BBE4ECDFE7406A8f9e8a93df938@us .ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">How can I tell when a column was added to a table?</fo= nt></td></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D88BBE4ECDFE7= 406A8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D88BBE4ECDFE7406A8f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <br> <tt>Is there a way to tell who and when a column or other properties we= re changed on<br> a table using IDS 7.3?<br> <br> Thanks<br> Gary Quiring<br> <br> </tt><br> </body></html>= --1__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDF E7406A-- --0__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDF E7406A Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=88BBE4ECDFE7406A8f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYX J0U2F2ZXIhAAA7 --0__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDF E7406A Content-type: image/gif; name="pic25670.gif" Content-Disposition: inline; filename="pic25670.gif" Content-ID: <20__=88BBE4ECDFE7406A8f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZe ZgLVA9YVCpnGagVjV171aRVrYR RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFil KQdI8GA5IcpApeJQt8L09lmgkH LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d 5VyKtCKW3jfz4uMKmq3xu4N0nK BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZl qWmyFy5/6yBBuji0AxFR M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNU tJOUAVLoUr1+wqDGTE4zk+T6FG uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO 3mpOaKnL0Z2EKvNMSILEThKhCg zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXp uFKhSYZALd0O5RKa2z9EYKBbpb qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NE NQj2jXjmfNgOZDaXb5glRmXQ33 YEWQYNcZFnrYcIQLNzyTFDQNkXIff0ExVlY4srziQk43inZgL4 rwxxINMvpFFAz1KOODHiu+4aEw NEjFl5B3JIKWKF3k6I9bfUGp5ZZcdunll5IA4cuHvQQJ5gcsoC WOOUwgltIwAKRxJgbIkJAQZEq0 2YliZnpZZ4BH3CnYOXldOUOfQoYDqF1LFHbXCrO8xmRsfoXDXJ 6ChjCAH3QlhJcT6VWE6FCkfCco CgrMFsROrIEX3o2whVjWDjoJccN3LdggSGXLCdLEgHr1lyU3O3 QxhgohNKXJCWv8JQr/PDdaqd6w 2rj1inLiGeiCJoDspAoQlYE6QWLSECehcWIYxIQES6zhbn1iIm THEQyqJ4eIxJJoUBc+3CbBuwZE V5cJPPkIjFDdeEabQbd6WgICTxiiz0f5dBKquXF6k4senwEhYG nKEFJeGrxUZy8dB8gmAXI/sPvH ESfCwVt5hTgYiqQqtdRNHQIU1PJ33ZqmzgE90OwLaoJcnMop1W iMmgkPHQRIrwgFuNV90A3doNKT mrKIN07AnGcI9BQjhCBN4RfA1qIZnMqorJCogKfGQnxSCDilTV IA0yl5ciTovgLuBDKFUDE9aQcw 9SA+rjSNf9/M1gxrj6VwDTS0IUSElMzBfsj0NFXR2kwsV1A5IF1grLgLL/r1R40BZEnuBWgmQEyb jqRwSAt6bqMCOFkvKFN2GPPkUzIm/SCF8z8pVzpbjVnMsy0vOr1hw3SaSRUhpY09v0z0J1FnwzPl fmh+xl4WtR0zGu24I4KbMQm3lnVu2oNWxI9W/lcyzA+mCKF4DBikxb/+UWtOGRiFP8qEwAayIgIA Ow== --0__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDF E7406A Content-type: image/gif; name="ecblank.gif" Content-Disposition: inline; filename="ecblank.gif" Content-ID: <30__=88BBE4ECDFE7406A8f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7 --0__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDF E7406A-- sending to informix-list |
| ||||
| Rajib Sarkar <rsarkar@us.ibm.com> wrote in message > Hi Gary, > For the when part, you can probably look through the logs to see when t= > he > ALTER TABLE was done. (look for PTALTER and the partnum of the table). = > For > the who part, you will probably need to use the ONAUDIT tool (actually,= > you > can get the when part from that as well). You can get the "who" part from the onlog output as well. I have used this in the past to identify who is updating something that changes the "version" in systables and hence causes the stored procedures to re-optimise. > > For what columns have changed ...that's a bit tricky (until and unless = > u > keep a history of dbschema outputs) .. I think the partition pages do s= > tore > the information in Slot #6 but its not straightforward ..it would requi= > re > interpretation until and unless someone's got a tool to interpret that > information. > > HTH > > Thanx much, > > Rajib Sarkar > Advisory Software Engineer (RAS) > IBM Data Management Group > > > If we all did the things we are capable of doing, we would literally > astound ourselves. -- T. Edison > > > > = > > Gary Quiring = > > <gquiring@msn.com = > > > = > To > Sent by: informix-list@iiug.org = > > owner-informix-li = > cc > st@iiug.org = > > Subj= > ect > How can I tell when a column was= > > 04/23/2004 10:42 added to a table? = > > AM = > > = > > = > > Please respond to = > > Gary Quiring = > > = > > = > > > > > > Is there a way to tell who and when a column or other properties were > changed on > a table using IDS 7.3? > > Thanks > Gary Quiring > > = > > --1__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDF E7406A > Content-type: text/html; charset=US-ASCII > Content-Disposition: inline > Content-transfer-encoding: quoted-printable > > <html><body> > <p>Hi Gary,<br> > For the when part, you can probably look through the logs to see when t= > he ALTER TABLE was done. (look for PTALTER and the partnum of the table= > ). For the who part, you will probably need to use the ONAUDIT tool (ac= > tually, you can get the when part from that as well). <br> > <br> > For what columns have changed ...that's a bit tricky (until and unless = > u keep a history of dbschema outputs) .. I think the partition pages do= > store the information in Slot #6 but its not straightforward ..it woul= > d require interpretation until and unless someone's got a tool to inter= > pret that information.<br> > <br> > HTH<br> > <br> > Thanx much,<br> > <br> > Rajib Sarkar<br> > Advisory Software Engineer (RAS)<br> > IBM Data Management Group <br> > <br> > <br> > If we all did the things we are capable of doing, we would literally as= > tound ourselves. -- T. Edison<br> > <br> > <img src=3D"cid:10__=3D88BBE4ECDFE7406A8f9e8a93df938@us .ibm.com" width=3D= > "16" height=3D"16" alt=3D"Inactive hide details for Gary Quiring <gq= > uiring@msn.com>">Gary Quiring <gquiring@msn.com><br> > <br> > <br> > > <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= > > <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE4E= > CDFE7406A8f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= > th=3D"40%"> > <ul> > <ul> > <ul> > <ul><b><font size=3D"2">Gary Quiring <gquiring@msn.com></font></b= > ><font size=3D"2"> </font><br> > <font size=3D"2">Sent by: owner-informix-list@iiug.org</font> > <p><font size=3D"2">04/23/2004 10:42 AM</font> > <table border=3D"1"> > <tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"= > center"><font size=3D"2">Please respond to<br> > Gary Quiring</font></div></td></tr> > </table> > </ul> > </ul> > </ul> > </ul> > </td><td width=3D"60%"> > <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= > > <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= > 0__=3D88BBE4ECDFE7406A8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= > 1" width=3D"58" alt=3D""><br> > <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= > 100%"><img src=3D"cid:30__=3D88BBE4ECDFE7406A8f9e8a93df938@us .ibm.com" = > border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> > <font size=3D"2">informix-list@iiug.org</font></td></tr> > > <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= > 0__=3D88BBE4ECDFE7406A8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= > 1" width=3D"58" alt=3D""><br> > <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= > 100%"><img src=3D"cid:30__=3D88BBE4ECDFE7406A8f9e8a93df938@us .ibm.com" = > border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> > </td></tr> > > <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= > 0__=3D88BBE4ECDFE7406A8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= > 1" width=3D"58" alt=3D""><br> > <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= > h=3D"100%"><img src=3D"cid:30__=3D88BBE4ECDFE7406A8f9e8a93df938@us .ibm.= > com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> > <font size=3D"2">How can I tell when a column was added to a table?</fo= > nt></td></tr> > </table> > > <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> > <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D88BBE4ECDFE7= > 406A8f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= > =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D88BBE4ECDFE7406A8f9= > e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= > /td></tr> > </table> > </td></tr> > </table> > <br> > <tt>Is there a way to tell who and when a column or other properties we= > re changed on<br> > a table using IDS 7.3?<br> > <br> > Thanks<br> > Gary Quiring<br> > <br> > </tt><br> > </body></html>= > > > --1__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDF E7406A-- > > > --0__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDF E7406A > Content-type: image/gif; > name="graycol.gif" > Content-Disposition: inline; filename="graycol.gif" > Content-ID: <10__=88BBE4ECDFE7406A8f9e8a93df938@us.ibm.com> > Content-transfer-encoding: base64 > > R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu > ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYX J0U2F2ZXIhAAA7 > > --0__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDF E7406A > Content-type: image/gif; > name="pic25670.gif" > Content-Disposition: inline; filename="pic25670.gif" > Content-ID: <20__=88BBE4ECDFE7406A8f9e8a93df938@us.ibm.com> > Content-transfer-encoding: base64 > > R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA > AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh > EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZe ZgLVA9YVCpnGagVjV171aRVrYR > RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFil KQdI8GA5IcpApeJQt8L09lmgkH > LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d 5VyKtCKW3jfz4uMKmq3xu4N0nK > BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI > TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZl qWmyFy5/6yBBuji0AxFR > M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNU tJOUAVLoUr1+wqDGTE4zk+T6FG > uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO 3mpOaKnL0Z2EKvNMSILEThKhCg > zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXp uFKhSYZALd0O5RKa2z9EYKBbpb > qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NE NQj2jXjmfNgOZDaXb5glRmXQ33 > YEWQYNcZFnrYcIQLNzyTFDQNkXIff0ExVlY4srziQk43inZgL4 rwxxINMvpFFAz1KOODHiu+4aEw > NEjFl5B3JIKWKF3k6I9bfUGp5ZZcdunll5IA4cuHvQQJ5gcsoC WOOUwgltIwAKRxJgbIkJAQZEq0 > 2YliZnpZZ4BH3CnYOXldOUOfQoYDqF1LFHbXCrO8xmRsfoXDXJ 6ChjCAH3QlhJcT6VWE6FCkfCco > CgrMFsROrIEX3o2whVjWDjoJccN3LdggSGXLCdLEgHr1lyU3O3 QxhgohNKXJCWv8JQr/PDdaqd6w > 2rj1inLiGeiCJoDspAoQlYE6QWLSECehcWIYxIQES6zhbn1iIm THEQyqJ4eIxJJoUBc+3CbBuwZE > V5cJPPkIjFDdeEabQbd6WgICTxiiz0f5dBKquXF6k4senwEhYG nKEFJeGrxUZy8dB8gmAXI/sPvH > ESfCwVt5hTgYiqQqtdRNHQIU1PJ33ZqmzgE90OwLaoJcnMop1W iMmgkPHQRIrwgFuNV90A3doNKT > mrKIN07AnGcI9BQjhCBN4RfA1qIZnMqorJCogKfGQnxSCDilTV IA0yl5ciTovgLuBDKFUDE9aQcw > 9SA+rjSNf9/M1gxrj6VwDTS0IUSElMzBfsj0NFXR2kwsV1A5IF1grLgLL/r1R40BZEnuBWgmQEyb > jqRwSAt6bqMCOFkvKFN2GPPkUzIm/SCF8z8pVzpbjVnMsy0vOr1hw3SaSRUhpY09v0z0J1FnwzPl > fmh+xl4WtR0zGu24I4KbMQm3lnVu2oNWxI9W/lcyzA+mCKF4DBikxb/+UWtOGRiFP8qEwAayIgIA > Ow== > > --0__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDF E7406A > Content-type: image/gif; > name="ecblank.gif" > Content-Disposition: inline; filename="ecblank.gif" > Content-ID: <30__=88BBE4ECDFE7406A8f9e8a93df938@us.ibm.com> > Content-transfer-encoding: base64 > > R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7 > > --0__=88BBE4ECDFE7406A8f9e8a93df938690918c88BBE4ECDF E7406A-- > > sending to informix-list |