Re: problems with unload a part of a table

Peter Kreutzer wrote: > hi there! > > here is little thing that i can not explain, > can anybody else ... > > UNLOAD TO "hallo.unl" DELIMITER "<" > SELECT * FROM hallo_transfer > WHERE quelle[3,6]= gn> > where quelle is char(6) and gn is smallint. > in a version 7.2 workgroup server it works fine. > but in a 4.x informix-se server i get a runtime-error (-202) > in the last line of this part. > > why that? I don't have specific documentation on 4.x server to hand but maybe it doesn't accept substrings; 202 means that there's an illegal character in the SQL - presumably the [. Ian