RE: Help with SQL compile issue

You're preparing "SMO_SELECTION"

But using "MO_SELECTION" everywhere else, without the lead S.

HTH,

Charles Wilt
Software Engineer
CINTAS Corporation - IT 92B
513.701.1307

wiltc@xxxxxxxxxx

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Jeff Young
Sent: Monday, February 11, 2008 12:32 PM
To: midrange-l@xxxxxxxxxxxx; rpg400-l@xxxxxxxxxxxx
Subject: Help with SQL compile issue

I have a program with the following code:
In InzSr
C/Exec SQL
C+ PREPARE SMO_SELECTION FROM :sSelect
C/End-Exec
C/Exec SQL
C+ DECLARE MO_SELECTION CURSOR FOR SMO_SELECTION
C/End-Exec
EndSr



Later, in execution
C/Exec SQL
C+ Open MO_SELECTION using
C+ :FCmp, :TCmp,
C+ :FCust, :TCust,
C+ :FLoc, :TLoc,
C+ :FItem, :TItem,
C+ :FSer, :TSer,
C+ :FSTag, :TSTag
C/End-Exec

Get pre-compile error, SQL0504 35 761 Position 17 Cursor MO_SELECTION not
declared.

Get the same error on the cursor for the FETCH, and the CLOSE

I can not determine why I am getting the error in the pre-compiler.

Thanks,


Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions
V5R2
IBM Certified Specialist- e(logo) server i5Series Technical Solutions
Designer V5R3
IBM Certified Specialist- e(logo)server i5Series Technical Solutions
Implementer V5R3
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.