×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hi,
Why you want to access an SQL view with native I/O?
An SQL view has no relative record no, nor a predefined sequence. In this
way it is not possible to position at the beginning.
When accessing the file with embedded SQL, it is possible to predefine a
sequence by adding an order by.
Also closing and reopening the cursor will position your view at the first
row returned in the result set.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von Mike Wills
Gesendet: Thursday, 24. February 2011 23:02
An: RPG programming on the IBM i / System i
Betreff: SetLL *start
I have a non-keyed view (created with CREATE VIEW) that I need to
reset the pointer to the beginning of the file each time I hit the
routine. When I use *START I get the error "RNF5319 Factor 2 operand
has a data type that is not allowed for this operation."
setll *start HOURCODER;
read HOURCODER;
What am I doing wrong?
--
Mike Wills
http://mikewills.me
midrange.com
