20230206

//テーブル関数内に作成：検証関数

void chkdata()
{
//_BK
strSql = "create " + repTN + "_BK as select * from " + repTN;
//dt = dbQ(strSql);

minus()
{
strSql =
"select * from " + repTN + "_BK " +
"minus select * from " + repTN;
//dt = dbQ(strSql);
}

//x→R_XXX
cmnfunc();

minus()
{
strSql =
"select * from " + repTN + "_BK " +
"minus select * from " + repTN;
//dt = dbQ(strSql);
}

//R_XXX→R_XXX_BK update
xbbTN = repTN;//BKを更新
repTN = repTN + "_BK";
cmnfunc_BK();

console.writelines(strSql);

}
// --------------------------------

DelIns()
{
strSql =
"delete * from " + repTN;
//dt = dbQ(strSql);

Thread.Sleep(TimeSpan.FromSeconds(15));//15sec sleep

strSql =
"insert into " + repTN +
"select * from " + xbbTN;
//dt = dbQ(strSql);

}