I looked the sqlstate code up on this site and only saw references to stored procedures, does anyone know if that somehow relates to fox pro and the way odbc treats it? I'm going to try dumping the data to a text file to see what lies after the 35000 record mark, because I'm pretty sure that this is where the job has failed every time I ran it.Project:CFSPROD (datastage)
Job name:VfAssetExtract
Event #:710
Timestamp:7/1/2004 1:02:40 PM
Event type:Warning
User:DATASTAGE\u1250
Message:
VfAssetExtract..Transformer_6.DSLink7: DSD.BCIGetNext call to SQLFetch failed.
SQL statement:SELECT `asset`.`serial_num`, `asset`.`status_code`, `asset`.`asset_num`, `asset`.`contract`, `asset`.`legal`, `asset`.`inv_loc`, `asset`.`inv_code`, `asset`.`inv_method`, `asset`.`type`, `asset`.`mfg`, `asset`.`model`, `asset`.`description`, `asset`.`notes`, `asset`.`source_id`, `asset`.`customer_name`, `asset`.`orig_equip_cost`, `asset`.`orig_lease_date`, `asset`.`rental_pymt`, `asset`.`sec_deposit`, `asset`.`date_returned`, `asset`.`meter_rdg`, `asset`.`orig_resid`, `asset`.`booked_resid`, `asset`.`asking_price`, `asset`.`damage_billed`, `asset`.`damage_collected`, `asset`.`ti_invcnum`, `asset`.`ti_invcamt`, `asset`.`ti_invcdate`, `asset`.`ti_paidamt`, `asset`.`ti_paiddate`, `asset`.`ti_checkno`, `asset`.`ti_saleprice`, `asset`.`ti_funding`, `asset`.`ti_reason`, `asset`.`ti_subvar`, `asset`.`ti_damaged`, `asset`.`reseller`, `asset`.`resellto`, `asset`.`dest_id`, `asset`.`invoice_num`, `asset`.`invoice_date`, `asset`.`invoice_due_date`, `asset`.`invoice_inits`, `asset`.`last_pay_date`, `asset`.`last_pay_amt`, `asset`.`tot_pay_amt`, `asset`.`check_number`, `asset`.`total_check`, `asset`.`misc_amt`, `asset`.`misc_date`, `asset`.`misc_check`, `asset`.`misc_reason`, `asset`.`proceeds`, `asset`.`costs`, `asset`.`adjustment`, `asset`.`gain`, `asset`.`cs_entry`, `asset`.`months`, `asset`.`residpct`, `asset`.`basispct`, `asset`.`reducedpct`, `asset`.`basis`, `asset`.`commgain`, `asset`.`commission`, `asset`.`flag`, `asset`.`begindate`, `asset`.`enddate`, `asset`.`beginning`, `asset`.`returnseol`, `asset`.`returnsother`, `asset`.`sales`, `asset`.`gains`, `asset`.`writeoffs`, `asset`.`adjustments`, `asset`.`ending`, `asset`.`suppress`, `asset`.`pickedup`, `asset`.`pickedupby`, `asset`.`missingserial`, `asset`.`condition`, `asset`.`flagcondition`, `asset`.`flagcopycount`, `asset`.`flagoptions`, `asset`.`consigned`, `asset`.`cust_address1`, `asset`.`cust_address2`, `asset`.`cust_address3`, `asset`.`cust_city`, `asset`.`cust_state`, `asset`.`cust_zip`, `asset`.`writedown` FROM `asset`
SQLSTATE=22003, DBMS.CODE=0
[DataStage][SQL Client][ODBC][Microsoft][ODBC Visual FoxPro Driver]Error: Column 60 ( residpct )
Any help or advice on extracting from fox pro would be a big help.
Thanks,
Bill