Re: Retrieve table's library with embedded SQL?

Thanks for the suggestions.  

I inserted Rob's code right after the OPEN cursor SQL, and the result
in SchemaName was "*LIBL".  I set a breakpoint and verified that the
file is indeed open via WRKJOB.  Do I need to do this after the first
fetch?  Just to clarify, I am looking for the library name for the
file I am querying.

BTW, when researching this stuff in the iSeries SQL manuals, should I
completely forget about the native "library", "file", and "field"
terms, and use the SQL terms?

Thanks,
Dan

On 7/14/05, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:
> I wonder if
> D SchemaName          S                       128         Varying
> 
> C/Exec SQL
> C+  VALUES CURRENT SCHEMA INTO :SchemaName
> C/End-Exec