Reformatting SQL output (Solution)
Posted in 2000
--0__=8625662E0007A52C8f9e8a93df938690918c8625662E0007A52C Content-type: application/zip; name="reform.zip" Content-Disposition: attachment; filename="reform.zip" Content-transfer-encoding: base64 Content-Description: .ZIP File UEsDBBQAAAAIAI5h2CSuMChb7gAAAIgBAAAWAAAAcmVmb3JtYXRfc3FsLnRlbXBsYXRlMW1QwUrE QAw9t9B/COhhZUGq1+JFUOllLx7Fw9TJOMO2aZlJ2cLSfzeZ3SKCl0yS95L3Js8vb+0BzpDYRIYn eGgg2EWSuqnKqmwpofTZI3g0NtC3vBHvq3JV+KzhBt6PYcocF2Ji6HpDR+gDYYJAGQg0zSxwr6NV WQQHu6ukaN6BLCqKkxccdodXbdbXZkG4cKPZqmHzqfZyR/Vbl0VoHjqMMDoRwt6KeIIaAsOAhpJQ zOUnOoJklahlHE/gTYIOkSCi+fJof13+dfPPbaYYiJ0ekHFA4u1ASt+8r5d1dtnvtRxn/pDiU1bd Pjb5lj9QSwMEFAAAAAgAjmHYJMmYT9bBCAAATxgAAAwAAAByZWZvcm1hdF9zcWzNWOlTG0cW/wxV /A8vY7FA0IlTSYDIVQrIXlWFIwJntwqxojXqkTrMoXSPEJTt/dv3vT7mkAanNrUfVsag6XnH791v 5s03rYmIW49qvrP9Bn/Afob991fDi97t+ObXX+wdyYNERiwdqz/CZsqjRchS3oFoqVKYcBAxpHMO ikUcpkJyP03kC/ExhTeEAuVLsUibVtptfpRJVlpCIEKOR2oZpiKeQSCTCFhMPIOY6MQzDBBV6/zn 3tlZ/+YG5DKug5/ET1xqDpFqJuKISMgC5YUi5goWXIJMVog1TYCBQmp7z91y8K6ZRENSLtUJNAKD CXkmPAOb8mnBX/rTMAbEy2iC0pKABCpiQ6cQCG0KUTSCdVb8kI6m9QvRa1OcSyQ6+VnLa1aw3iLN lAcMrYUnFi45MXba+NmgbjzB9RI9/ZIsjRueBLAADdWKFhLPAlAphjbicaoqlDHJYcZjLpFmSoC5 1PoYpGwSEpCUCUJfwUs6GMaJzfBvPIWIPYtoGWH0wmUUw0pM07mijFnxMKzSbfyh6cjBdGF555xN UWkTXvFPmcyKWIkwpKAuFZ+CCDB1KrjRtpnkzPiImTR3wLUY7YQqvSWqDWUFZ1TwGh7UvRJYPjGG c7cJV8gjV0LxP2FGNtLisnntMwh0+H00ZsYrfKgQ+COW8lJWydaaFwuZYLKgU2DBZOpiYfPHVEg1 LhaqxKrO8PUg5ZjgeHeaxLrQplR7ERWmKEV5ylJGdChAMh9piD2RVHNcCt9EwglTgspIpcKvOzGa H3sFpmisk5vFL+TeGUyWKXjtxrFH4hh4TY8aic7rTBkWhtQ5NtAFrPudPslE5h0nF4AAMPBMKcQ4 NV1Ea7aNogk9vL2uQ+k6C3mQwu/YYUUgkJdKhpnCsAYbMilm8wJd3mOpXTGVxDAwWYc1ahu3aWmE LqGsxghSamEbTBA8MfuY6b5Oe4j5yoYUxS0SmSrMRAzNABjmdiIfyQOoROhmR8xzTE1MjBnXjpFJ WNdpjPpd/aE84MyfGyoybGFT2XiF3GzMcGn0Dymw6cYweTmBc/YkptBT88lLOcvOEe8JHL1tfd/q HB//aNmvQ/QCmsx5iE2YmwwT5GiMOkc9O9u/DcbXw8Hl7ftue2f75mw4uL4dnw+G3Yf0ZcFLsw8+ A1s9wt4nnexQu3z/ZQ/PnpnEoOHki3FwPJDIjze9D/3u3ij+qNC0k1H66iBpwijdv0AnMBqaByOc dltbSK9enSWa49y2fN3pc64n6umFavSTKELZJZY4QXrHMSzNXxEvsBQ0UD2wdEY3ikPS8dmc0GPE 1qc5ao7iPfIApiCVIsW6J2dLO1FWc5I942myQJUnwYk6eQIBp1j8KNenSNUESiUlwQHgrB9ffbzt 1q6ub3vDD3B6SjcU3uhdXP/SXzt/OoA8lB17+O0BcH+eQE2HBDrv/nZEx1v8GSvUEnHF/J1t6j+E HNvFHXg1q9uDLnge3CNG9BACc+m2KTW7o0Wj4EAU5WnIr4qzFul4Ok67KlHKZesSmxZWpY1swhNi y1voZi4oy2WHxM42icfEMcnVtThBB/Hn/ofBJXyipQAbfReNMvvImDYpfYlfxn6yjO1dTIXssg1f SMYnY8nNo1hQx4VJyOJHu5RhBplGWpgjehcini103L7VjMIP4BMFzmTQ/uV7Omzbw62YP6c63F90 gli4bTqiEwIwCNY2NGyXIXoDHdymbh1xFivTD1M70jm2JouKDJ7jCjLh2IYkdS/rPY2yjIZOCm7K sW8VnafBIfJlhB4LFZ5kznOW0J/MwYeHdFlysFOWB+GdDaNTSKlYEEZuMi6xwCthUp8eM9/H7aUL hQsP/9U6GX8GRSPL3XBUcANuQXcZ3T38hFMtnqXz/drRgYO4RtItkOR+eANnc+4/6nYS47ixI7C4 GphoaK21I/jm39D61x3O9FHz/rDWcspo1Ja1eQ2v6G66ZwCUyarPD9fAohD86V+ea3VmSHg0ioMk DJMVDT+zKNO6IxRO4xezFsx5uNCLmavlQuF6uahsOW+W9n4DQu9GLPSXNONx3quTAmfD5b/1GE2q At/Gkus29UQWhEBp/9X7lBWxVPwV6c0qEE56UQSiSPAYjtu7rugqNK2jiTPVFcRl3fkCvSwv0a+x eOUY4q4opxAynGp6ItoHNLfV0FlzjUVx3IEqeGyM11lGKTHtNoq9iFmfKoPSPUiUt8M1tRv6zOqG z4e4tmP6qQ3N2dcAvN1G50cFu9/Z/z8o2ha8OnhnJriXGFy67P32gf5csGd7k6Lu6TLCzMaOup/3 jrpzU526iK4VKuV9YcaGgJ+64DohXh4e2oJlTzMqO6RCbPuFIhT30MqHzwFWYufUlb9jemf6D5J+ C83jrOGUSWwBW3hInNFZh4xtsLpQvvZg19OrOykYGY4MLz0BZN+V6TBmNm3xELPvr2vYxKuVVR2X 9OpfBd2uO6Po/7UTrFiC5b7+v7hgx443Lsf8eSG5UiKJ7ZQrn3n1keflsrA4dZE4vCXuzTOvnizT O0949wZAsbaaprya35V+6xIzFuZa6y6J6taT9QorG7TQGttcH6GC3TDpNCMo+XjjuMSBA20P3C6M mdJKo0Wr9DoQDe00a7Vs061lOzg0+B+4Yt+7VXcLn02+wm923r/3e+f94bj/z+th/+ZmcHXZ9R7o pRI03r7OjM9gZC40Og8YJKN9bN5idj3r+5GTc/RfyqmA0nldxIPugNe9Ye/ipuvVNsz5XCvByy5z Cu/PVv98R3AP9PQMTTwiVlzaZzlrdrb125e0pdc3iRIpxlkVnwMW7vUnojdmeLAH9knA9fb9jKqu hz229c+mrVdVF1Hcde6zTCuUu751VLy1yfmWbusEr7WB9rqBNrM0felNZKuwda21kRGWhAejkZdn e2V92OeICmXWndkG9hc0VtVXSWMurNa2hZe9jSgnW/4Ovqok5TK2FenPo2QKP7TbX6HScQ9eJciq f2dbRl8R8x9QSwECMgsUAAAACACOYdgkrjAoW+4AAACIAQAAFgAAAAAAAAABACAAtoEAAAAAcmVm b3JtYXRfc3FsLnRlbXBsYXRlMVBLAQIyCxQAAAAIAI5h2CTJmE/WwQgAAE8YAAAMAAAAAAAAAAEA IAC2gSIBAAByZWZvcm1hdF9zcWxQSwUGAAAAAAIAAgB+AAAADQoAAAAA --0__=8625662E0007A52C8f9e8a93df938690918c8625662E0007A52C Content-type: text/plain; charset=us-ascii Hi everybody, I have developed a script to reformat Informix SQL output from multiple lines per row into a single line per row. It is more sophisticated than reform_sql. If you use this new script and have any suggestions or encounter any problems please Email (david.ashby@workcover.nsw.gov.au). Regards David Ashby --0__=8625662E0007A52C8f9e8a93df938690918c8625662E0007A52C--