|
midrange.com
Ok my friends I am delving deeper into SQL and I need your help.
File FRP001 was created using a SQL Statement
CREATE TABLE PRADATA.FRP001
(
FHOT DECIMAL(3, 0) NOT NULL,
FHPRO DECIMAL(7, 0) NOT NULL,
FHSEQ DECIMAL(3, 0) NOT NULL,
FHDT DECIMAL(3, 0) NOT NULL,
FHSN DECIMAL(7, 0) NOT NULL,
FHST NUMERIC(1, 0) NOT NULL,
FHSLSM DECIMAL(5, 0) NOT NULL,
FHTB CHAR(3) NOT NULL,
FHTN CHAR(3) NOT NULL,
FHTS CHAR(2) NOT NULL,
FHRBN DECIMAL(6, 0) NOT NULL,
FHRBNS CHAR(2) NOT NULL,
FHTOTP DECIMAL(5, 0) NOT NULL,
FHHAZ CHAR(1) NOT NULL,
FHHAZC CHAR(6) NOT NULL,
FHDCLV DECIMAL(9, 2) NOT NULL,
FHSHST CHAR(1) NOT NULL,
FHCHG DECIMAL(7, 2) NOT NULL,
FHPROD DECIMAL(7, 2) NOT NULL,
FHEXCC CHAR(1) NOT NULL,
FHEXCR DECIMAL(5, 4) NOT NULL,
FHEXCD DECIMAL(6, 0) NOT NULL,
FHEXC8 DECIMAL(8, 0) NOT NULL,
FHRTYP CHAR(1) NOT NULL,
FHTRM CHAR(3) NOT NULL,
FHOPB DECIMAL(7, 2) NOT NULL,
FHPUD DECIMAL(7, 0) NOT NULL,
FHPUDR NUMERIC(1, 0) NOT NULL,
FHPUUN CHAR(15) NOT NULL,
FHPUDT DECIMAL(6, 0) NOT NULL,
FHPUD8 DECIMAL(8, 0) NOT NULL,
FHPUT CHAR(1) NOT NULL,
FHPUR DECIMAL(7, 2) NOT NULL,
FHBL# CHAR(25) NOT NULL,
FHSNUM CHAR(15) NOT NULL,
FHPO CHAR(15) NOT NULL,
FHDEPT CHAR(10) NOT NULL,
FHSCC CHAR(1) NOT NULL,
FHSCCB NUMERIC(2, 0) NOT NULL,
FHPALC CHAR(1) NOT NULL,
FHCUBE DECIMAL(3, 0) NOT NULL,
FHTR# CHAR(15) NOT NULL,
FHLOAP DECIMAL(3, 0) NOT NULL,
FHILC CHAR(4) NOT NULL,
FHSCD CHAR(7) NOT NULL,
FHSNM CHAR(30) NOT NULL,
FHSA1 CHAR(30) NOT NULL,
FHSA2 CHAR(30) NOT NULL,
FHSCT CHAR(20) NOT NULL,
FHSST CHAR(2) NOT NULL,
FHSZIP CHAR(6) NOT NULL,
FHSZP4 CHAR(4) NOT NULL,
FHCCD CHAR(7) NOT NULL,
FHCNM CHAR(30) NOT NULL,
FHCA1 CHAR(30) NOT NULL,
FHCA2 CHAR(30) NOT NULL,
FHCCT CHAR(20) NOT NULL,
FHCST CHAR(2) NOT NULL,
FHCZIP CHAR(6) NOT NULL,
FHCZP4 CHAR(4) NOT NULL,
FHBTC CHAR(7) NOT NULL,
FHBNM CHAR(30) NOT NULL,
FHBA1 CHAR(30) NOT NULL,
FHBA2 CHAR(30) NOT NULL,
FHBCT CHAR(20) NOT NULL,
FHBST CHAR(2) NOT NULL,
FHBZIP CHAR(6) NOT NULL,
FHBZP4 CHAR(4) NOT NULL,
FHXF CHAR(4) NOT NULL,
FHXFA CHAR(15) NOT NULL,
FHXFB CHAR(15) NOT NULL,
FHXFBD DECIMAL(6, 0) NOT NULL,
FHXFB8 DECIMAL(8, 0) NOT NULL,
FHXT CHAR(4) NOT NULL,
FHXTA CHAR(15) NOT NULL,
FHXTB CHAR(15) NOT NULL,
FHXTBD DECIMAL(6, 0) NOT NULL,
FHXTB8 DECIMAL(8, 0) NOT NULL,
FHFPC DECIMAL(3, 2) NOT NULL,
FHOPC DECIMAL(3, 2) NOT NULL,
FHTPC DECIMAL(3, 2) NOT NULL,
FHF$ DECIMAL(7, 2) NOT NULL,
FHO$ DECIMAL(7, 2) NOT NULL,
FHT$ DECIMAL(7, 2) NOT NULL,
FHPF$ DECIMAL(7, 2) NOT NULL,
FHPO$ DECIMAL(7, 2) NOT NULL,
FHPT$ DECIMAL(7, 2) NOT NULL,
FHER$ DECIMAL(7, 2) NOT NULL,
FHCOD DECIMAL(9, 2) NOT NULL,
FHOTRV DECIMAL(7, 2) NOT NULL,
FHLHRV DECIMAL(7, 2) NOT NULL,
FHBTRV DECIMAL(7, 2) NOT NULL,
FHDTRV DECIMAL(7, 2) NOT NULL,
FHSPRV DECIMAL(7, 2) NOT NULL,
FHSPRC CHAR(2) NOT NULL,
FHALLF CHAR(1) NOT NULL,
FHALLD DECIMAL(7, 2) NOT NULL,
FHALLP DECIMAL(3, 3) NOT NULL,
FHIPS CHAR(1) NOT NULL,
FHOPS CHAR(1) NOT NULL,
FHCN NUMERIC(1, 0) NOT NULL,
FHPTC DECIMAL(3, 0) NOT NULL,
FHPDC DECIMAL(3, 0) NOT NULL,
FHRT DECIMAL(3, 0) NOT NULL,
FHRTD DECIMAL(6, 0) NOT NULL,
FHRTD8 DECIMAL(8, 0) NOT NULL,
FHRTT DECIMAL(4, 0) NOT NULL,
FHRTL CHAR(4) NOT NULL,
FHRMOT DECIMAL(3, 0) NOT NULL,
FHRMNF DECIMAL(5, 0) NOT NULL,
FHCMOT DECIMAL(3, 0) NOT NULL,
FHCMNF DECIMAL(5, 0) NOT NULL,
FHDADT DECIMAL(6, 0) NOT NULL,
FHDAD8 DECIMAL(8, 0) NOT NULL,
FHDATM DECIMAL(4, 0) NOT NULL,
FHDACD CHAR(3) NOT NULL,
FHDDAY NUMERIC(2, 0) NOT NULL,
FHLMOT DECIMAL(3, 0) NOT NULL,
FHLMNF DECIMAL(5, 0) NOT NULL,
FHNBB DECIMAL(3, 0) NOT NULL,
FHBBC CHAR(3) NOT NULL,
FHDLD DECIMAL(7, 0) NOT NULL,
FHDLDR NUMERIC(1, 0) NOT NULL,
FHDLT CHAR(1) NOT NULL,
FHDLR DECIMAL(7, 2) NOT NULL,
FHDRC DECIMAL(7, 2) NOT NULL,
FHDC CHAR(1) NOT NULL,
FHDDAT DECIMAL(6, 0) NOT NULL,
FHDDA8 DECIMAL(8, 0) NOT NULL,
FHDTIM DECIMAL(4, 0) NOT NULL,
FHSTAT CHAR(1) NOT NULL,
FHCO DECIMAL(3, 0) NOT NULL,
FHDIV DECIMAL(3, 0) NOT NULL,
FHUWGT CHAR(1) NOT NULL,
FHSWGT DECIMAL(7, 0) NOT NULL,
FHRWGT DECIMAL(7, 0) NOT NULL,
FHTWGT DECIMAL(7, 0) NOT NULL,
FHADAT DECIMAL(6, 0) NOT NULL,
FHADA8 DECIMAL(8, 0) NOT NULL,
FHATIM DECIMAL(6, 0) NOT NULL,
FHPDAT DECIMAL(6, 0) NOT NULL,
FHPDA8 DECIMAL(8, 0) NOT NULL,
FHUDAT DECIMAL(6, 0) NOT NULL,
FHUDA8 DECIMAL(8, 0) NOT NULL,
FHUTIM DECIMAL(6, 0) NOT NULL,
FHUID CHAR(10) NOT NULL,
FHSOT DECIMAL(3, 0) NOT NULL,
FHSPRO DECIMAL(7, 0) NOT NULL,
FHSSUF CHAR(2) NOT NULL,
FHCLRK CHAR(10) NOT NULL,
FHENTL DECIMAL(3, 0) NOT NULL,
FHRATE CHAR(10) NOT NULL,
FHAUD CHAR(10) NOT NULL,
FHHDSS DECIMAL(7, 2) NOT NULL,
FHHDNS CHAR(7) NOT NULL,
FHHDSC DECIMAL(7, 2) NOT NULL,
FHHDNC CHAR(7) NOT NULL,
FHHDPS DECIMAL(7, 2) NOT NULL,
FHHDOS CHAR(7) NOT NULL,
FHHDPC DECIMAL(7, 2) NOT NULL,
FHHDOC CHAR(7) NOT NULL,
FHRBSA DECIMAL(7, 2) NOT NULL,
FHRBSC CHAR(7) NOT NULL,
FHRBPA DECIMAL(7, 2) NOT NULL,
FHRBPC CHAR(7) NOT NULL,
FHREVD DECIMAL(6, 0) NOT NULL,
FHREV8 DECIMAL(8, 0) NOT NULL,
FHPURT DECIMAL(7, 2) NOT NULL,
FHPURP DECIMAL(7, 0) NOT NULL,
FHOTRT DECIMAL(7, 2) NOT NULL,
FHLHRT DECIMAL(7, 2) NOT NULL,
FHBTRT DECIMAL(7, 2) NOT NULL,
FHBTRP DECIMAL(3, 0) NOT NULL,
FHDTRT DECIMAL(7, 2) NOT NULL,
FHDTRP DECIMAL(3, 0) NOT NULL,
FHDLRT DECIMAL(7, 2) NOT NULL,
FHDLRP DECIMAL(7, 0) NOT NULL,
FHSPRT DECIMAL(7, 2) NOT NULL,
FHSPRP CHAR(2) NOT NULL,
FHPWGT DECIMAL(7, 0) NOT NULL,
FHBILS CHAR(1) NOT NULL,
FHBILH CHAR(1) NOT NULL,
FHBILV CHAR(1) NOT NULL,
FHBILT CHAR(1) NOT NULL,
FHSUAS DECIMAL(7, 2) NOT NULL,
FHSUAC DECIMAL(7, 2) NOT NULL,
FHSUA3 DECIMAL(7, 2) NOT NULL,
FHSUAF DECIMAL(7, 2) NOT NULL,
FHSUTF CHAR(1) NOT NULL,
FHSUAT DECIMAL(7, 2) NOT NULL,
FHSUTT CHAR(1) NOT NULL,
FHBTYP CHAR(1) NOT NULL,
FHBWGT DECIMAL(7, 0) NOT NULL,
FHBDSC DECIMAL(7, 2) NOT NULL,
FHBCOD DECIMAL(9, 2) NOT NULL,
FHBSC CHAR(7) NOT NULL,
FHBSA DECIMAL(7, 2) NOT NULL,
FHBSD DECIMAL(6, 0) NOT NULL,
FHBSD8 DECIMAL(8, 0) NOT NULL,
FHBSS CHAR(1) NOT NULL,
FHBCC CHAR(7) NOT NULL,
FHBCA DECIMAL(7, 2) NOT NULL,
FHBCD DECIMAL(6, 0) NOT NULL,
FHBCD8 DECIMAL(8, 0) NOT NULL,
FHBCS CHAR(1) NOT NULL,
FHB3C CHAR(7) NOT NULL,
FHB3A DECIMAL(7, 2) NOT NULL,
FHB3D DECIMAL(6, 0) NOT NULL,
FHB3D8 DECIMAL(8, 0) NOT NULL,
FHB3S CHAR(1) NOT NULL,
FHBXFC CHAR(7) NOT NULL,
FHBXFA DECIMAL(7, 2) NOT NULL,
FHBXFD DECIMAL(6, 0) NOT NULL,
FHBXF8 DECIMAL(8, 0) NOT NULL,
FHBXFT CHAR(1) NOT NULL,
FHBXFS CHAR(1) NOT NULL,
FHBXTC CHAR(7) NOT NULL,
FHBXTA DECIMAL(7, 2) NOT NULL,
FHBXTD DECIMAL(6, 0) NOT NULL,
FHBXT8 DECIMAL(8, 0) NOT NULL,
FHBXTT CHAR(1) NOT NULL,
FHBXTS CHAR(1) NOT NULL,
FHCS CHAR(1) NOT NULL,
FHXS1 CHAR(1) NOT NULL,
FHXS2 CHAR(1) NOT NULL,
FHXS3 CHAR(2) NOT NULL,
FHXS4 CHAR(4) NOT NULL,
FHXA1 DECIMAL(7, 2) NOT NULL,
FHXA2 DECIMAL(7, 2) NOT NULL,
FHXA3 DECIMAL(7, 2) NOT NULL,
FHXA4 DECIMAL(7, 2) NOT NULL,
FHPKGT CHAR(4) NOT NULL,
FHTPKG DECIMAL(5, 0) NOT NULL,
FHTPLT DECIMAL(5, 0) NOT NULL,
FHADCR CHAR(10) NOT NULL,
FHADDT DECIMAL(8, 0) NOT NULL,
FHADTM DECIMAL(6, 0) NOT NULL,
FHUPCR CHAR(10) NOT NULL,
FHLUPD DECIMAL(8, 0) NOT NULL,
FHLUTM DECIMAL(6, 0) NOT NULL,
FHX1 CHAR(1) NOT NULL,
FHX2 CHAR(1) NOT NULL,
FHX3 CHAR(1) NOT NULL,
FHX4 CHAR(1) NOT NULL,
FHX5 CHAR(1) NOT NULL,
FHX6 CHAR(1) NOT NULL,
FHX7 CHAR(1) NOT NULL,
FHX8 CHAR(1) NOT NULL,
FHX9 CHAR(1) NOT NULL,
FHX10 CHAR(1) NOT NULL,
FHY1 CHAR(1) NOT NULL,
FHY2 CHAR(2) NOT NULL,
FHY3 CHAR(2) NOT NULL,
FHY4 CHAR(2) NOT NULL,
FHY5 CHAR(2) NOT NULL,
FHY6 CHAR(2) NOT NULL,
FHY7 CHAR(2) NOT NULL,
FHY8 CHAR(2) NOT NULL,
FHY9 CHAR(2) NOT NULL,
FHY10 CHAR(2) NOT NULL,
FHXDT1 DECIMAL(8, 0) NOT NULL,
FHXDT2 DECIMAL(8, 0) NOT NULL,
FHXDT3 DECIMAL(8, 0) NOT NULL,
FHXDT4 DECIMAL(8, 0) NOT NULL,
FHXDT5 DECIMAL(8, 0) NOT NULL,
FHXDT6 DECIMAL(8, 0) NOT NULL,
FHXDT7 DECIMAL(8, 0) NOT NULL,
FHXDT8 DECIMAL(8, 0) NOT NULL,
FHXDT9 DECIMAL(8, 0) NOT NULL,
FHXDT0 DECIMAL(8, 0) NOT NULL,
FHCUFT DECIMAL(8, 3) NOT NULL,
FHLNFT DECIMAL(5, 2) NOT NULL,
FHA1 CHAR(7) NOT NULL,
FHA2 CHAR(7) NOT NULL,
FHA3 CHAR(7) NOT NULL,
FHA4 CHAR(7) NOT NULL,
FHA5 CHAR(7) NOT NULL,
FHRATH CHAR(15) NOT NULL,
FHPROA CHAR(8) NOT NULL,
FHPROS CHAR(2) NOT NULL,
FHPRSA CHAR(8) NOT NULL,
FHPRSS CHAR(2) NOT NULL,
FHEDDATE DATE NOT NULL,
FHEDTIME TIME NOT NULL,
FHRATED CHAR(1) NOT NULL,
CONSTRAINT PRADATA.Q_PRADATA_FRP001_FHOT_00001 PRIMARY KEY(FHOT,
FHPRO)
);
I create a table FRP001SUP with the following SQL Statement:
CREATE TABLE PRADATA.FRP001SUP
(FHSOT DECIMAL (03,00) NOT NULL
,FHSPRO DECIMAL (07,00) NOT NULL
,FHSPALTPCS DECIMAL (05,00)
,FHSBSCODE CHARACTER (03)
,FHSMISCREV DECIMAL (09,02)
,FHSSPLHCD NUMERIC (01,00)
,FHSCSTSLCD CHARACTER (01)
,FHSCSHDATE CHARACTER (06)
,FHSDNSTYCD NUMERIC (02,00)
,FHSOANUM NUMERIC (02,00)
,FHSDANUM NUMERIC (02,00)
,FHSINSDLVY CHARACTER (01)
,FHSARBCHRG CHARACTER (01)
,FHSATRNSDY NUMERIC (01,00)
,FHSBLDSHAC NUMERIC (06,00)
,FHSTRSDYOR NUMERIC (02,00)
,FHSSGNOVR CHARACTER (01)
,FHSPCKCOST NUMERIC (05,02)
,FHSDLVCOST NUMERIC (05,02)
,FHSBBLCOST NUMERIC (05,02)
,FHSODKCOST NUMERIC (05,02)
,FHSDDKKCST NUMERIC (05,02)
,FHSLHLCOST DECIMAL (07,02)
,FHSINSACLM NUMERIC (07,02)
,FHSSHPSTOP NUMERIC (04,02)
,FHSASHPSTP NUMERIC (02,00)
,FHSADJREV NUMERIC (06,02)
,FHS125MILG NUMERIC (04,00)
,FHSPREVFLG CHARACTER (01)
,FHSBILCOLL NUMERIC (03,02)
,FHSSELCODE CHARACTER (01)
,FHSSYNPCOD CHARACTER (01)
,FHSOSDCODE CHARACTER (01)
,FHSMLTSHDC CHARACTER (01)
,FHSEDI214C CHARACTER (03)
,FHSPK CHARACTER (01)
,FHSTERMCRS CHARACTER (01)
,FHS002 CHARACTER (01)
,FHSTOTEXTN DECIMAL (07,02)
,FHSDISCCDE CHARACTER (02)
,FHSCONSTRM CHARACTER (03)
,FHSBOLAFLG CHARACTER (01)
,FHSDRAFLAG CHARACTER (01)
,FHSCONSIGN VARCHAR (20)
,FHSMSTINST VARCHAR (20)
,PRIMARY KEY (FHOT,FHPRO)
,FOREIGN KEY (FHSOT,FHSPRO) REFERENCES FRP001 (FHOT,FHPRO)
)LABEL ON TABLE PRADATA.FRP001SUP IS 'Freight Bill Header Supplemental
Table';
*** None of the two file are journaled. ***
I have recompiled the RPGLE program that accesses FRP001. When the
program tries to access the file FRP001 I get this error:
Message ID . . . . . . : CPF4328 Severity . . . . . . . : 50
Message type . . . . . : Escape
Date sent . . . . . . : 03/02/07 Time sent . . . . . . :
15:56:32
Message . . . . : Member FRP001 not journaled to journal *N.
Cause . . . . . : Member FRP001 file FRP001 in library PRADATA is not
journaled to journal *N in library *N for commitment definition
QDBCMTDFN.
The journal specified is used by commitment definition QDBCMTDFN. If
*N is
specified for the journal, the file is not journaled. If the file is a
logical file, all based-on physical files may not be journaled to the
same
journal as required by commitment control.
Recovery . . . : Ensure the file being opened is journaled. For
logical
files, make sure that the based-on physical files are journaled to the
same
journal.
Technical description . . . . . . . . : The commitment definition
identifier
is X'10010100000000104ECA'.
Bruce Collins
IT Architect
AAA Cooper Transportation
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.
