Merge Table

BSkelding · December 9th, 2004, 12:52 PM

I'm trying to create a merge table in MySQL. While I have had success in the past now it's showing an error 1016: Can't open file 'allclaims.MRG' (allclaims is the merge table I'm trying to create) Any ideas???? The query is below:

CREATE TABLE allclaims(
  `ClaimNumber` varchar(100) NOT NULL default '',
  `Null` varchar(100) NOT NULL default '',
  `ClaimsAdmin` varchar(100) NOT NULL default '',
  `ClaimType` varchar(100) NOT NULL default '',
  `HOSType` varchar(100) NOT NULL default '',
  `COB` varchar(100) NOT NULL default '',
  `Printed` varchar(100) NOT NULL default '',
  `CheckNum` varchar(100) NOT NULL default '',
  `SSN` varchar(100) NOT NULL default '',
  `Branch` varchar(100) NOT NULL default '',
  `Status` varchar(100) NOT NULL default '',
  `Loc` varchar(100) NOT NULL default '',
  `Relationship` varchar(100) NOT NULL default '',
  `PatientDOB` varchar(100) NOT NULL default '',
  `PlanCode` varchar(100) NOT NULL default '',
  `TIN` varchar(100) NOT NULL default '',
  `GroupName` varchar(100) NOT NULL default '',
  `PhyLast` varchar(100) NOT NULL default '',
  `PhyFirst` varchar(100) NOT NULL default '',
  `ProvCont` varchar(100) NOT NULL default '',
  `FromDOS` varchar(100) NOT NULL default '',
  `ThruDOS` varchar(100) NOT NULL default '',
  `POS` varchar(100) NOT NULL default '',
  `TOS` varchar(100) NOT NULL default '',
  `ProcCD` varchar(100) NOT NULL default '',
  `MOD` varchar(100) NOT NULL default '',
  `Diag` varchar(100) NOT NULL default '',
  `RevCD` varchar(100) NOT NULL default '',
  `Null2` varchar(100) NOT NULL default '',
  `Null3` varchar(100) NOT NULL default '',
  `Null4` varchar(100) NOT NULL default '',
  `Units` varchar(100) NOT NULL default '',
  `BilledChg` varchar(100) NOT NULL default '',
  `OverRC` varchar(100) NOT NULL default '',
  `ProvDiscount` varchar(100) NOT NULL default '',
  `AllowedAmt` varchar(100) NOT NULL default '',
  `OtherINS` varchar(100) NOT NULL default '',
  `ChgDeny` varchar(100) NOT NULL default '',
  `Copay` varchar(100) NOT NULL default '',
  `DedAmt` varchar(100) NOT NULL default '',
  `CoinsAmt` varchar(100) NOT NULL default '',
  `AmtPd` varchar(100) NOT NULL default '',
  `BenefitCode` varchar(100) NOT NULL default '',
  `DRGCode` varchar(100) NOT NULL default '',
  `MDCCode` varchar(100) NOT NULL default '',
  `LOS` varchar(100) NOT NULL default '',
  `CovType` varchar(100) NOT NULL default ''
) TYPE=MERGE UNION=(claimdata,claims2002,claims2003) INSERT_METHOD=LAST;