Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

"One day I woke up and discovered that I was in love with tripe." -- Tom Anderson


computers / comp.sys.ibm.as400.misc / Re: List of all Libraries with SQL

SubjectAuthor
* Re: List of all Libraries with SQLDavid Keck
`- Re: List of all Libraries with SQLEnder Jose Yohan Alvarez

1
Re: List of all Libraries with SQL

<56e3a925-37fe-4814-bad7-6742ec5f33a0n@googlegroups.com>

 copy mid

https://www.novabbs.com/computers/article-flat.php?id=14&group=comp.sys.ibm.as400.misc#14

 copy link   Newsgroups: comp.sys.ibm.as400.misc
X-Received: by 2002:ac8:6611:: with SMTP id c17mr26486045qtp.392.1628628981650;
Tue, 10 Aug 2021 13:56:21 -0700 (PDT)
X-Received: by 2002:a37:8243:: with SMTP id e64mr23986171qkd.89.1628628981470;
Tue, 10 Aug 2021 13:56:21 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.ibm.as400.misc
Date: Tue, 10 Aug 2021 13:56:21 -0700 (PDT)
In-Reply-To: <kQ1XG.110633$Vp4.35614@fx44.iad>
Injection-Info: google-groups.googlegroups.com; posting-host=165.225.221.7; posting-account=pOf-jwoAAAC3l1AurSYeRJkqwxcg-ZbG
NNTP-Posting-Host: 165.225.221.7
References: <8bb46d08.0202210315.38a8734e@posting.google.com>
<8a44371a-47d5-4042-bc73-7e73a2f3eff1o@googlegroups.com> <kQ1XG.110633$Vp4.35614@fx44.iad>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <56e3a925-37fe-4814-bad7-6742ec5f33a0n@googlegroups.com>
Subject: Re: List of all Libraries with SQL
From: davidkec...@gmail.com (David Keck)
Injection-Date: Tue, 10 Aug 2021 20:56:21 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
 by: David Keck - Tue, 10 Aug 2021 20:56 UTC

On Thursday, August 6, 2020 at 9:08:34 PM UTC-4, Mike Colangelo wrote:
> On 7/30/2020 6:38 AM, higson...@gmail.com wrote:
> > Em quinta-feira, 21 de fevereiro de 2002 07:15:23 UTC-4, Arne Gellhaus escreveu:
> >> Hi,
> >>
> >> i would like to get a list of all libraries with a SQL Statement. I
> >> can get all tables with
> >>
> >> SELECT * FROM qsys2/systables
> >>
> >> and all columns are retrievable from qsys2/syscolumns. Is there
> >> anything like this for libraries?
> >>
> >>
> >> Regards,
> >> Arne Gellhaus
> >
> > Very simple,
> >
> > You can use
> >
> > SELECT * FROM TABLE (QSYS2.OBJECT_STATISTICS('*ALL','*LIB') ) AS X
> >
> > or simple
> >
> > SELECT OBJNAME, OBJTYPE, OBJOWNER, OBJTEXT FROM TABLE (QSYS2.OBJECT_STATISTICS('*ALL','*LIB') ) AS X
> >
> Did you notice that the post to which you replied is almost 18.5 years old?
>
> Anyway, try this:
>
> select * from qsys2.sysschemas
>
> I don't think any of the IBM i Services views and table functions were
> around in 2002, but they are now.
Responses are useful not not only to the original poster at the time of the post but also anyone else, even across time. If he hadn't posted then neither would have you, and I may not have found what I needed. qsys2.sysschemas, very nice. Thank you very much!

Re: List of all Libraries with SQL

<76effb9b-72bc-4dee-8578-3a8c761422a2n@googlegroups.com>

 copy mid

https://www.novabbs.com/computers/article-flat.php?id=34&group=comp.sys.ibm.as400.misc#34

 copy link   Newsgroups: comp.sys.ibm.as400.misc
X-Received: by 2002:a05:6214:21aa:: with SMTP id t10mr5536446qvc.50.1640353831773;
Fri, 24 Dec 2021 05:50:31 -0800 (PST)
X-Received: by 2002:a0c:8124:: with SMTP id 33mr5717366qvc.77.1640353831218;
Fri, 24 Dec 2021 05:50:31 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.ibm.as400.misc
Date: Fri, 24 Dec 2021 05:50:31 -0800 (PST)
In-Reply-To: <56e3a925-37fe-4814-bad7-6742ec5f33a0n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=200.6.27.15; posting-account=ISn_nAoAAAD76bJ5dpF3z_n0TdFwIQw5
NNTP-Posting-Host: 200.6.27.15
References: <8bb46d08.0202210315.38a8734e@posting.google.com>
<8a44371a-47d5-4042-bc73-7e73a2f3eff1o@googlegroups.com> <kQ1XG.110633$Vp4.35614@fx44.iad>
<56e3a925-37fe-4814-bad7-6742ec5f33a0n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <76effb9b-72bc-4dee-8578-3a8c761422a2n@googlegroups.com>
Subject: Re: List of all Libraries with SQL
From: eyo...@banesco.com (Ender Jose Yohan Alvarez)
Injection-Date: Fri, 24 Dec 2021 13:50:31 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 67
 by: Ender Jose Yohan Alv - Fri, 24 Dec 2021 13:50 UTC

El martes, 10 de agosto de 2021 a las 16:56:22 UTC-4, David Keck escribió:
> On Thursday, August 6, 2020 at 9:08:34 PM UTC-4, Mike Colangelo wrote:
> > On 7/30/2020 6:38 AM, higson...@gmail.com wrote:
> > > Em quinta-feira, 21 de fevereiro de 2002 07:15:23 UTC-4, Arne Gellhaus escreveu:
> > >> Hi,
> > >>
> > >> i would like to get a list of all libraries with a SQL Statement. I
> > >> can get all tables with
> > >>
> > >> SELECT * FROM qsys2/systables
> > >>
> > >> and all columns are retrievable from qsys2/syscolumns. Is there
> > >> anything like this for libraries?
> > >>
> > >>
> > >> Regards,
> > >> Arne Gellhaus
> > >
> > > Very simple,
> > >
> > > You can use
> > >
> > > SELECT * FROM TABLE (QSYS2.OBJECT_STATISTICS('*ALL','*LIB') ) AS X
> > >
> > > or simple
> > >
> > > SELECT OBJNAME, OBJTYPE, OBJOWNER, OBJTEXT FROM TABLE (QSYS2.OBJECT_STATISTICS('*ALL','*LIB') ) AS X
> > >
> > Did you notice that the post to which you replied is almost 18.5 years old?
> >
> > Anyway, try this:
> >
> > select * from qsys2.sysschemas
> >
> > I don't think any of the IBM i Services views and table functions were
> > around in 2002, but they are now.
> Responses are useful not not only to the original poster at the time of the post but also anyone else, even across time. If he hadn't posted then neither would have you, and I may not have found what I needed. qsys2.sysschemas, very nice. Thank you very much!
Gracias

--
***REGULACIÓN DE USO DEL CORREO ELECTRÓNICO DE *Banesco Banco Universal* 
HACIA INTERNET*** La información contenida en este correo electrónico y
cualquier anexo puede ser de carácter confidencial y es propiedad de
Banesco Banco Universal. Sólo está permitido su uso, copia, transmisión, 
recepción o distribución a personas debidamente autorizadas. Si usted
recibió este correo por error por favor destrúyalo y/o elimine cualquier
copia guardada en su sistema y notifique inmediatamente al remitente o a la
dirección de correo electrónica *mailmaster@banesco.com*
<mailto:mailmaster@banesco.com>. Usted no debe utilizar la información 
contenida para ningún propósito ni compartirla con otras personas..

1
server_pubkey.txt

rocksolid light 0.9.7
clearnet tor