Re: SQL - Return codes HELP !!

In article <6toeca$uq$1@newsreader1.core.theplanet.net>, Jay <jason.baines@bradford.gov.uk> writes >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. > Make sure that you are checking the status IMMEDIATELY after the drop table statement. In 6.x even assignment statements after the value of the STATUS variable, which did not happen in early 4.x 4GL. >Could it the difference between engine UC1 & tools UD1 ?? > >Any help appreciated. > >Jason. > >Jay. > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care