Re: where is SQLDATA?

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

Just as follow-up.  I assumed you were using SQL embedded in RPG, since 
this is the RPG list.

If not, you need to explain more what you are trying to do.

If so, then you probably don't need SQLDA, since the pre-compiler will 
take care of generating the code to move the data into your variables. 
SQLDATA should really be a data structure in your program (if selecting 
several fields) and you should name it something else. Avoid naming 
variables starting with SQL).

The field SQLDATA in the SQLDA is not what you need to be looking at 
when using embedded SQL in RPG.

Sam

On 10/13/2017 1:49 PM, Sam_L wrote:
> I'm not totally sure that I understand what you are trying to do...  For 
> example, SQLDATA is defined where?
>
> However, you probably need something like
> exec sql fetch first from c1 into :SQLDATA
> so SQL knows where to put the data.
>
> It you are just beginning with embedded SQL, you might want to take a 
> look at this article:
> https://www.itjungle.com/2005/08/10/fhg081005-story01/
>
> Here's another about handling the return codes:
> https://www.mcpressonline.com/programming/sql/techtip-sqlcod-endoffile-gotcha 
>
>
> Sam

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus