ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Search Result

Collapse
4 results in 0.0018 seconds.
Keywords
Members
Tags
view x
  •  

  • eloiselle
    started a topic Tracking Usage of a View
    in SQL

    Tracking Usage of a View

    Hello everyone,

    I've been trying recently to create some sort of event monitor (not sure if this is a correct solution) in DB2 to try to keep tracks of a view's usage (each time it i used it in a SELECT statement, for instance).
    I've seen multiple solutions existing for T-SQL, but...
    See more | Go to post
    Last edited by eloiselle; March 11, 2019, 12:05 PM. Reason: Added tags

  • TRIGGERS ON VIEWS - (Known as "INSTEAD OF" Triggers") What Causes them to fire?

    I Searched the DB2 Forum and did not find anything about this before posting this question.
    I am looking for confirmation that TRIGGERS placed on VIEWS only fire when you use the view and not the underlying File/Table.

    Here is and example. PF/TABLE named DTLTRAN and VIEW of that table...
    See more | Go to post
    Last edited by DavidLerman; October 5, 2016, 08:15 AM.

  • voicucosmin90
    started a topic View in COBOL in place of physical file

    View in COBOL in place of physical file

    Hi guys,
    I have a question if you can help me please, I have to use a view created with SQL in place of the physical file, I created the view with sql and I don't have dds for this:

    create view library.file_view
    as select*from library.pysical_file
    where some conditions...
    See more | Go to post

  • Gary B
    started a topic Zebra Labels to PDF anyone?

    Zebra Labels to PDF anyone?

    Hi All,

    We print a number of Zebra labels in our operation. Recently users asked if we could save labels so they could look at them when needed.

    Ideally this function would require manual intervention to create the doc in the ifs.

    Does anyone know of a way...
    See more | Go to post

Our Sponsors

Collapse
Working...
X