What are the definition (CREATE TABLE, ALTER TABLE) commands for your new PTINFO table?
Jason Kramer University Archives and Records Management 002 Pearson Hall (302) 831 - 3127 (voice) (302) 831 - 6903 (fax) From: [email protected] [mailto:[email protected]] On Behalf Of marc schluter Sent: Tuesday, April 15, 2014 10:25 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Unload / Load problem Hi all I have a command file that Unloads data from a table so I can load it into a new DB. Basically I do Unload Data for Table Using Columns ....... that produces a file like the sample below. When I try to run the file to load the data to an empty table in a new DB I keep getting these errors below. This same command file has worked on several other Databases but for some reason this DB keeps giving me an error. I checked for Computed Columns and I am not Unloading them, I really don't know what else to look for. The new DB does have 3 new Columns that are not in the old DB. What else can I look for? Thanks Marc Value for Custnum cannot be null Error Incorrect number of values for this table (118) This is a sample of the Unloaded Data file. LOAD `PTINFO` USING CUSTNUM,f_name,l_name,address,city,state,ptzip,hm_phone,+ wk_phone,b_date,bdaycard,ssnum,sex,typclaim,married,midint,empstat,reff_by,sp+ _phone,sp_ssnum,statemen,work_acc,mail_lis,other_acc,finc_cla,pt_part,ins_nam+ e,relation,insured_add_7,insed_city_7,insed_state,insed_zip,insed_phone,insed+ _bday,insed_sex,insed_emp,insed_plan,other_ins,auto_wr,insco1,grnum1,idnum1,i+ nsco2,grnum2,idnum2,insco3,grnum3,recall,o_ins_name_9,assigyn,o_ins_bday_9b,o+ _ins_sex_9bb,o_ins_emp_name_9c,o_ins_plan_name_9d,ref_phy,ref_phy_id,off_wk,b+ k_word,prior_auth,pt_arrag,enter_date,xx10d,xx19,accidst,pttreat_dr,cur_chr,c+ ur_pay,cur_est,cur_pt,chr_30,pay_30,est_30,pt_30,chr_60,pay_60,est_60,pt_60,c+ hr_90,pay_90,est_90,pt_90,chr_120,pay_120,est_120,pt_120,est_adj,tot_adj,tot_+ bal,tot_pt,aa,date_lch,datecon,datelpay,amtperpd,ptdeath,pthold,latemess,pero+ v,lateint,inscomp3,ins3name,ins3idnum,ins3grnum,patemail,patpict,mxnotes,cll_+ phone,mcinfo,secrelation,wkphext,refphynpi NONUM 1,'John','Patient','Sample st','PAWHUSKA','OK','74129-','9181234567','9181239+ 876',12/31/1997,'N','123456789','M','7','M','A','3','Dr S Hays','9181111234'+ ,'123456789','1','N','N','N','CP',100,'SAME','1','SAME','SAME','NA','12345-'+ ,'9181112233',01/01/1995,'M','Box 11a','Box 11c','n','Y',2,'Box 11','Box 1a'+ ,1,'Box 9a','Box 9a',-0-,-0-,'N','Box 9D','N',-0-,-0-,'Box 9c','Box 9D','Box+ 17','Box 17a',01/01/1997,02/02/1997,'123','Will pay $100.00 every month?',+ 12/26/1997,'REDERVED 10 D','RESERVED 19','NA','1',0.00,0.00,0.00,0.00,0.00,+ 0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,290.00,-100.00,+ 290.00,0.00,-190.00,-190.00,0.00,0.00,-0-,10/07/1998,01/08/1999,03/12/1998,+ 0.00,-0-,'H','N',0.00,0.00,-0-,'na','na','na',-0-,-0-,-0-,-0-,-0-,-0-,-0-,+ -0-
