Re: Number of rows processed on unload

Sergio, Be sure that you are getting the number of rows: let variable_name (integer) = sqlca.sqlerrd[3] Must be the first command after unload command. In portuguese: (acho que voce ' de Portugal) PAra melhor confirmar o numero de linhas do 'unload', programe o seguinte comando logo apos o comando 'unload' dentro do 4gl: let variavel = sqlca.sqlerrd[3] esta variavel deve ser um integer no momento de um 'define' ou um smallint, desde que o numero de linhas nao ultrapasse os 32767. Regards. R. Ferronato sergio@moredata.pt wrote in message news:<c53h5v$48p$1@terabinaries.xmission.com>... > Hi: > > In 4gl when i make an UNLOAD does sqlca.sqlerrd[3] gets assigned with the > number of rows processed ? > > My doubt is because SELECT(s) assign sqlca.sqlerrd[3] with estimated > number of rows processed, but since UNLOAD is runned on the 4gl process > (and not in engine), 4gl could easily know how rows was unloaded. > > TIA > S'rgio > sending to informix-list > sending to informix-list