SEO

#1 (**permalink**) 02-27-2008, 04:38 AM

On AS/400, is there a way to determine the current library from SQL?
(i.e., CURLIB)

#2 (**permalink**) 02-27-2008, 04:39 AM

Hello.

select current schema from sysibm.sysdummy1;

Sincerely,
Mark B.

#3 (**permalink**) 02-27-2008, 04:39 AM

4.spam@mail.ru wrote:
> Hello.
>
> select current schema from sysibm.sysdummy1;
>
> Sincerely,
> Mark B.
>

OS/400 current library (CURLIB) and SQL CURRENT SCHEMA are not (by
definition) the same. There may be an "SQL only" way to get CURLIB, but
if not one option might be to write a small external procedure or
function (UDF).

For example a CL program could contain this command:
RTVJOBA CURLIB(&CURLIB)

To register the CL program as a procedure, do something like:
create procedure getcurlib(out curlib char(10))
language CL
no sql
not fenced
external name mylib.curlib

This is just an idea - I have not built or tested it.

--
Karl Hanson

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Current library on AS/400