magritton
1/8/2015 - 2:49 PM

Cyberquery APT example of calling the APT process from a macro

Cyberquery APT example of calling the APT process from a macro

CQ APT Macro
content_copyfile_download
/*
  File:         FCG_AR_Data_Extract_Access
  Create Date:  1/7/2014
  Created By:   MAG
  Purpose:      
  Modified:
*/
run TimeDataStart
run FCG_AR_Credit_Limits.eq
rreplace FCG_AR_Credit_Limits.cqe
cli copy FCG_AR_Credit_Limits.cq \\opwsql03\ssisdatadump2\FCG_AR_Credit_Limits.txt

run FCG_AR_Applied_Payments.eq
rreplace FCG_AR_Applied_Payments.cqe
cli copy FCG_AR_Applied_Payments.cq \\opwsql03\ssisdatadump2\FCG_AR_Applied_Payments.txt

run FCG_AR_Last_Payment.eq
rreplace FCG_AR_Last_Payment.cqe
cli copy FCG_AR_Last_Payment.cq \\opwsql03\ssisdatadump2\FCG_AR_Last_Payment.txt

run FCG_AR_Payment_Listing.eq
rreplace FCG_AR_Payment_Listing.cqe
cli copy FCG_AR_Payment_Listing.cq \\opwsql03\ssisdatadump2\FCG_AR_Payment_Listing.txt
run TimeDataEnd

cli echo FCG_AR_Data_Extract_Access > OPWAPTDataWriteP.par
run OPWAPTDataWriteControl.mf