Re: SQL0312 - Position 43 Variable PRTDEV not defined or not usable.

[rob@xxxxxxxxx]

Thank you.  That was it.  My copy member had it as ObjName.

Rob Berendt

==================
A smart person learns from their mistakes,
but a wise person learns from OTHER peoples mistakes.



                    MWalter@hanoverwi
                    re.com                  To:     rpg400-l@midrange.com
                    Sent by:                cc:
                    rpg400-l-admin@mi       Fax to:
                    drange.com              Subject:     Re: SQL0312 - Position 
43 Variable PRTDEV not defined or not
                                             usable.

                    10/05/2001 10:38
                    AM
                    Please respond to
                    rpg400-l







Rob,

I don't see where ObjNam is defined.


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040



                    rob@dekko.com
                    Sent by:                 To:     rpg400-l@midrange.com
                    rpg400-l-admin@mi        cc:
                    drange.com               Subject:     SQL0312 -
Position 43 Variable PRTDEV not defined or not usable.


                    10/05/01 11:30 AM
                    Please respond to
                    rpg400-l







I am getting the message
SQL0312 - Position 43 Variable PRTDEV not defined or not usable.
when I don't think I should be.

...
      /eject
     P RtvQryPrt       B
     D RtvQryPrt       PI                  Like(ObjNam)
     D  QryObjLib                          Like(Obj_Lib) const

     D PrtDev          S                   Like(ObjNam)
...
     C/exec sql
     C+ select substr(dmpobj,92,10) into :PRTDEV
     C+ from qtemp/dmpobj
     C+ where substr(dmpobj,3,6)='002EC0'
     C/end-exec
...
       return PrtDev;

      /end-free

     P RtvQryPrt       E


Rob Berendt

==================
A smart person learns from their mistakes,
but a wise person learns from OTHER peoples mistakes.

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.





_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.