pears.SoftNetAssignmentDatasheet

CREATE PROCEDURE "pears"."SoftNetAssignmentDatasheet"( IN "pWebUserID" CHAR(20),IN "pLineID" CHAR(20) ) 
RESULT( "RowTitle" CHAR(255),"RowContent" CHAR(500),"SortOrder" CHAR(2) ) 
// IQXWeb
BEGIN
  DECLARE "HealthSafetyExtraText" CHAR(500);
  DECLARE "ExpensesPayableExtraText" CHAR(200);
  DECLARE "HoursOfWorkExtraText" CHAR(100);
  DECLARE "ConfirmRateExtraText" CHAR(100);
  DECLARE "BranchContactDetails" CHAR(255);
  DECLARE "PayNote" CHAR(500);
  DECLARE LOCAL TEMPORARY TABLE "DSet"(
    "Column1" CHAR(500) NULL,
    "Column2" CHAR(500) NULL,
    "Column3" CHAR(500) NULL,
    "Column4" CHAR(500) NULL,
    "Column5" CHAR(500) NULL,
    "Column6" CHAR(500) NULL,
    "Column7" CHAR(500) NULL,
    "Column8" CHAR(500) NULL,
    "Column9" CHAR(500) NULL,
    "Column10" CHAR(500) NULL,
    "Column11" CHAR(500) NULL,
    "Column12" CHAR(500) NULL,
    "Column13" CHAR(500) NULL,
    "Column14" CHAR(500) NULL,
    "Column15" CHAR(500) NULL,
    "Column16" CHAR(500) NULL,
    "Column17" CHAR(500) NULL,
    "Column18" CHAR(500) NULL,
    "Column19" CHAR(500) NULL,
    "Column20" CHAR(500) NULL,
    "Column21" CHAR(500) NULL,
    "Column22" CHAR(500) NULL,
    "Column23" CHAR(500) NULL,
    ) NOT transactional;
  // INSERT logic here
  SELECT 'No value' AS "RowTitle",'No Data','A' AS "OrdCol" ORDER BY "OrdCol" ASC
END /* DOC
2018-11-06 PC IW-619 Standardise assignment datasheet: Copy and Customised logic into this routine, and issue it if customisation is required otherwise do not issue it, to allow logic to fall through on master routine
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."SoftNetAssignmentDatasheet" IS 
{CREATE PROCEDURE pears."SoftNetAssignmentDatasheet"( IN "pWebUserID" CHAR(20),IN "pLineID" CHAR(20) )
RESULT(RowTitle CHAR(255),RowContent CHAR(500),SortOrder CHAR(2))
// IQXWeb
BEGIN
 
DECLARE "HealthSafetyExtraText" CHAR(500);
DECLARE "ExpensesPayableExtraText" CHAR(200);
DECLARE "HoursOfWorkExtraText" CHAR(100);
DECLARE "ConfirmRateExtraText" CHAR(100);
DECLARE BranchContactDetails CHAR(255);
DECLARE PayNote CHAR(500);
DECLARE LOCAL TEMPORARY TABLE DSet (
Column1 CHAR(500) NULL,
Column2 CHAR(500) NULL,
Column3 CHAR(500) NULL,
Column4 CHAR(500) NULL,
Column5 CHAR(500) NULL,
Column6 CHAR(500) NULL,
Column7 CHAR(500) NULL,
Column8 CHAR(500) NULL,
Column9 CHAR(500) NULL,
Column10 CHAR(500) NULL,
Column11 CHAR(500) NULL,
Column12 CHAR(500) NULL,
Column13 CHAR(500) NULL,
Column14 CHAR(500) NULL,
Column15 CHAR(500) NULL,
Column16 CHAR(500) NULL,
Column17 CHAR(500) NULL,
Column18 CHAR(500) NULL,
Column19 CHAR(500) NULL,
Column20 CHAR(500) NULL,
Column21 CHAR(500) NULL,
Column22 CHAR(500) NULL,
Column23 CHAR(500) NULL
) NOT transactional; 
 
// INSERT logic here
 
SELECT 'No value' AS RowTitle,'No Data','A' AS OrdCol ORDER BY OrdCol ASC
 
END
 
/* DOC
2018-11-06 PC IW-619 Standardise assignment datasheet: Copy and Customised logic into this routine, and issue it if customisation is required otherwise do not issue it, to allow logic to fall through on master routine
*/
}