View Single Post

   
  #2 (permalink)  
Old 04-19-2008, 09:01 PM
Ferronato
 
Posts: n/a
Default 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

Reply With Quote