|
Here goes <<QPDSPFD101871.txt>> Best Regards Dennis Nel PRODUCTION SUPPORT Corporate IT ABSA Corporate & Merchant Bank T : 011 350 8109 F : 011 350 8004 M : 082 808 2687 E : dennisn@xxxxxxxxxx -----Original Message----- From: Graap, Ken [mailto:keg@xxxxxxxxxxxxx] Sent: 16 May 2003 02:42 To: 'Midrange Systems Technical Discussion' Subject: RE: DDM files and database Trigger program Could you post the file description so we can see how your triggers are defined? Kenneth -----Original Message----- From: Dennis Nel [mailto:dennisn@xxxxxxxxxx] Sent: Friday, May 16, 2003 4:20 AM To: midrange-l@xxxxxxxxxxxx Subject: DDM files and database Trigger program On our local server we have a physical file with two triggers defined; One on Change, The other on Insert. On a remote server we have a DDM link via TCP/ip defined to the file on the local server. The problem is when we change or insert on the remote server, the Trigger program doesn't fire up!! Does anyone have any suggestions? Best Regards Dennis Nel PRODUCTION SUPPORT Corporate IT ABSA Corporate & Merchant Bank T : 011 350 8109 F : 011 350 8004 M : 082 808 2687 E : dennisn@xxxxxxxxxx ______________________________________________ "The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Absa is liable neither for the proper, complete transmission of the information contained in this communication, nor for any delay in its receipt, nor for the assurance that it is virus-free." _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l. _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l. ______________________________________________ "The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Absa is liable neither for the proper, complete transmission of the information contained in this communication, nor for any delay in its receipt, nor for the assurance that it is virus-free."
midrange.com
5722SS1 V5R2M0 020719 Display File Description
16/05/03 15:40:22 Page 1
File . . . . . . . . . . . : ETRDET
Library . . . . . . . . . : WEBDBLIB
Type of information . . . . : *ALL
File attributes . . . . . . : *ALL
System . . . . . . . . . . : *LCL
Processor . . . . . . . . . : IBM AS/400 Display File Description Processor
File . : ETRDET Library . : WEBDBLIB Type of file . : Physical *DATA
Auxiliary Storage Pool ID . : 01
Data Base File Attributes
Externally described file . . . . . . . . . : Yes
File level identifier . . . . . . . . . . . : 1020608101342
Creation date . . . . . . . . . . . . . . . : 08/06/02
Text 'description' . . . . . . . . . . . . : TEXT ETRDET
Distributed file . . . . . . . . . . . . . : No
DBCS capable . . . . . . . . . . . . . . . : No
Maximum members . . . . . . . . . . . . . . : MAXMBRS 1
Number of constraints . . . . . . . . . . . : 0
Number of triggers . . . . . . . . . . . . : 3
Number of members . . . . . . . . . . . . . : 1
Access path maintenance . . . . . . . . . . : MAINT *IMMED
Access path recovery . . . . . . . . . . . : RECOVER *NO
Force keyed access path . . . . . . . . . . : FRCACCPTH *NO
Member size SIZE
Initial number of records . . . . . . . . : 10000
Increment number of records . . . . . . . : 1000
Maximum number of increments . . . . . . : 3
Record capacity . . . . . . . . . . . . . . : 13000
Allocate storage . . . . . . . . . . . . . : ALLOCATE *NO
Contiguous storage . . . . . . . . . . . . : CONTIG *NO
Preferred storage unit . . . . . . . . . . : UNIT *ANY
Records to force a write . . . . . . . . . : FRCRATIO *NONE
Maximum file wait time . . . . . . . . . . : WAITFILE *IMMED
Maximum record wait time . . . . . . . . . : WAITRCD 60
Max % deleted records allowed . . . . . . . : DLTPCT *NONE
Reuse deleted records . . . . . . . . . . . : REUSEDLT *NO
Coded character set identifier . . . . . . : CCSID 37
Allow read operation . . . . . . . . . . . : Yes
Allow write operation . . . . . . . . . . . : Yes
Allow update operation . . . . . . . . . . : ALWUPD *YES
Allow delete operation . . . . . . . . . . : ALWDLT *YES
Record format level check . . . . . . . . . : LVLCHK *YES
Access path . . . . . . . . . . . . . . . . : Keyed
Access path size . . . . . . . . . . . . . : ACCPTHSIZ *MAX1TB
Maximum key length . . . . . . . . . . . . : 18
Maximum record length . . . . . . . . . . . : 383
File is currently journaled . . . . . . . . : Yes
Current or last journal . . . . . . . . . . : ICJRN
Library . . . . . . . . . . . . . . . . . : MIDDBLIB
Journal images . . . . . . . . . . . . . . : IMAGES *BOTH
Journal entries to be omitted . . . . . . . : OMTJRNE *OPNCLO
Last journal start date/time . . . . . . . : 09/11/02 12:06:01
5722SS1 V5R2M0 020719 Display File Description
16/05/03 15:40:22 Page 2
File . : ETRDET Library . : WEBDBLIB Type of file . : Physical *DATA
Auxiliary Storage Pool ID . : 01
Access Path Description
Access path maintenance . . . . . . . . . . : MAINT *IMMED
Unique key values required . . . . . . . . : UNIQUE No
Key order . . . . . . . . . . . . . . . . . : Not specified
Access path journaled . . . . . . . . . . . : No
Access path . . . . . . . . . . . . . . . . : Keyed
Constraint Type . . . . . . . . . . . . . . : NONE
Number of key fields . . . . . . . . . . . : 2
Record format . . . . . . . . . . . . . . . : ETRDETR
Key field . . . . . . . . . . . . . . . . : ETRREFNO
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : UNSIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Key field . . . . . . . . . . . . . . . . : ETRORDNO
Sequence . . . . . . . . . . . . . . . : Ascending
Sign specified . . . . . . . . . . . . : UNSIGNED
Zone/digit specified . . . . . . . . . : *NONE
Alternative collating sequence . . . . : No
Sort Sequence . . . . . . . . . . . . . . . : SRTSEQ *HEX
Language identifier . . . . . . . . . . . . : LANGID ENU
5722SS1 V5R2M0 020719 Display File Description
16/05/03 15:40:22 Page 3
File . : ETRDET Library . : WEBDBLIB Type of file . : Physical *DATA
Auxiliary Storage Pool ID . : 01
Trigger Description
Trigger name . . . . . . . . . . . . . . . : TRG QSYS_TRIG_WEBDBLI
B___ETRDET_____000001
Trigger library . . . . . . . . . . . . . : WEBDBLIB
Trigger state . . . . . . . . . . . . . . : STATE *ENABLED
Trigger status . . . . . . . . . . . . . : *OPERATIVE
Trigger event . . . . . . . . . . . . . . : TRGEVENT *INSERT
Trigger time . . . . . . . . . . . . . . : TRGTIME *AFTER
Allow repeated change . . . . . . . . . . : ALWREPCHG *NO
Program Name . . . . . . . . . . . . . . : PGM CPMIDETRA
Library . . . . . . . . . . . . . . . . : WEBRTLIB
Program is threadsafe . . . . . . . . . . : THDSAFE *UNKNOWN
Multithreaded job action . . . . . . . . : MLTTHDACN *SYSVAL
Trigger type . . . . . . . . . . . . . . : *SYS
Trigger orientation . . . . . . . . . . . : *ROW
Trigger creation date and time . . . . . : 02/04/03 15:05:26
Number of trigger update columns . . . . : 0
Trigger name . . . . . . . . . . . . . . . : TRG QSYS_TRIG_WEBDBLI
B___ETRDET_____000002
Trigger library . . . . . . . . . . . . . : WEBDBLIB
Trigger state . . . . . . . . . . . . . . : STATE *ENABLED
Trigger status . . . . . . . . . . . . . : *OPERATIVE
Trigger event . . . . . . . . . . . . . . : TRGEVENT *UPDATE
Trigger time . . . . . . . . . . . . . . : TRGTIME *AFTER
Allow repeated change . . . . . . . . . . : ALWREPCHG *NO
Trigger update condition . . . . . . . . : TRGUPDCND *ALWAYS
Program Name . . . . . . . . . . . . . . : PGM CPMIDETRA
Library . . . . . . . . . . . . . . . . : WEBRTLIB
Program is threadsafe . . . . . . . . . . : THDSAFE *UNKNOWN
Multithreaded job action . . . . . . . . : MLTTHDACN *SYSVAL
Trigger type . . . . . . . . . . . . . . : *SYS
Trigger orientation . . . . . . . . . . . : *ROW
Trigger creation date and time . . . . . : 02/04/03 15:05:52
Number of trigger update columns . . . . : 0
Trigger name . . . . . . . . . . . . . . . : TRG QSYS_TRIG_WEBDBLI
B___ETRDET_____000003
Trigger library . . . . . . . . . . . . . : WEBDBLIB
Trigger state . . . . . . . . . . . . . . : STATE *ENABLED
Trigger status . . . . . . . . . . . . . : *OPERATIVE
Trigger event . . . . . . . . . . . . . . : TRGEVENT *DELETE
Trigger time . . . . . . . . . . . . . . : TRGTIME *AFTER
Allow repeated change . . . . . . . . . . : ALWREPCHG *NO
Program Name . . . . . . . . . . . . . . : PGM CPMIDETRA
Library . . . . . . . . . . . . . . . . : WEBRTLIB
Program is threadsafe . . . . . . . . . . : THDSAFE *UNKNOWN
Multithreaded job action . . . . . . . . : MLTTHDACN *SYSVAL
Trigger type . . . . . . . . . . . . . . : *SYS
Trigger orientation . . . . . . . . . . . : *ROW
Trigger creation date and time . . . . . : 02/04/03 15:06:06
Number of trigger update columns . . . . : 0
5722SS1 V5R2M0 020719 Display File Description
16/05/03 15:40:22 Page 4
File . : ETRDET Library . : WEBDBLIB Type of file . : Physical *DATA
Auxiliary Storage Pool ID . : 01
Member Description
Member . . . . . . . . . . . . . . . . . . : MBR ETRDET
Member level identifier . . . . . . . . . : 1020608101342
Member creation date . . . . . . . . . . : 08/06/02
Text 'description' . . . . . . . . . . . : TEXT ETRDET
Expiration date for member . . . . . . . : EXPDATE *NONE
Access path maintenance . . . . . . . . . : MAINT *IMMED
Access path recovery . . . . . . . . . . : RECOVER *NO
Member size SIZE
Initial number of records . . . . . . . : 10000
Increment number of records . . . . . . : 1000
Maximum number of increments . . . . . : 3
Current number of increments . . . . . . : 0
Record capacity . . . . . . . . . . . . . : 13000
Current number of records . . . . . . . . : 47
Number of deleted records . . . . . . . . : 0
Allocate storage . . . . . . . . . . . . : ALLOCATE *NO
Contiguous storage . . . . . . . . . . . : CONTIG *NO
Preferred storage unit . . . . . . . . . : UNIT *ANY
Records to force a write . . . . . . . . : FRCRATIO *NONE
Share open data path . . . . . . . . . . : SHARE *NO
Max % deleted records allowed . . . . . . : DLTPCT *NONE
Number of member accesses . . . . . . . . : 0
Data Space Activity Statistics . . . . . :
Data space size in bytes . . . . . . . : 24576
Physical file open accesses . . . . . . : 5,159
Physical file close accesses . . . . . : 5,159
Write operations . . . . . . . . . . . : 6
Update operations . . . . . . . . . . . : 2,303
Delete operations . . . . . . . . . . . :
Logical Reads . . . . . . . . . . . . . : 180,549
Physical Reads . . . . . . . . . . . . : 4,218
Clear operations . . . . . . . . . . . :
Data space copy operations . . . . . . :
Reorganize operations . . . . . . . . . :
Access paths builds/rebuilds . . . . . :
Records rejected by key selection . . . :
Records rejected by non-key selection . : 105,284
Records rejected by group-by selection. :
Access Path Activity Statistics . . . . . :
Access path logical reads . . . . . . . : 2,031
Access path physical reads . . . . . . :
Access path size . . . . . . . . . . . : 24576
Number of access path entries . . . . . : 47
Access path valid . . . . . . . . . . . : Yes
5722SS1 V5R2M0 020719 Display File Description
16/05/03 15:40:22 Page 5
File . : ETRDET Library . : WEBDBLIB Type of file . : Physical *DATA
Auxiliary Storage Pool ID . : 01
Member Description
Implicit access path sharing . . . . . : No
Access path journaled . . . . . . . . . : No
Number of unique partial key values . . :
Key field 1 . . . . . . . . . . . . . : 39
Key fields 1 - 2 . . . . . . . . . . : 47
Last change date/time . . . . . . . . . . : 16/05/03 15:38:20
Extract date/time . . . . . . . . . . . . : 23/08/28 12:03:06
Last extract date/time . . . . . . . . . : 23/08/28 12:03:06
Last save date/time . . . . . . . . . . . : 16/05/03 00:08:52
Last restore date/time . . . . . . . . . :
Last used date . . . . . . . . . . . . . : 16/05/03
Days used count . . . . . . . . . . . . . : 93
Reset date . . . . . . . . . . . . . . :
5722SS1 V5R2M0 020719 Display File Description
16/05/03 15:40:22 Page 6
File . : ETRDET Library . : WEBDBLIB Type of file . : Physical *DATA
Auxiliary Storage Pool ID . : 01
Record Format List
Record Format Level
Format Fields Length Identifier
ETRDETR 20 383 3C202B0B3A100
Text . . . :
Total number of formats . . . . . . . . . : 1
Total number of fields . . . . . . . . . . : 20
Total record length . . . . . . . . . . . : 383
5722SS1 V5R2M0 020719 Display File Description
16/05/03 15:40:22 Page 7
File . : ETRDET Library . : WEBDBLIB Type of file . : Physical *DATA
Auxiliary Storage Pool ID . : 01
Member List
Source Creation Last Change
Deleted
Member Size Type Date Date Time Records
Records
ETRDET 49152 08/06/02 16/05/03 15:38:20 47
0
Text: ETRDET
Total number of members . . . . . . . . . : 1
Total number of members not available . . : 0
Total records . . . . . . . . . . . . . . : 47
Total deleted records . . . . . . . . . . : 0
Total of member sizes . . . . . . . . . . : 49152
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
