SEO

#1 (**permalink**) 04-19-2008, 09:00 PM

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

#2 (**permalink**) 04-19-2008, 09:01 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Number of rows processed on unload