LinuxQuestions.org - NullTerminator

Visit the LQ Articles and Editorials section

Home

Forums

		LinuxQuestions.org > Blogs
NullTerminator

Notices

Welcome to LinuxQuestions.org, a friendly and active Linux Community.

You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!

Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.

Are you new to LinuxQuestions.org? Visit the following links:
Site Howto | Site FAQ | Sitemap | Register Now

If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.

Having a problem logging in? Please visit this page to clear all LQ-related cookies.

GNU/Linux Basic Guide

This 255-page guide will provide you with the keys to understand the philosophy of free software, teach you how to use and handle it, and give you the tools required to move easily in the world of GNU/Linux. Many users and administrators will be taking their first steps with this GNU/Linux Basic guide and it will show you how to approach and solve the problems you encounter.

Click Here to receive this Complete Guide absolutely free.

IBM AS400 DB2 Catalog Views

Posted 11-29-2012 at 08:57 AM by NullTerminator

Tags catalog, db2, db400, ibm, schema

Various objects are available to query the underlying meta data.
select * from qsys2.sysviews where view_owner ='xyz' and TABLE_NAME = 'tab1'
select * from qsys2.systables where table_owner ='xyz' and TABLE_NAME NOT LIKE 'SYS%'

-- Stored Procedures, SIMILAR RESULTS from sysroutines
select * from qsys2.sysprocs where routine_schema ='xyz' and ROUTINE_NAME NOT LIKE 'SYS%'

Other catalog views
SYSINDEXES
SYSKEYS
SYSPROCS
...

NullTerminator

LQ Newbie

Posted in Uncategorized

Views 485 Comments 0 NullTerminator is offline

NullTerminator NullTerminator is offline

Registered Jul 2006
Posts 8
Blog Entries 14

Find Blog Entries by NullTerminator

Containing Text: Search Titles Only

Advanced Search
Blog Categories
Local Categories
- Uncategorized
Recent Entries
Recent Visitors
Tag Cloud

android native android ocr antlr antlr tracing awk bash bashrc bean blob catalog collections db2 db400 eclipse epic-perl escape characters grammar http proxy ibm java lexer tracing map ndk perl putty raspberrypi schema sed sort spring ssh tab terminal colors tesseract translate

Search by Tag

All times are GMT -5. The time now is 06:47 PM.

Main Menu

(Con't)

My LQ

Write for LQ

LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.

Main Menu

Syndicate

Latest Threads

LQ News

Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: @linuxquestions

Open Source Consulting | Domain Registration