链接其它系统的数据库的写法

主要是两部：

1、链接外部系统的数据库：（如果你是处在不对的服务器，这个是会链接失败的，这时你就要去确认正确的服务器，然后进行SM51转换）

2、SQL语句的写法：

 EXEC SQL PERFORMING line_item_audit.
      select      tb_invoices.invoice_id,
                  tb_invoice_lines.invoice_line_id,
                  tb_invoices.invoice_num,
                  tb_invoice_lines.line_num,
                  tb_invoices.calling_system_number,
                  tb_invoices.external_company_id,
                  to_char( tb_invoices.fiscal_date,'YYYYMMDD'),
                  to_char( tb_invoices.invoice_date,'YYYYMMDD'),
                  tb_invoices.currency_code,
                  tb_invoices.merchant_role,
                  tb_invoice_lines.gross_amount,
                  tb_invoice_lines.total_tax_amount,
                  tb_invoice_lines.credit_flag,
                  tb_invoice_lines.customer_number,
                  tb_invoice_lines.vendor_number,
                  tb_invoice_lines.transaction_type,
                  tb_invoice_lines.quantity,
                  tb_invoice_lines.qty_uom_code,
                  tb_invoice_lines.product_code,
                  tb_invoice_line_taxes.effective_zone_level,
                  tb_invoice_line_taxes.authority_type_name,
                  tb_invoice_line_taxes.tax_amount,
                  tb_invoice_line_taxes.taxable_basis,
                  tb_invoice_line_addresses.address_type,
                  tb_invoice_line_addresses.country,
                  tb_invoice_line_addresses.province,
                  tb_invoice_line_addresses.state,
                  tb_invoice_line_addresses.postcode,
                  tb_invoice_line_addresses.geocode,
                  tb_invoice_line_addresses.city
      into        :T_LI_AUDIT-invoice_id,
                  :T_LI_AUDIT-invoice_line_id,
                  :T_LI_AUDIT-invoice_num,
                  :T_LI_AUDIT-line_num,
                  :T_LI_AUDIT-calling_sys,
                  :T_LI_AUDIT-external_comp,
                  :T_LI_AUDIT-fiscal_date,
                  :T_LI_AUDIT-invoice_date,
                  :T_LI_AUDIT-currency_code,
                  :T_LI_AUDIT-merchant_role,
                  :T_LI_AUDIT-gross_amount,
                  :T_LI_AUDIT-total_tax,
                  :T_LI_AUDIT-credit_flag,
                  :T_LI_AUDIT-customer_number,
                  :T_LI_AUDIT-vendor_number,
                  :T_LI_AUDIT-transaction_type,
                  :T_LI_AUDIT-quantity,
                  :T_LI_AUDIT-qty_uom_code,
                  :T_LI_TAX-ZONE,
                  :T_LI_TAX-AUTHORITY,
                  :T_LI_TAX-TAX_AMOUNT,
                  :T_LI_TAX-TAXABLE_BASIS,
                  :T_LI_TJ-adr_type,
                  :T_LI_TJ-country,
                  :T_LI_TJ-province,
                  :T_LI_TJ-state,
                  :T_LI_TJ-postcode,
                  :T_LI_TJ-geocode,
                  :T_LI_TJ-city
            from  tb_invoices,
                  tb_invoice_lines,
                  tb_invoice_line_taxes,
                  tb_invoice_line_addresses
      where tb_invoices.external_company_id LIKE :L_BUKRS and
            ( tb_invoices.calling_system_number LIKE :CALL_SYS or
              ( tb_invoices.host_system LIKE :SYSID and
                tb_invoices.calling_system_number LIKE :MANDT ) ) and
             ( tb_invoices.fiscal_date BETWEEN to_date((:L_DATE_LOW),'YYYYMMDD') AND to_date((:L_DATE_HIGH),'YYYYMMDD') ) and
             tb_invoices.invoice_id = tb_invoice_lines.invoice_id and
             tb_invoice_line_taxes.invoice_line_id = tb_invoice_lines.invoice_line_id and
             tb_invoice_line_addresses.invoice_line_id = tb_invoice_lines.invoice_line_id
    ENDEXEC.

具体可以检索EXEC的用法：