<div>Good Morning fellow PH listers:</div> <div> </div> <div>I'm getting the following bogus error when I execute a simple Quiz extract:</div> <div> </div> <div>execute CARS_ROOT:[WORK.PENNEYJ.QZS]CARS_OPEN_ITEMS_AGING1.QZC <BR>␊> execute CARS_ROOT:[WORK.PENNEYJ.QZS]CARS_OPEN_ITEMS_AGING1.QZC␍<BR>␊␍<BR>␊*E* Subfile already exists as direct file.¿␍<BR>␊%RMS-F-SEG, overlapping segments or segmented key must be string for key = !UL␍<BR>␊␍<BR>␊*W* The permanent subfile CARS_OPEN_ITEMS_AGING_SF1 will be cleared.␍<BR>␊*E* The file open type is inconsistent with the data dictionary type. ␍<BR>␊(CARS_OPEN_ITEMS_AGING_SF1)¿␍</div> <div> </div> <div>and</div> <div> </div> <div>execute CARS_ROOT:[WORK.PENNEYJ.QZS]CARS_OPEN_ITEMS_AGING2.QZC <BR>␊> execute CARS_ROOT:[WORK.PENNEYJ.QZS]CARS_OPEN_ITEMS_AGING2.QZC␍<BR>␊*E* Subfile already
exists as direct file.¿␍<BR>␊*E* The file open type is inconsistent with the data dictionary type. ␍<BR>␊(CARS_OPEN_ITEMS_AGING_SF1)¿␍</div> <div>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++</div> <div> </div> <div>The code is as followis:</div> <div> </div> <div>access cash_detail in cars_db</div> <div><BR>choose invoice_num "ON ACCT", "REFUND"</div> <div><BR>define d_rec_type char*2 = "CA"<BR>define d_rec_subtype char*2 = " "</div> <div>define d_proc_date zoned*8 = & <BR> nconvert(getsystemval("cars_rpt_proc_date",symbol))</div> <div>define d_age_date date = cash_batch_date of cash_detail<BR>define d_age num*6 = &<BR> days(d_proc_date) - days(cash_batch_date of cash_detail) <BR>define d_amount num*13 = trans_amt of cash_detail </div> <div><BR>report summary &<BR> division_num of cash_detail
&<BR> dec_pat_id of cash_detail &<BR> company_id of cash_detail & <BR> branch_id of cash_detail &<BR> invoice_num of cash_detail &<BR> d_rec_type &<BR> d_rec_subtype &<BR> d_proc_date & <BR> d_age_date & <BR> d_age & <BR> d_amount</div> <div><BR>set subfile name cars_open_items_aging_sf1 keep<BR>set report nolimit </div> <div><BR>build cars_open_items_aging1<BR></div> <div>and</div> <div> </div> <div>access *obligations</div> <div><BR>define d_rec_type char*2 = & <BR> "OC" if open_bal_amt of obligations < 0 & <BR> else "OI" if memo_inv_ind of obligations <> "M" & <BR> else "OM"<BR>define d_rec_subtype char*2 = insurer_level of obligations</div> <div>define d_proc_date zoned*8 = & <BR>
nconvert(getsystemval("cars_rpt_proc_date",symbol))</div> <div>define d_age_date date = due_date of obligations<BR>define d_age num*6 = &<BR> days(d_proc_date) - days(due_date of obligations) <BR>define d_amount num*13 = open_bal_amt of obligations</div> <div><BR>report summary &<BR> division_num of obligations &<BR> dec_pat_id of obligations &<BR> company_id of obligations &<BR> branch_id of obligations &<BR> invoice_num of obligations &<BR> d_rec_type &<BR> d_rec_subtype &<BR> d_proc_date & <BR> d_age_date & <BR> d_age & <BR> d_amount</div> <div><BR>set subfile name cars_open_items_aging_sf1 append<BR>set report nolimit </div> <div><BR>build cars_open_items_aging2</div> <div> </div> <div>We don't have current support.</div> <div> </div> <div>Any ideas would be appreciated!</div> <div> </div>
<div>Sincerely,</div> <div> </div> <div>JP in IL</div><BR><BR><DIV><STRONG>John M Penney, Partner</STRONG></DIV> <DIV><STRONG>The TechUnion Group</STRONG> </DIV> <DIV><STRONG>1532 Fern Street SW</STRONG></DIV> <DIV><STRONG>Olympia, WA 98502</STRONG></DIV> <DIV> </DIV> <DIV><STRONG>(360)789-8159</STRONG></DIV><p> 
<hr size=1>Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. <a href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ "> Try it now.</a>