ENGINE SQLMSS SET DEFAULT_CONNECTION <SQL Adapter>
SQL SQLMSS PREPARE SQLOUT FOR

SELECT *
FROM <TABLE NAME>

END

TABLE FILE SQLOUT
PRINT *
END

Hallway

 

Prod: 8202M1

Test: 8202M4

Repository:

 

OS:

 

Outputs:

 

 

 

 

  
ENGINE SQLSYB SET DEFAULT_CONNECTION REPORTING

SQL SQLSYB
EX hr..ServiceAwardsWF;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS SQLOUT
END
JOIN
GETALLEMPIDANDSSN.ANSWERSET1.SSN IN GETALLEMPIDANDSSN TO MULTIPLE
SQLOUT.SQLOUT.socialSecurityNumber IN SQLOUT TAG J0 AS J0
END
TABLE FILE GETALLEMPIDANDSSN
PRINT
     GETALLEMPIDANDSSN.ANSWERSET1.EMPLOYID AS 'Emp ID'
     J0.SQLOUT.employeeName AS 'Employee Name'
     J0.SQLOUT.employeeStatus AS 'Status'
     J0.SQLOUT.hireDate/HMDYY AS 'Hire Date'
     J0.SQLOUT.yearsOfService AS 'Service Years'
     J0.SQLOUT.homeAddress AS 'Home Address'
     J0.SQLOUT.homeCity AS 'Home City'
     J0.SQLOUT.homeState AS 'Home State'
     J0.SQLOUT.homeZip AS 'Home Zip'
     J0.SQLOUT.driverNumber AS 'Driver #'
     J0.SQLOUT.fleetId AS 'Fleet #'
     J0.SQLOUT.department AS 'Department'
     J0.SQLOUT.opsManager AS 'Ops Manager'
     J0.SQLOUT.daysInactive AS 'Days Inactive Last 5 yrs'
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = enblue_theme,
$
     TITLETEXT='Service Awards',
$
TYPE=REPORT,
     COLUMN=N1,
     SQUEEZE=0.638889,
$
TYPE=REPORT,
     COLUMN=N2,
     SQUEEZE=2.250000,
$
TYPE=REPORT,
     COLUMN=N6,
     SQUEEZE=1.930556,
$
TYPE=REPORT,
     COLUMN=N7,
     SQUEEZE=1.402778,
$
TYPE=REPORT,
     COLUMN=N9,
     SQUEEZE=0.680556,
$
TYPE=REPORT,
     COLUMN=N12,
     SQUEEZE=0.416667,
$
TYPE=REPORT,
     COLUMN=N13,
     SQUEEZE=1.930556,
$
TYPE=REPORT,
     COLUMN=N14,
     SQUEEZE=2.305556,
$
ENDSTYLE
END

-MRNOEDIT BEGIN
SQL SQLSYB
EX hr..ServiceAwardsWF;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS RPTDATA_SQL
END
-MRNOEDIT END
-RUN
? HOLD RPTDATA_SQL
-EXIT