Re: Field Columns Headings

[Craig Richards <craig@xxxxxxxxxxxxxxxx>]

Darin,

Have a look at:

select * from qsys2.syscolumns
where sys_dname = <your library> and sys_tname = <your table>

regards,
Craig



On Thu, 1 Aug 2019 at 15:12, Darin Bolken <dbolken@xxxxxxxxxxxx> wrote:

> I am looking for a way to get a list of all the files in a library that
> have the word 'Birth' in the column heading.  Is there a SQL query or CL
> command that might help me?
>
> --
> *Darin Bolken*
> *Programmer/Analyst*
> *Nodak Insurance Company*
> *dbolken@xxxxxxxxxxxx* <dbolken@xxxxxxxxxxxx>
> *701-298-4365*
>
> --
> This e-mail and its attachments are intended only for the use of the
> addressee(s) and may contain privileged, confidential
>
> or proprietary
> information. If you are not the intended recipient, or the employee or
> agent responsible for delivering the
>
> message to the intended recipient,
> you are hereby notified that any dissemination, distribution, displaying,
> copying, or
>
> use of this information is strictly prohibited. If you have
> received this communication in error, please inform the sender
>
> immediately
> and delete and destroy any record of this message. Thank you.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com