Re: Any Assistance please - Wrong return codes in SQL

Jay wrote: > > We seem to having problems with return codes from SQL's we are running > on our new machine. > > One example is in a script we get to the pint of dropping some tables > before progressing in the script. The SQL doesn't drop the tables but > reports a return code of 0 which indicates that it has been succesful > and it doesn't report any errors to the error log. > > The scripts worked on Online V5.06.UC1 with 4GL 4.14.UC1X1 > & SQL 4.14 .UC1. > > Our current software is : Online 7.23.UC1 with 4GL 6.05.UD1 > & SQL 6.05.UD1. > > Could it the difference between engine UC1 & tools UD1 ?? > > Any help appreciated. > > Jason. > > Jay. This is just a guess, but is it a transaction problem: the drop of the temp table is successful but not committed so a subsequent statement still sees the table? -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions AND the release notes. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/