Утилиты OpenEdge RDBMS

Утилита PROMON

promon db-name

OpenEdge MONITOR Version 10

Database: /usr/wrk/sports2000

1. User Control
2. Locking and Waiting Statistics
3. Block Access
4. Record Locking Table
5. Activity
6. Shared Resources
7. Database Status
8. Shut Down Database
 
R&D. Advanced Options
T. 2PC Transactions Control
L. Resolve 2PC Limbo Transactions
C. 2PC Coordinator Information
 
J. Resolve JTA Transactions
 
M. Modify Defaults
Q. Quit
 
Enter your selection:

1. Display all entries
2. Match a user number
3. Match a range of user numbers
 
Q. Return to main menu
 
Enter your selection:

• Для сбора данных, монитор ограничивает доступ к разделяемой памяти всех пользователей на мгновения для того чтобы снять моментальный снимок состояния. Следовательно, не стоит использовать монитор в случае высокой загрузки системы.
• Несомненно выходные данные монитора необычно полезны, и они не менее полезны при отладочных работах при решении какой-либо проблемы.
  

• BF2
• BF3
• BF4
• BIB
• LRI
• LRX
• OM
  

#SEM = Max-possible-users (-n) + Max-possible-servers (-Mn) + 4

This is rather extreme. All the processes connected to
the database will be destroyed. Do you really want to?
Please confirm by entering y for yes:

• Database;
• Backup;
• Servers;
• Processes/Clients;
• Files;
• Lock Table;
• Buffer Cache;
• Logging Summary;
• BI log;
• AI log;
• Two-phase Commit;
• Startup Parameters;
• Shared Resources;
• Shared Memory Segments;
• AI Extents;
• Database Service Manager

• Most recent database open – дата и время запуска брокера базы данных.
• Previous database open – дата и время, когда база данных была предварительно запущена.
• Local cache file time stamp – временная метка для проверки корректности схемы базы данных.
• Database block size – размер блока базы данных в байтах.
• Number of blocks allocated – общее количество блоков, размещенных в базе данных.
• RM Blocks with free space – общее количество блоков в RM цепочке.
• Highest table number defined – количество таблиц, определенных в базе данных.
• Database version number – определяет структуры всех связанных данных с базой данных, расположенных на диске. Этот номер используется для определения корректности соответствия структуры базы данных.
• Shared memory version number – идентифицирует версию всех структур данных, расположенных в разделяемой памяти и используемых менеджером базы данных. Этот номер используется для гарантирования, что все работающие программы, обращающиеся к разделяемой памяти используя единые правила сохранения и доступа к данным в этой памяти.
  

• Most recent full backup – дата формирования последней полной резервной копии.
• Most recent incremental backup – дата формирования последней инкрементальной резервной копии.
• Database changed since backup – Yes, если база данных изменена после формирования последней резервной копии. No, если изменений не было.
• Sequence of last incremental – количество инкрементальных копий после формирования последней полной копии.
  

• Protocol – сетевой протокол, используемый для связи сервера и клиентов. TCP единственное правильное значение для этого поля.
• Pend. Users – количество пользователей, успешно подключившихся к брокеру, но не завершивших соединение с сервером.
• Cur. Users – текущее количество подключенных к серверу пользователей.
• Max. Users – максимально возможное количество подключаемых к серверу пользователей.
  

• Display all lock entries.
• Display locks for one user.
• Display locks for one RECID.
  

• Usr – номер пользователя, обладателя блокировки.
• Name – имя пользователя.
• Trans id – ID транзакции.
• Type – тип блокировки (например, REC, RGET).
• Table – номер таблицы.
• RECID – RECID блокированной записи в таблице.
• Flags – в следующей таблице указаны возможные варианты флагов:
  

Enter <return>, A, L, R, S, U, Z, P, T, or X (? for help):

User 1: commit transaction and disconnect.

Утилита PROSTRCT

prostrct qualifier db-name [ structure-description-file ]

• ADD
• ADDONLINE
• BUILDDB
• CLUSTER CLEAR
• CREATE
• LIST
• REMOVE
• REORDER AI
• REPAIR
• STATISTICS
• UNLOCK                                        
  

prostrct add db-name [ structure-description-file ] [ -validate ]

prostrct addonline db-name [ structure-description-file ] [ -validate ]

Adding a new area online with ai enabled will cause the roll forward
utility to fail unless the corresponding areas are also added to the
target database. (13705)
Do you want to continue (y/n)? (13706)
y

prostrct builddb db-name [ structure-description-file ]

prostrct cluster db-name clear

prostrct create db-name [ structure-description-file ]
                        [ -blocksize blocksize ]
                        [ -validate ]

prostrct list db-name [ structure-description-file ]

prostrct remove db-name extent-token storage-area

prostrct reorder ai db-name

prostrct repair db-name [ structure-description-file ]

prostrct statistics db-name

prostrct unlock db-name [ -extents ]

Утилита PROUTIL

proutil db-name -C qualifier

proutil db-name -C 2phase begin [ -crd | -tp nickname ] ...

proutil db-name -C 2phase commit tr-number

Transaction 768 has committed. (2048)

proutil db-name -C 2phase end

proutil db-name -C 2phase modify [ -crd | -tp nickname ] ...

proutil db-name -C 2phase recover

Commit transaction 760, on coordinator sports1 #768 (y to commit/n to
abort)? (2039)

proutil db-name -C auditarchive [date-range]
     [-recs num-recs] [-nodelete] [-checkseal]
     [-directory directory-name]
     [-userid user-id [-password passwd] ]

proutil db-name -C auditload archive-file-name
      [-recs num-recs] [-checkseal]
      [-userid user-id [-password passwd] ]

proutil db-name -C bigrow n [ -r ]

proutil db-name [-yy n] -C BULKLOAD fd-file [-B n]

proutil db-name -C busy

proutil mydb -C busy
if [ $? != 0 ]
then
      echo
      echo \"Do you want to use ‘proshut’ to force users off\\
              the system?\"
      read ans
      if [ \"$ans\" = y ]
      then
              proshut -by mydb
      else
              echo \"Backup will not be performed.\"
              exit
      fi
fi
echo \"Beginning backup.\"
# Backup procedure

proutil db-name -C chanalys

proutil -C codepage-compiler inputfile outputfile

proutil db-name -C conv910

proutil db-name -C convchar [ analyze | charscan | convert ]
                                [ codepage ] [ character-list ]

proutil sports2000 -C convchar charscan ibm850 “0x80, 0x81, 0x82”

proutil sports2000 -C convchar charscan 1253 “128, 0xC2, 0x7f, 122”

proutil sports2000 -C convchar charscan 1253 \"49854 - 50050\"

Charscan searching for utf-8 character: 49854 0xc2be. (6570)
Charscan searching for utf-8 character: 49855 0xc2bf. (6570)
Charscan searching for utf-8 character: 50048 0xc380. (6570)
Charscan searching for utf-8 character: 50049 0xc381. (6570)
Charscan searching for utf-8 character: 50050 0xc382. (6570)

proutil -C convfile { file-name convert using table-name
                   | file-name [ analyze ] }

# optional comment lines begin with the # character
SOURCE source-codepage-name
TARGET target-codepage-name
/*000-015*/000 001 002 003 004 005 006 007 008 009 010 011 012 013 014
/*016-031*/016 017 018 019 020 021 022 023 024 025 026 027 028 029 030
/*032-047*/032 033 034 035 036 037 038 039 040 041 042 043 044 045 046
.
.
.
/*240-255*/240 241 242 243 244 245 246 247 248 249 250 251 252 253 254

proutil db-name -C dbanalys

proutil db-name -C dbauthkey old-key new-key

proutil dbname -C describe

proutil -C dbipcs

PROGRESS SHARED MEMORY STATUS
ID         ShMemVer         Seg#         InUse         Database
68            -                         -                  -            (not PROGRESS)
100          3                        0               Yes          /db/work5/sports
101          3                        1                  -            /db/work5/sports
120          3                        0                No          /db/work5/test

proutil db-name -C disableauditing [-userid username [-password passwd ] ]

Auditing was not fully disabled because auditing data tables are not empty.
(13647)
Auditing has been deactivated, no additional auditing records will be
recorded. (13649)

Auditing has been disabled for database db-name. (12490)

proutil db-name -C disablejta

proutil db-name -C disablekeyevents

proutil db-name -C disptosscreatelimits area-number

proutil db-name -C dump [owner-name.]table-name directory [ -index num ]
         {[-thread n ] [-threadnum nthreads] [-dumplist dumpfile] }

proutil db-name -C dumpspecified [owner-name.]table-name.field-name
                         operator field-value directory

proutil db-name -C enableauditing area Area-Name
     [indexarea Index-Area-Name ] [deactivateidx ]

Auditing has been enabled for database db-name. (12479)

Auditing can not be enabled because auditing data tables are not empty. (13650)

Auditing has been activated

proutil db-name -C enablejta

proutil db-name -C enablekeyevents [area-name]

proutil db-name -C EnableLargeFiles

proutil db-name -C enablelargekeys

$ proutil docsample -C enablelargekeys
OpenEdge Release 10.1B1P as of Mon Oct 23 19:54:20 EDT 2006
If you enable large key entries support for this database, it may cause
runtime issues to pre-10.1B clients that connect to this database.
Do you really want to enable large keys support? (y/n) (13929)
y
Large Key Entry Feature enabled for database docsample. (13700)
$

proutil db-name -C enableseq64

proutil db-name -C holder

proutil mydb -C holder
retcode=$? # this saves the return code
case $retcode in
0) echo \"The database is not busy, ok to backup\"
   ;;
14) echo \"The database is locked, no backup done\"
   exit $retcode
   ;;
16) echo \"The database is busy in multi-user mode, no backup done\"
   exit $retcode
   ;;
*) proutil failed, no backup done
   echo error code = $retcode
   exit $retcode
   ;;
esac
proutil mydb -C truncate bi
<<test the return value from proutil here>>
<<put the backup command here>>
rfutil mydb -C mark backedup

proutil db-name -C idxactivate [owner-name.]table-name.index-name
                   [useindex table-name.index-name] [recs n] [refresh t]

proutil db-name -C idxanalys

proutil db-name -C idxbuild
  [ all |table [owner-name.]table-name | area area-name |
  schema schema-owner | activeindexes | inactiveindexes]
  [ -thread n ] [ -threadnum n ]
  [ -T dir-name | -SS sort-file-directory-specification ]
  [ -TB blocksize ] [ -TM n ] [ -B n ] [ -SG n ]

Index Rebuild Utility
Select one of the following:
All                   (a/A) - Rebuild all the indexes
Some              (s/S) - Rebuild only some of the indexes
By Area           (r/R) - Rebuild indexes in selected areas
By Schema     (c/C) - Rebuild indexes by schema owners
By Table         (t/T) - Rebuild indexes in selected tables
By Activation  (v/V) - Rebuild selected active or inactive indexes
Quit        (q/Q) - Quit, do not rebuild
Enter your selection:

proutil db-name -C idxcheck [ all |table [owner-name.]table-name |
           area area-name | schema schema-owner]

Index Check Utility
Select one of the following:
All                        (a/A) - Check all the indexes
Some                  (s/S) - Check only some of the indexes
By Area              (r/R) - Check indexes in selected areas
By Schema        (c/C) - Check indexes by schema owners
By Table             (t/T) - Check indexes in selected tables
Quit (q/Q) - Quit, do not Check
Enter your selection:

proutil db-name -C idxcompact [ owner-name.]table-name.index-name [ n ]

proutil db-name -silent -C idxfix [-userid username [-password passwd ] ]

Index Fix Utility
Select one of the following:
1. Scan records for missing index entries.
2. Scan indexes for invalid index entries.
3. Both 1 and 2 above.
4. Cross-reference check of multiple indexes for a table.
5. Build indexes from existing indexes.
6. Delete one record and its index entries.
7. Quit
Enter your selection:

proutil db-name -C idxmove [ owner-name.]table-name.index-name area-name

proutil db-name -C iostats

Database name is sports (2524)
FILE                BUFFERED      UNBUFFERED                 LOGICAL (2556)
                    Writes   Reads   Writes    Reads       Reads    Writes Extends (2557)
========================================================
sports.b1          0          0               317          389          388            252            2
sports.d1         1           173          11             0              171            11               0
sports_7.d1    773      6792        0               0               6790         772             0
FILE

proutil db-name -C load filename [ -dumplist dumpfile ]
          build indexes [-TB blocksize] [-TM n]
      [[-T dir-name] | [-SS sort-file-directory-specification]]

proutil db-name -C mvsch

proutil db-name -C rcodekey old-key new-key files ...

proutil db-name -C revert

   Revert Utility
Feature                                                            Enabled                  Active
--------------------------------                                  -------                       ------
64 Bit DBKEYS                                                   Yes                        Yes
Large Keys                                                          Yes                        Yes
64 Bit Sequences                                               Yes                        Yes
Revert: The database actively supports Large Key Indexes. (13749)
Revert: The database can not be reverted. (13750)
Revert: The database contains 64-bit Sequences. (13751)
Revert: The database can not be reverted. (13750)

Revert Utility
Feature Enabled Active
--------------------------------                            -------                    ------
Database Auditing                                       Yes                     Yes
64 Bit DBKEYS                                            Yes                     Yes
Revert: Have you backed up your database..... Type y to continue (y/n).
(13754)
y
Revert: Database beginning reversion process. (13755)
VST Table Deletion has begun. Please standby. (6876)
VST Table Deletion has completed successfully. (6885)
Revert: 64 Bit Dbkey has been disabled for this database.
After-image disabled. (846)
Revert: Truncating the Bi File.
VST Table Deletion has begun. Please standby. (6876)
VST Table Deletion has completed successfully. (6885)
Adding VST file: _Connect. (6875)
Adding VST file: _MstrBlk. (6875)
Adding VST file: _DbStatus. (6875)
.
.
.
Adding VST file: _AreaThreshold. (6875)
Total number of Virtual System Tables is 45. (6250)
Revert: Database ending reversion process.

proutil db-name -C setareacreatelimit area-number create-limit

proutil db-name -C setareatosslimit area-number toss-limit

proutil db-name -C setblobcreatelimit blob-id create-limit

proutil db-name -C setblobtosslimit blob-id toss-limit

proutil db-name -C settablecreatelimit table-name create-limit

proutil db-name -C settabletosslimit table-name toss-limit

proutil db-name -C tabanalys

proutil db-name -C tablemove
        [owner-name.]table-name table-area [index-area]

proutil db-name -C truncate area area-name
                 [-userid username [-password passwd ] ]

proutil db-name -C truncate bi { [ -G n ] | -bi size | -biblocksize size }

proutil db-name -C updateschema

proutil db-name -C updatevst

proutil -C wbreak-compiler src-file rule-num

PROWD34=proword.34; export PROWD34

Утилита RFUTIL

rfutil db-name -C qualifier

rfutil db-name -C aiarchiver disable

rfutil db-name -C aiarchiver enable

rfutil db-name -C aiarchiver end

rfutil db-name -C aiarchiver setdir dir-list [-aiarcdircreate ]

rfutil db-name -C aiarchiver setinterval n

rfutil db-name -C aiarchive extent source-extent target

rfutil db-name -C aimage aioff

rfutil db-name -C aimage begin

rfutil db-name -C aimage end

rfutil db-name -C aimage extent empty [ extent-number | extent-path ]

rfutil db-name -C aimage extent full

last_full=’_rfutil mydb -C aimage extent full’
tar -cvf /dev/ai_archive $last_full
rfutil mydb -C aimage extent full $last_full

rfutil db-name -C aimage extent list

rfutil db-name -C aimage extract -a ai-extent -o output-file

rfutil db-name -C aimage new

rfutil db-name -C aimage query query-option by search-option search-value

rfutil db-name -C aimage scan [ verbose ] -a ai-name

rfutil db-name -C aimage truncate -aiblocksize size

rfutil db-name -C mark backedup

rfutil db-name -C roll forward [ verbose ]
     [ endtime yyyy:mm:dd:hh:mm:ss | endtrans transaction-number]
     [ -B n ] [ -r ] -a ai-name

rfutil db-name -C roll forward retry
       [ endtime yyyy:mm:dd:hh:mm:ss| endtrans transaction-number]
       [ -B n ] [ -r ] [ verbose ] -a ai-area

rfutil db-name -C sequence

Прочие утилиты администрирования баз данных

• Утилита DBMAN
• Утилита DBTOOL
• Утилита DBUTIL с классификатором CMPDB
• Утилита PROADSV
• Утилита PROBKUP
• Утилита PROCLUSTER
• Утилита PROCOPY
• Утилита PRODB
• Утилита PRODEL
• Утилита Progress Explorer
• Утилита PROLOG
• Утилита PROREST
  

dbman [ -host host-name -port port-number | service-name-user user-name ]
           -database db-name [ -config config-name -start | -stop | -query ]

#
# Connection Manager Properties File
#
%% Properties File
%% version 1.1
%% Oct 31, 2005 1:59:37 PM
#
# The following are optional configuration properties and their default
# values. The legacy option, if applicable, is listed after the second
# comment. Property values set at this level become the default values
# for all configuration subgroups.
#
[configuration]
#        afterimagebuffers=5                # -aibufs
#        afterimageprocess=false                # n/a
#        afterimagestall=true                # -aistall
#        asynchronouspagewriters=1                # n/a
#        beforeimagebufferedwrites=false        # -r
#        beforeimagebuffers=5                # -bibufs
#        beforeimageclusterage=60                # -G
#        beforeimagedelaywrites=3                # -Mf
#        beforeimageprocess=true                # n/a
#        blocksindatabasebuffers=0                # -B (calculated as 8*(-n))
#        casetablename=basic                # -cpcase
#        collationtable=basic                        # -cpcoll
#        conversionmap=convmap.cp                # -convmap
#        crashprotection=true                # -i
#        databasecodepage=basic                # -cpdb
#        directio=false                        # -directio
#        hashtableentries=0                        # -hash (calculated as (-B)/4)
#        internalcodepage=iso8859-1                # -cpinternal
#        locktableentries=10000                # -L
#        logcharacterset=iso8859-1                # -cplog
#        maxservers=4                        # -Mn
#        maxusers=20                        # -n
#        nap=1                                # -nap
#        napmax=1                        # -napmax
#        pagewritermaxbuffers=25                # -pwwmax
#        pagewriterqueuedelay=100                # -pwqdelay
#        pagewriterqueuemin=1                # -pwqmin
#        pagewriterscan=1                        # -pwscan
#        pagewriterscandelay=1                # -pwsdelay
#        semaphoresets=1                        # -semsets
#        sharedmemoryoverflowsize=0        # -Mxs
#        spinlockretries=0                        # -spin
#        sqlyearoffset=1950                        # -yy
#        watchdogprocess=true                # n/a
#
# The following are optional database properties and their default values.
# Property values set at this level become the default values for all
# database subgroups.
#
[database]
#        autostart=false                # autostart the defaultconfiguration?
#        databasename=demo        # absolute or relative path + database name
# The following are optional server group properties and their default
# values. The legacy option, if applicable, is listed after the second
# comment. Property values set at this level become the default values
# for all servergroup subgroups.
#

[servergroup]
#        host=localhost                # -H
#        initialservers=0                # n/a
#        maxclientsperserver=0        # -Ma (calculated value)
#        maxdynamicport=5000        # -maxport (5000 for NT; 2000 for UNIX)
#        messagebuffersize=350        # -Mm (4gl only)
#        minclientsperserver=1        # -Mi
#        mindynamicport=3000        # -minport (3000 for NT; 1025 for UNIX)
#        networkclientsupport=true        # false for self-service
#        numberofservers=0        # -Mpb
#        port=0                        # -S ; Must be non-zero
#                                # when networkclientsupport=true
#        prosqltrc=nnnnnnnnnnn        # turn on various levels of SQL tracing
#        reportinginterval=1                # -rpint (4gl only)
#         serverexe=<4gl server location>        # _mprosrv (4gl only)
#        type=both                        # n/a
[configuration.sports2000.defaultconfiguration]database=sports2000
displayname=defaultConfiguration
servergroups=sports2000.defaultconfiguration.defaultservergroup
[database.sports2000]
autostart=true
configurations=sports2000.defaultconfiguration
databasename=d:\\work\\database\\101a\\AuditEnabled\\sports2000
defaultconfiguration=sports2000.defaultconfiguration
displayname=sports2000
[environment]
[servergroup.sports2000.defaultconfiguration.defaultservergroup]
configuration=sports2000.defaultconfiguration
displayname=defaultServerGroup
port=14000

dbtool db-name

                                     DATABASE TOOLS MENU - 10.1b
                                     -----------------------------------------------
                      1. SQL Width & Date Scan w/Report Option
                      2. SQL Width Scan w/Fix Option
                      3. Record Validation
                      4. Record Version Validation
                      5. Read database block(s)
                      6. Record fixup
                      7. Schema Validation
                      9. Enable/Disable File Logging
                      Q. Quit
                      Choice:

<connect>:(0=single-user 1=self-service >1=#threads)?

dsmUserConnect failed rc = -1

<table>: (Table number or all)?

<area>: (Area number or all)?

<display>: (verbose level 0-3)?

dbtool db-name 2 > filename.out

dbutil cmpdb db-name1 db-name2 [-t|-l|-l2]

proadsv { -start | -stop | -query }
        [ -port port-number ] [ -adminport port-number ]
        [ -cluster ] [ -hostname host-name ]
        [ -help ]

HKEY_LOCAL_MACHINE\\SOFTWARE\\PSC\\AdminService\\version\\StartupCmd

или

HKEY_LOCAL_MACHINE\\SOFTWARE\\PSC\\AdminService\\version\\ShutdownCmd

....AdminServer -port 9999 -adminport 7832

probkup [ online ] db-name [ incremental ] device-name
        [ enableai ] [ enableaiarchiver -aiarcdir dirlist
        [-aiarcinterval n] [-aiarcdircreate]]
        [ -estimate | -vs n | -bf n | -verbose | -scan
            | -io i | -com | -red i| -norecover
        ] ...

procluster db-name
  [enable [-pf params-file] [AI] [BI] [APW=n] [WDOG]
  | disable | start | stop | terminate | looksalive | isalaive ]

The cluster REGISTER command was successful. (10532)

Resource: db-name State: Looks Alive

Resource: db-name State: Not Alive

Resource: db-name State: Is Alive

Resource: db-name State: Is Alive

procopy source-db-name target-db-name [-newinstance ] [-silent]

prodb [ new-db-name ]
      [ empty | sports | isports | sports2000 | old-db-name | demo ]
      [ -newinstance ]

prodb new-db-name $DLC/empty2

prodel db-name

prolog db-name [ -online ]

prorest db-name device-name { -vp | -vf | -list }

SQL утилиты

• SQLDUMP
• SQLLOAD
• SQLSCHEMA
  

sqldump -u user_name [ -a password ] [ -C code_page_name ]
             -t [ owner_name.]table_name1 [ [,owner_name.]table_name2,... ]
              db_name

sqldump -u tucker -a sulky -t martin.customers,martin.products
progress:T:thunder:4077:salesdb

sqldump -u tucker -a sulky -t%.cust%,%.invent%,%.sales%
progress:T:thunder:4077:salesdb

sqldump -u tucker -a sulky -t %.% progress:T:thunder:4077:salesdb

A^B^CProgress sqlschema v1.0 Quote fmt
A^B^CTimestamp 1999-10-19 19:06:49:0000
A^B^CDatabase dumpdb.db
A^B^CProgress Character Set: iso8859-1
A^B^CJava Charcter Set: Unicode UTF-8
A^B^CDate Format: MM/DD/YYYY

sqldump -t \"\\\"Yearly Profits\\\"\" -u xxx -a yyy db_name

sqlload -u user_name [ -a password ] [ -C code_page_name ]
           -t [ owner_name.]table_name1 [ [,owner_name.]table_name2, ... ]
           [ -l log_file_name ] [ -b badfile_name ] [ -e max_errors ]
           [ -s skipcount ] [ -m maxrows ] [ -F comma | quote ]
            db_name

sqlload -u tucker -a sulky -t tucker.customers,tucker.products
progress:T:thunder:4077:salesdb

sqlload -u tucker -a sulky -t %.cust%,%.invent%,%.sales%
progress:T:thunder:4077:salesdb

sqldump -t \"\\\"Yearly Profits\\\"\" -u xxx -a yyy db_name

sqlschema -u user_name [ -a password ]
            [ -t [ owner_name.]table_name1 [,owner_name.]table_name2, ... ]
            [ -p [ owner_name.]procedure_name, ... ]
            [ -T [ owner_name.]trigger_name, ... ]
            [ -g [ owner_name.]table_name, ... ]
            [ -s [ owner_name.]tablename, ... ]
            [ -o output_file_name ]
            db_name

sqlschema -t tucker.customers,tucker.products -T
tucker.customers,tucker.products progress:T:thunder:4077:salesdb

sqlschema -u tucker -a sulky -t %.cust%,%.invent%,%.sales% -o
salesdbschema.dfsql progress:T:thunder:4077:salesdb