Subfile error

[Grace, Ron (Chipping Sodbury) UK]

Hi All,

I'm running the following code on a HP3000 running MPEX and getting an error. I've checked that there are no existing temp or perm files with the same name. Any help would be appreciated

acc tickets

set proc lim 1000000000

def d-sep char*1 = "|"
def d-company char*2 = PARM
def d-invoice-num char*6 = ascii(invoice-num)
def d-acno char*6 = ascii(acno)
def d-adrs-num char*2 = ascii(adrs-num)
def d-tkt-qty char*8 = ascii(tkt-qty)
def d-actual-miles char*4 = ascii(actual-miles)
def d-hlr-rate char*8 = ascii(hlr-rate)
def d-actual-shr char*8 = ascii(actual-shr)
def d-actual-price char*8 = ascii(actual-price)
def d-tkt-value char*8 = ascii(tkt-value)
def d-tkt-vat char*8 = ascii(tkt-vat)
def d-tfr-price char*8 = ascii(tfr-price)
def d-ac-period char*4 = ascii(ac-period)
def d-week-num char*4 = ascii(week-num)
def d-z-doc-ref char*6 = ascii(z-doc-ref)
def d-sbi-date char*8 = ascii(sbi-date)
def d-haul-qty char*8 = ascii(haul-qty)
def d-haul-vat-rate char*8 = ascii(haul-vat-rate)
def d-material-cost char*1 = ""
def d-period-key char*1 = ""
def d-head char*574 = &
"CompanyNo|InvoiceNum|LedgerNo|AcNo|AdrsNum|UnitCode|" + &
"SaleUnit|Activity|Qref|MarginCentre|MaterialCost|DelpntCodeX|" + &
"LocationAddrs|" + &
"ExtraAdrs1|ExtraAdrs2|ProdGrCode|ProdCode|TktProdDesc|ProdCategory|" + &
"HaulCompanyNo|HaulLedger|Haulier|VehReg|QuoteNumber|RepIdNo|" + &
"CustOrder|EndUse|PriceCode|TktMinChgInd|TktAcctClass|TktVatInd|" + &
"TktHaulierInd|InvRunInd|TktExtracted|CollDelv|HaulVatInd|TktQty|" + &
"ActualMiles|HlrRate|ActualShr|ActualPrice|TktValue|TktVat|TfrPrice|" + &
"PeriodKey|DateCentury|AcPeriod|WeekNum|HaulageArea|TktDate|ZDocRef|" + &
"SelfBillNo|SbiDate|HaulQty|HaulVatRate|DocTypeIn|DocTypeSb"
def d-detail char*574 = &
d-company + d-sep + &
d-invoice-num + d-sep + &
ledger + d-sep + &
d-acno + d-sep + &
d-adrs-num + d-sep + &
unit-code-x + d-sep + &
sale-unit + d-sep + &
activity + d-sep + &
qref + d-sep + &
margin-centre + d-sep + &
d-material-cost + d-sep + &
delpnt-code-x + d-sep + &
location-addrs + d-sep + &
extra-adrs(1) + d-sep + &
extra-adrs(2) + d-sep + &
prod-gr-code + d-sep + &
prod-code + d-sep + &
tkt-prod-desc + d-sep + &
prod-category + d-sep + &
haul-company-no + d-sep + &
haul-ledger + d-sep + &
haulier + d-sep + &
veh-reg + d-sep + &
quote-number + d-sep + &
rep-id-no + d-sep + &
cust-order + d-sep + &
end-use + d-sep + &
price-code + d-sep + &
tkt-min-chg-ind + d-sep + &
tkt-acct-class + d-sep + &
tkt-vat-ind + d-sep + &
tkt-haulier-ind + d-sep + &
inv-run-ind + d-sep + &
tkt-extracted + d-sep + &
coll-delv + d-sep + &
haul-vat-ind + d-sep + &
d-tkt-qty + d-sep + &
d-actual-miles + d-sep + &
d-hlr-rate + d-sep + &
d-actual-shr + d-sep + &
d-actual-price + d-sep + &
d-tkt-value + d-sep + &
d-tkt-vat + d-sep + &
d-tfr-price + d-sep + &
d-period-key + d-sep + &
date-century + d-sep + &
d-ac-period + d-sep + &
d-week-num + d-sep + &
tkt-hlge-unit + d-sep + &
tkt-date + d-sep + &
d-z-doc-ref + d-sep + &
self-bill-x + d-sep + &
d-sbi-date + d-sep + &
d-haul-qty + d-sep + &
d-haul-vat-rate + d-sep + &
doc-type-in + d-sep + &
doc-type-sb

subfile rgtkts keep nodict at initial include &
d-head

subfile rgtkts append nodict alias rgtkts1 include d-detail

Go


And the error I get is even though I'm using 'NODICT'

Executing request 1 ...

D-COMPANY: 01
-------------------------------------------------------------------------------
File error on dictionary portion of subfile.
-------------------------------------------------------------------------------
The file does not exist in specified domain; the file was not found.  (FILE

OP

Action Taken: Run terminated.
-------------------------------------------------------------------------------

Records read:
  TICKETS                                  0

Transactions processed:                    0

Records processed:                     Added    Updated  Unchanged    Deleted
  RGTKTS                                   0          0          0          0
  RGTKTS1                                  0          0          0          0

Finished.
>

Each of Hanson Aggregates, Hanson Aggregates UK, Hanson Bath & Portland Stone, Hanson Construction Projects, Hanson Contracting, Hanson Premix, Hanson Recycling, Ashbridge Concrete and Supamix is a trading name of Hanson Quarry Products Europe Limited. Hanson Quarry Products Europe Limited is a private limited company incorporated in England and Wales with registered number 00300002 and with registered address Hanson House, 14, Castle Hill, Maidenhead, Berkshire

Hanson Quarry Products Europe Limited is a member of the HeidelbergCement Group.

This e-mail and any attachment transmitted with it are confidential and are intended for the named person’s use only. The contents of the e-mail may contain sensitive and private or legally privileged information. If you have received this e-mail in error, please delete it (and any attachment) from your system and notify the sender immediately. You should not retain, copy or print the contents of this e-mail (or any attachment) nor should you, directly or indirectly, disclose or distribute the contents to anyone.