Included page: .FrontPage.QA.BalanceDue.2020.QA.SetUp (edit)

import

TBOT.Generic.Database

variable defined: ENV=QA
variable defined: QA=http://10.184.7.166:9510/
variable defined: SAT=http://10.184.73.99:9510/
variable defined: URL=http://10.184.7.166:9510/

ddt: SetUp
key	value
ConnectionString	Server=10.153.120.216,1600;database=AUTOTESTING;User Id=automation; password=automation*100; Timeout=30
BytesColumn	DataObject
FileExtension	ZIP
ExpectedDirectory	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2020\BatchAutomation\BalanceDue
DownloadPath	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2020\BatchAutomation\BalanceDue\Actuals
SourceDirectory	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2020\BatchAutomation\BalanceDue\Actuals
TargetDirectory	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\D_Drive\Trustez\ftp\LocalUser\EFTPS\qa\in
CompareResultDir	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2020\BatchAutomation\BalanceDue
ExpectedDir	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\IntegrationTests-OTT\BaselineFiles\Baseline\files\QA\YrSpecSuites\2020\BatchAutomation\BalanceDue
ActualDir	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Actuals\QA\YrSpecSuites\2020\BatchAutomation\BalanceDue\Actuals
ResultDir	\\EC2AMAZ-2GFJSTU.a648727226388.amazonaws.com\TZAPPS01SS-QA\AutomationQA\_QATeam\FitnesseTestArtifacts\files\Results\QA\YrSpecSuites\2020\BatchAutomation\BalanceDue
Debug	TRUE
ignorePathValidations	false
DeleteFile	true

Execute BTMDB..Package

ddt: DynamicQuery	SELECT LTRIM(RTRIM(DB_NAME)) AS DB_NAME , LTRIM(RTRIM(Server)) as Server, AcctNo,'{{TaxYear}}' AS Tax_Year, '{{SeqNumber}}' as Seq_Number from BTMDB..Package where AcctNo='{{PAN}}'
Comments#	PAN	TaxYear	SeqNumber	DB_NAME?	Server?	AcctNo?	Tax_Year?	Seq_Number?
Test0001	5010	2020	1	$DBName1=	$Server1=	$AcctNo1=	$Tax_Year1=	$Seq_Number1=

Execute OPERATIONSDB_P.QueueProcess

ddt: DynamicQuery	WAITFOR DELAY '00:00:10'; exec OPERATIONSDB.OPERATIONSDB_P.QueueProcess @key_field='{{PAN}}X',@Trust_Key=0,@Product_Code='X',@ProdOpt=0,@Seq_Yr=2021, @que_name='TEZIN-FST',@process_code=700,@param_str='$ACCT={{PAN}}$INI=PN1$REFILE=Y$SEQNO=0$TEST=N$A=PRD',@locator='000000',@PermSeq=0, @Mode='PRD',@DB_Name='{{DataBaseName}}',@ServerID='{{ServerName}}'
Comments#	PAN	TaxYear	DataBaseName	SeqNumber	ServerName
Test0001	$AcctNo1	$Tax_Year1	$DBName1	$Seq_Number1	$Server1