Re: Embedded SQL

I did a
DSPMSGD RANGE(SQL7008) MSGF(QSQLMSG)
Check that out and see if your joblog has more information.

For the group PTF's try the following:
http://as400service.rochester.ibm.com/supporthome.nsf/Document/10000031



                                                                                
                                       
                    "R. Bruce                                                   
                                       
                    Hoffman, Jr."            To:     <RPG400-L@midrange.com>    
                                       
                    <rbruceh@attgloba        cc:                                
                                       
                    l.net>                   Subject:     Re: Embedded SQL      
                                       
                    Sent by:                                                    
                                       
                    owner-rpg400-l@mi                                           
                                       
                    drange.com                                                  
                                       
                                                                                
                                       
                                                                                
                                       
                    09/27/00 01:50 PM                                           
                                       
                    Please respond to                                           
                                       
                    RPG400-L                                                    
                                       
                                                                                
                                       
                                                                                
                                       




-----Original Message-----
From: Gordon S. Royle <groyle@cott.com>
To: RPG400-L@midrange.com <RPG400-L@midrange.com>
Date: Wednesday, September 27, 2000 2:17 PM
Subject: Embedded SQL


>This is probably one of the "dumb" ones. We are having a problem with
insert,
>update and delete (but not select - stadalone or in a cursor) when we
embed
>it in RPG-IV. If we run it from STRSQL, it works but when we try it from
RPG
>it returns SQLCOD of -7008. We trired it with a single field file to
>eliminate any other problems (NOT NULL definitions, etc). Is there
something
>we're missing?
>


IF you are on V4R5, there was a problem that seems to have been corrected
by
the DB2 Group PTF.

and there goes the alzhiemers... I can't recall the ptf number now for the
group ptf....  SF99102?


===========================================================
R. Bruce Hoffman, Jr.







+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---