Re: Convert Function in Informix

dean_c@news.hk.super.net (DEAN CHEUK) wrote: :Does anyone know whether there is an internal convert function in Informix :to convert string value to numeric value in the SQL statement (without :using 4GL & ESQL/C ie the SQL statement can be run in dbaccess)? The engine does such conversions automatically. Like this: create table xx(yy integer); insert into xx values("22");and in all similar sircumstances. :Besides, how can i execute the SQL statement under the Unix command line :(IBM AIX machine)? Please give me the exact syntax ... It's in the manual and in something like 10 posts on a similar question this and last week. Try: dbaccess databasename sqlfilename There is a problem with this if any sql command in the sqlfilename terminates with an error. The following statements are executed anyway. There is a program at the iiug site (se my sig) that can do this. : :Thanks : :Dean Cheuk :dean_c@hk.super.net Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org