Re: Embedded SQL in ILERPG

Ravi,

You should have a message SQL0302 in your joblog.  That message lists a 
bunch of potential causes which is identified in the message that was sent.  
If you cannot locate the message look at the text of SQL0302 in QSQLMSG 
to see if you can narrow down your possibilities.

David Morris

>>> Ravi Viswanathan <ravi@spacestar.com> 03/16/99 03:14PM >>>

 Hello all,

I am trying to retrieve data from an Oracle database using Oracle Access Manager
and embedded SQL in ILERPG.

I am selecting 12 columns from the ORacle table and inserting into a PF locally.
I have problems with one of the Oracle columns and if I remove this column
everything works fine.

The problem is this: On  Oracle the field is defined as :
DESCRIPTION_2_TXT      VARCHAR2(30)
In the records that I need to retrieve, all the values are blank in this column 
.
After I FETCH the cursor, SQLCA has the following values ( I've just pasted the
msgs that I think are relevant)

  SQLCA                 DS
      SQLCOD              BIN(9,0)             -000000305.      'FFFFFECF'X

    SQLERM              CHAR(70)             '  DESC2
                             VALUE IN HEX
'0009C4C5E2C3F24040404040404040404
                             41
'404040404040404040404040404040404

   SQLERR              CHAR(24)             '                        '
                      VALUE IN HEX         '000000000000000000000000000000000

  SQLSTT              CHAR(5)              '22002'          'F2F2F0F0F2'X

The host variable that I am retrieving this into is defined as 30A. No values
from any of the other columns are retrieved. If I get rid of this field from my
cursor definition, the code works.  How can I "monitor" for this scenario ? 
Also,
where do I find more information on these error codes? Can't find anything in 
the
manuals........

Any help will be appreciated.....

Thanks


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