SV File_IO_Status

Euroboy

Active Member
Hi People,

i have another question (Im working on my own and have not much experience using OW so forgive if Im asking too many questions for your liking).

I am doing a Select statement on table IO. I have checked the SV File_IO_Status after the select statement and it comes up with value 'ER_SUCCESS'. This is weird because the values you get to choose from the IF statment start with 'CO' not 'ER'. Can anyone shed any light on this?
 
Hi euroboy,

ER_SUCESS is a value returned form ER operation and CO_SUCESS is a constant that you need to compare with that value. Prefixes are different but value is same and it works fine.

Regards,
Bojan.
 
Sabir,
Bojan already explained the difference between ER and CO.
My addition is:
Select will be SUCCES although it results 0 record. Selecting 0 records is a normal result.
Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
To add to Zoltan's reply, the psuedo code would look something like this:

SELECT ...
FETCH NEXT
WHILE IO_STATUS = Success
... process
... data
... here
FETCH NEXT
END WHILE

Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
 
Back
Top