Velocity ProMagix E2010 Przewodnik Instalacji Pobierz pdf (Strona 39)

To turn on the display of the SQL in WOW, set the WOW_SHOW_SQL environmental

variable to 1 (on) in $OWHOME/WebApps/conf/wow.env. The default is 0 (off):

# Show SQL in QC/QA module: 1=on 0=off

WOW_SHOW_SQL=1; export WOW_SHOW_SQL

An example QC/QA query is provided below:

REM title: Wells with 0 or null total depth

REM dtype: well

REM description: This query checks for wells with TD.

select

well_id ID,

well_uwi "UWI",

well_name_free "Common Well Name",

final_td "TD"

from

well_master

where

final_td is null

final_td = 0

order by

well_name_free

Important note: Optionally, individual lists of QC/QA queries will be picked up from a

user's $HOME/sqlscripts directory, if present. This option will only work if level C

security is configured. Users should prefix query names with their initials to ensure they

are grouped together in the browser.

WOW 5000.0.1.11 Release Notes Page 39 of 104 March 2014

1 2 ... 34 35 36 37 38 39 40 41 42 43 44 ... 103 104

Brak uwag

Velocity ProMagix E2010 Przewodnik Instalacji Strona 39