project QadFinancials > class BMFGInvoiceHistory > API query SelectMfgInvoiceHistory


query filter (table tFilter)


tcBusinessFieldNametcDataTypetcOperator
icDomainCodec=
tih_hist.ih__chr01c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih__chr02c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih__chr03c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih__chr04c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih__chr05c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih__chr06c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih__chr07c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih__chr08c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih__chr09c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih__chr10c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih__dec01d=,>=,>,<>,<=,<
tih_hist.ih__dec02d=,>=,>,<>,<=,<
tih_hist.ih__dte01t=,>=,>,<>,<=,<
tih_hist.ih__dte02t=,>=,>,<>,<=,<
tih_hist.ih__log01l=,<>
tih_hist.ih__qad01d=,>=,>,<>,<=,<
tih_hist.ih__qad02d=,>=,>,<>,<=,<
tih_hist.ih__qad03d=,>=,>,<>,<=,<
tih_hist.ih__qad04i=,>=,>,<>,<=,<
tih_hist.ih__qadc01c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih__qadc02c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih__qadc03c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih__qadc04c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih__qadc05c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih__qadd01d=,>=,>,<>,<=,<
tih_hist.ih__qadd02d=,>=,>,<>,<=,<
tih_hist.ih__qadd03d=,>=,>,<>,<=,<
tih_hist.ih__qadi01i=,>=,>,<>,<=,<
tih_hist.ih__qadi02i=,>=,>,<>,<=,<
tih_hist.ih__qadi03i=,>=,>,<>,<=,<
tih_hist.ih__qadl01l=,<>
tih_hist.ih__qadl02l=,<>
tih_hist.ih__qadl03l=,<>
tih_hist.ih__qadt01t=,>=,>,<>,<=,<
tih_hist.ih__qadt02t=,>=,>,<>,<=,<
tih_hist.ih__qadt03t=,>=,>,<>,<=,<
tih_hist.ih_ar_acctc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_ar_ccc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_ar_subc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_bankc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_batchc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_billc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_bolc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_ca_nbrc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_cartonsi=,>=,>,<>,<=,<
tih_hist.ih_channelc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_cmtindxi=,>=,>,<>,<=,<
tih_hist.ih_cncl_datet=,>=,>,<>,<=,<
tih_hist.ih_conf_datet=,>=,>,<>,<=,<
tih_hist.ih_conrepc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_cr_cardc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_cr_initc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_cr_termsc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_creditl=,<>
tih_hist.ih_crprlistc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_currc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_custc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_cust_poc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_custref_vall=,<>
tih_hist.ih_daybookc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_daybooksetc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_disc_pctd=,>=,>,<>,<=,<
tih_hist.ih_divc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_domainc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_due_datet=,>=,>,<>,<=,<
tih_hist.ih_ent_exd=,>=,>,<>,<=,<
tih_hist.ih_ex_rated=,>=,>,<>,<=,<
tih_hist.ih_ex_rate2d=,>=,>,<>,<=,<
tih_hist.ih_ex_ratetypec=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_export_batchi=,>=,>,<>,<=,<
tih_hist.ih_export_datet=,>=,>,<>,<=,<
tih_hist.ih_export_timei=,>=,>,<>,<=,<
tih_hist.ih_exru_seqi=,>=,>,<>,<=,<
tih_hist.ih_fcg_codec=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_fix_prl=,<>
tih_hist.ih_fix_ratel=,<>
tih_hist.ih_fobc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_fr_listc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_fr_min_wtd=,>=,>,<>,<=,<
tih_hist.ih_fr_termsc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_fsm_typec=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_fst_idc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_inv_crc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_inv_datet=,>=,>,<>,<=,<
tih_hist.ih_inv_mthdc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_inv_nbrc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_invoicedl=,<>
tih_hist.ih_invoicetotald=,>=,>,<>,<=,<
tih_hist.ih_invoicetypec=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_langc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_mod_datet=,>=,>,<>,<=,<
tih_hist.ih_nbrc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_ord_datet=,>=,>,<>,<=,<
tih_hist.ih_partiall=,<>
tih_hist.ih_poc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_pr_listc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_pr_list2c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_prep_taxd=,>=,>,<>,<=,<
tih_hist.ih_prepaidd=,>=,>,<>,<=,<
tih_hist.ih_priced_dtt=,>=,>,<>,<=,<
tih_hist.ih_pricing_dtt=,>=,>,<>,<=,<
tih_hist.ih_primaryl=,<>
tih_hist.ih_print_bll=,<>
tih_hist.ih_print_pll=,<>
tih_hist.ih_print_sol=,<>
tih_hist.ih_projectc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_pstl=,<>
tih_hist.ih_pst_idc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_pst_pctd=,>=,>,<>,<=,<
tih_hist.ih_quotec=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_req_datet=,>=,>,<>,<=,<
tih_hist.ih_revi=,>=,>,<>,<=,<
tih_hist.ih_rmksc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_rstk_pctd=,>=,>,<>,<=,<
tih_hist.ih_sa_nbrc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_sch_mthdc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_schedl=,<>
tih_hist.ih_secondaryl=,<>
tih_hist.ih_shipc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_ship_datet=,>=,>,<>,<=,<
tih_hist.ih_ship_engl=,<>
tih_hist.ih_ship_poc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_shipviac=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_sitec=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_sized=,>=,>,<>,<=,<
tih_hist.ih_size_umc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_sourcec=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_statc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_tax_datet=,>=,>,<>,<=,<
tih_hist.ih_tax_envc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_tax_usagec=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_taxablel=,<>
tih_hist.ih_taxcc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_to_invl=,<>
tih_hist.ih_trl_amtd=,>=,>,<>,<=,<
tih_hist.ih_trl1_amtd=,>=,>,<>,<=,<
tih_hist.ih_trl1_cdc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_trl2_amtd=,>=,>,<>,<=,<
tih_hist.ih_trl2_cdc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_trl3_amtd=,>=,>,<>,<=,<
tih_hist.ih_trl3_cdc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_typec=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_user1c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_user2c=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_useridc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.ih_weightd=,>=,>,<>,<=,<
tih_hist.ih_weight_umc=,>=,>,<>,<=,<,begins,can-do,matches
tih_hist.oid_ih_histd=,>=,>,<>,<=,<


Parameters (internal)


icDomainCodecharacterDomain Code


query condition


  each ih_hist where
ih_hist.ih_domain = icDomainCode


query resultset tqSelectMfgInvoiceHistory


field namedata typedb fielddescription
tcih__chr01characterih_hist.ih__chr01
tcih__chr02characterih_hist.ih__chr02
tcih__chr03characterih_hist.ih__chr03
tcih__chr04characterih_hist.ih__chr04
tcih__chr05characterih_hist.ih__chr05
tcih__chr06characterih_hist.ih__chr06
tcih__chr07characterih_hist.ih__chr07
tcih__chr08characterih_hist.ih__chr08
tcih__chr09characterih_hist.ih__chr09
tcih__chr10characterih_hist.ih__chr10
tdih__dec01decimalih_hist.ih__dec01
tdih__dec02decimalih_hist.ih__dec02
ttih__dte01dateih_hist.ih__dte01
ttih__dte02dateih_hist.ih__dte02
tlih__log01logicalih_hist.ih__log01
tdih__qad01decimalih_hist.ih__qad01
tdih__qad02decimalih_hist.ih__qad02
tdih__qad03decimalih_hist.ih__qad03
tiih__qad04integerih_hist.ih__qad04
tcih__qadc01characterih_hist.ih__qadc01QAD Field
tcih__qadc02characterih_hist.ih__qadc02QAD Field
tcih__qadc03characterih_hist.ih__qadc03QAD Field
tcih__qadc04characterih_hist.ih__qadc04QAD Field
tcih__qadc05characterih_hist.ih__qadc05QAD Field
tdih__qadd01decimalih_hist.ih__qadd01QAD Field
tdih__qadd02decimalih_hist.ih__qadd02QAD Field
tdih__qadd03decimalih_hist.ih__qadd03QAD Field
tiih__qadi01integerih_hist.ih__qadi01QAD Field
tiih__qadi02integerih_hist.ih__qadi02QAD Field
tiih__qadi03integerih_hist.ih__qadi03QAD Field
tlih__qadl01logicalih_hist.ih__qadl01QAD Field
tlih__qadl02logicalih_hist.ih__qadl02QAD Field
tlih__qadl03logicalih_hist.ih__qadl03QAD Field
ttih__qadt01dateih_hist.ih__qadt01QAD Field
ttih__qadt02dateih_hist.ih__qadt02QAD Field
ttih__qadt03dateih_hist.ih__qadt03QAD Field
tcih_ar_acctcharacterih_hist.ih_ar_acctAR Account
tcih_ar_cccharacterih_hist.ih_ar_ccCost Ctr
tcih_ar_subcharacterih_hist.ih_ar_subAR Sub-Account
tcih_bankcharacterih_hist.ih_bankBank
tcih_batchcharacterih_hist.ih_batchBatch
tcih_billcharacterih_hist.ih_billBill-To
tcih_bolcharacterih_hist.ih_bolBOL
tcih_ca_nbrcharacterih_hist.ih_ca_nbrCall
tiih_cartonsintegerih_hist.ih_cartonsCartons
tcih_channelcharacterih_hist.ih_channelChannel
tiih_cmtindxintegerih_hist.ih_cmtindxComment Index
ttih_cncl_datedateih_hist.ih_cncl_dateCancel Date
ttih_conf_datedateih_hist.ih_conf_dateConfirmed Date
tcih_conrepcharacterih_hist.ih_conrepNetting Logic
tcih_cr_cardcharacterih_hist.ih_cr_cardCredit Card
tcih_cr_initcharacterih_hist.ih_cr_initCr Initials
tcih_cr_termscharacterih_hist.ih_cr_termsCredit Terms
tlih_creditlogicalih_hist.ih_creditCredit
tcih_crprlistcharacterih_hist.ih_crprlistCredit Price List
tcih_currcharacterih_hist.ih_currCurrency
tcih_custcharacterih_hist.ih_custCustomer
tcih_cust_pocharacterih_hist.ih_cust_poEnd Customer PO
tlih_custref_vallogicalih_hist.ih_custref_valCustomer Ref Is Customer Item
tcih_daybookcharacterih_hist.ih_daybookDaybook
tcih_daybooksetcharacterih_hist.ih_daybooksetDaybook Set
tdih_disc_pctdecimalih_hist.ih_disc_pctDisc %
tcih_divcharacterih_hist.ih_divDivision
tcih_domaincharacterih_hist.ih_domainDomain
ttih_due_datedateih_hist.ih_due_dateDue Date
tdih_ent_exdecimalih_hist.ih_ent_exExch Rate
tdih_ex_ratedecimalih_hist.ih_ex_rateExch Rate
tdih_ex_rate2decimalih_hist.ih_ex_rate2Exch Rate 2
tcih_ex_ratetypecharacterih_hist.ih_ex_ratetypeRate Type
tiih_export_batchintegerih_hist.ih_export_batchBatch
ttih_export_datedateih_hist.ih_export_dateExport Date
tiih_export_timeintegerih_hist.ih_export_timeExport Time
tiih_exru_seqintegerih_hist.ih_exru_seqSequence
tcih_fcg_codecharacterih_hist.ih_fcg_codeCharge Code
tlih_fix_prlogicalih_hist.ih_fix_prFixed Price
tlih_fix_ratelogicalih_hist.ih_fix_rateFixed Rate
tcih_fobcharacterih_hist.ih_fobFOB Point
tcih_fr_listcharacterih_hist.ih_fr_listFreight List
tdih_fr_min_wtdecimalih_hist.ih_fr_min_wtFrt Min Wt
tcih_fr_termscharacterih_hist.ih_fr_termsFreight Terms
tcih_fsm_typecharacterih_hist.ih_fsm_typeFSM Type
tcih_fst_idcharacterih_hist.ih_fst_idFST ID
tcih_inv_crcharacterih_hist.ih_inv_crInvoice To Credit
ttih_inv_datedateih_hist.ih_inv_dateInvoice Date
tcih_inv_mthdcharacterih_hist.ih_inv_mthdInvoices Via
tcih_inv_nbrcharacterih_hist.ih_inv_nbrInvoice
tlih_invoicedlogicalih_hist.ih_invoicedInvoiced
tdih_invoicetotaldecimalih_hist.ih_invoicetotalTotal
tcih_invoicetypecharacterih_hist.ih_invoicetypeInvoice Type
tcih_langcharacterih_hist.ih_langLanguage
ttih_mod_datedateih_hist.ih_mod_dateModified Date
tcih_nbrcharacterih_hist.ih_nbrSales Order
ttih_ord_datedateih_hist.ih_ord_dateOrder Date
tlih_partiallogicalih_hist.ih_partialPartial OK
tcih_pocharacterih_hist.ih_poPurchase Order
tcih_pr_listcharacterih_hist.ih_pr_listPrice List
tcih_pr_list2characterih_hist.ih_pr_list2List Price List
tdih_prep_taxdecimalih_hist.ih_prep_taxPrepaid Tax
tdih_prepaiddecimalih_hist.ih_prepaidPrepaid Amount
ttih_priced_dtdateih_hist.ih_priced_dtLast Price Dt
ttih_pricing_dtdateih_hist.ih_pricing_dtPricing Date
tlih_primarylogicalih_hist.ih_primaryPrimary SO
tlih_print_bllogicalih_hist.ih_print_blPrint Bill of Lading
tlih_print_pllogicalih_hist.ih_print_plPrint Pack List
tlih_print_sologicalih_hist.ih_print_soPrint Sales Order
tcih_projectcharacterih_hist.ih_projectProject
tlih_pstlogicalih_hist.ih_pstPST
tcih_pst_idcharacterih_hist.ih_pst_idPST ID
tdih_pst_pctdecimalih_hist.ih_pst_pctPST Pct
tcih_quotecharacterih_hist.ih_quoteQuote
ttih_req_datedateih_hist.ih_req_dateRequired Date
tiih_revintegerih_hist.ih_revRevision
tcih_rmkscharacterih_hist.ih_rmksRemarks
tdih_rstk_pctdecimalih_hist.ih_rstk_pctRestocking Charge
tcih_sa_nbrcharacterih_hist.ih_sa_nbrContract
tcih_sch_mthdcharacterih_hist.ih_sch_mthdSchedules Via
tlih_schedlogicalih_hist.ih_schedScheduled
tlih_secondarylogicalih_hist.ih_secondarySecondary EMT Order
tcih_shipcharacterih_hist.ih_shipShip-To
ttih_ship_datedateih_hist.ih_ship_dateShip Date
tlih_ship_englogicalih_hist.ih_ship_engShip-To Engineer
tcih_ship_pocharacterih_hist.ih_ship_poShip To PO
tcih_shipviacharacterih_hist.ih_shipviaShip Via
tcih_sitecharacterih_hist.ih_siteSite
tdih_sizedecimalih_hist.ih_sizeSize
tcih_size_umcharacterih_hist.ih_size_umSize UM
tcih_sourcecharacterih_hist.ih_sourceOrder Source
tcih_statcharacterih_hist.ih_statAction Status
ttih_tax_datedateih_hist.ih_tax_dateTax Date
tcih_tax_envcharacterih_hist.ih_tax_envTax Environment
tcih_tax_usagecharacterih_hist.ih_tax_usageTax Usage
tlih_taxablelogicalih_hist.ih_taxableTaxable
tcih_taxccharacterih_hist.ih_taxcTax Class
tlih_to_invlogicalih_hist.ih_to_invReady to Invoice
tdih_trl_amtdecimalih_hist.ih_trl_amtRounding Trailer Amount
tdih_trl1_amtdecimalih_hist.ih_trl1_amtTrailer Amt 1
tcih_trl1_cdcharacterih_hist.ih_trl1_cdTrailer 1
tdih_trl2_amtdecimalih_hist.ih_trl2_amtTrailer Amt 2
tcih_trl2_cdcharacterih_hist.ih_trl2_cdTrailer 2
tdih_trl3_amtdecimalih_hist.ih_trl3_amtTrailer Amt 3
tcih_trl3_cdcharacterih_hist.ih_trl3_cdTrailer 3
tcih_typecharacterih_hist.ih_typeType
tcih_user1characterih_hist.ih_user1Ufld1
tcih_user2characterih_hist.ih_user2Ufld2
tcih_useridcharacterih_hist.ih_useridUser ID
tdih_weightdecimalih_hist.ih_weightWeight
tcih_weight_umcharacterih_hist.ih_weight_umWeight UM
tdoid_ih_histdecimalih_hist.oid_ih_hist
ih_histCustomcharactercalculatedcustom fields
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(ih_hist)


Internal usage


unused


Sample code: how to call this query through RPCRequestService (QXtend Inbound)

define temp-table ttContext no-undo
    field propertyQualifier as character
    field propertyName as character
    field propertyValue as character
    index entityContext is primary unique
        propertyQualifier
        propertyName
    index propertyQualifier
        propertyQualifier.

define dataset dsContext for ttContext.

define variable vhContextDS as handle no-undo.
define variable vhExceptionDS as handle no-undo.
define variable vhServer as handle no-undo.
define variable vhInputDS as handle no-undo.
define variable vhInputOutputDS as handle no-undo.
define variable vhOutputDS as handle no-undo.
define variable vhParameter as handle no-undo.

/* Create context */
create ttContext.
assign ttContext.propertyName = "programName"
       ttContext.propertyValue = "BMfgInvoiceHistory".
create ttContext.
assign ttContext.propertyName = "methodName"
       ttContext.propertyValue = "SelectMfgInvoiceHistory".
create ttContext.
assign ttContext.propertyName = "applicationId"
       ttContext.propertyValue = "fin".
create ttContext.
assign ttContext.propertyName = "entity"
       ttContext.propertyValue = "1000".
create ttContext.
assign ttContext.propertyName = "userName"
       ttContext.propertyValue = "mfg".
create ttContext.
assign ttContext.propertyName = "password"
       ttContext.propertyValue = "".

/* Create input dataset */
create dataset vhInputDS.
vhInputDS:read-xmlschema("file", "xml/bmfginvoicehistory.selectmfginvoicehistory.i.xsd", ?).
vhParameter = vhInputDS:get-buffer-handle("tParameterI").
vhParameter:buffer-create().

assign vhParameter::icRange = "A"
       vhParameter::icRowid = ""
       vhParameter::iiRownum = 0
       vhParameter::iiNumber = 5 /* Number of records to read */
       vhParameter::icSortColumns = ""
       vhParameter::ilCountOnly = false
       vhParameter::ilForwardRead = true
       vhParameter::iiMaximumBrowseRecordsToCount = 0.

vhParameter = vhInputDS:get-buffer-handle("tFilter").
vhParameter:buffer-create().

assign vhParameter::<field-name-1> = <field-value-1>
       vhParameter::<field-name-2> = <field-value-2>
       ...

/* Connect the AppServer */
create server vhServer.
vhServer:connect("-URL <appserver-url>").

if not vhServer:connected()
then do:
    message "Could not connect AppServer" view-as alert-box error title "Error".
    return.
end.

/* Run */
assign vhContextDS = dataset dsContext:handle.

run program/rpcrequestservice.p on vhServer
    (input-output dataset-handle vhContextDS by-reference,
           output dataset-handle vhExceptionDS,
     input        dataset-handle vhInputDS by-reference,
     input-output dataset-handle vhInputOutputDS by-reference,
           output dataset-handle vhOutputDS).

/* Handle output however you want, in this example, we dump it to xml */
if valid-handle(vhExceptionDS)
then vhExceptionDS:write-xml("file", "Exceptions.xml", true).

if valid-handle(vhOutputDS)
then vhOutputDS:write-xml("file", "Output.xml", true).

/* Cleanup */
vhServer:disconnect().
assign vhServer = ?.

if valid-handle(vhInputDS)
then delete object vhInputDS.

if valid-handle(vhOutputDS)
then delete object vhOutputDS.

if valid-handle(vhExceptionDS)
then delete object vhExceptionDS.