Information Systems:EODREBLD - Revision history

Norwinu at 23:18, 24 November 2016

2016-11-24T23:18:42Z

Norwinu at 23:18, 24 November 2016

2016-11-24T23:18:07Z

Norwinu at 17:24, 20 July 2016

2016-07-20T17:24:21Z

New page

This rebuilds/updates master and statistic files used by Web Orders and InfoNet. These are built as part of the overnight processing instead of when a user requests the information. This also clears work files and spool files. It is submitted to QBATCH by [[EOD]], to run after the restricted state has ended; about 5:00AM.

/* clear files and folders for Web Orders */
/* there are some Unix commands run in Qshell that sometimes fail, so */
/* submit it to batch. If it doesn't complete, it won't affect the end */
/* of day - but the image and specification in Web Orders may not be */
/* correct. */

/* log entry is 'WSOVERNIT1' */

SBMJOB CMD(CALL PGM([[WSOVERNIT1]])) JOBQ(QS36EVOKE)

/* Build consolidated item master file (XXITEMP). This must run before */
/* Web Order files are rebuilt. */

/* log entry is 'XXITEMP' */

CALL PGM(ITEMINFOCA)

/* rebuild files for Web Orders */

/* log entry is 'WSOVERNIT2' */

CALL PGM([[WSOVERNIT2]])

/* Run End of Day housekeeping. */

/* log entry is 'EODCLR' */

CALL PGM([[EODCLR]])

/* Build summary file of lost sales */
/* (ITEMSTAT uses this file, so this has to run first) */

/* log entry is 'SUMVENLST' */

CLRPFM FILE(SUMVENLST)
CALL PGM(BLDSUMLST)

/* Rebuild item statistics file (XXSTATSP) */

/* log entry is 'XXSTATSP' */

CLRPFM FILE(XXSTATSP)
CALL PGM(ITEMSTAT)

/* Rebuild promo results files (for InfoNet) */

/* log entry is 'PXRESBUILD' */

CALL PGM(PXRESBUILD)

/* Build summary file of sales (including brand) by customer */
/* (for IN_CUSTSLS) */

/* log entry is 'BLDCSTSL2' */

CALL PGM(BLDCSTSL2) PARM(' ')

/* Build summary file of freight vs sales (current and previous month) */

/* log entry is 'BLDSUMFRT' */

CALL PGM(BLDSUMFRT) PARM(' ')
CALL PGM(BLDSUMFRTP)

/* Build summary file to validate Analyser */

/* log entry is 'BLDANAWRK' */

CALL PGM(BLDANAWRK)

/* Search for duplicate keys in ANOSTK */

RUNQRY QRY(ANOSTKCNT1) QRYFILE((*LIBL/ANOSTK))
RUNQRY QRY(ANOSTKCNT2) QRYFILE((*LIBL/ANOCOUNT))

/* Build file of sales order pattern - sales by the hour */

/* log entry is 'BLDORDLIN' */

CALL PGM(BLDORDLIN) PARM(' ')

/* Build file of sales order statistics by day */

/* log entry is 'BLDDAYLINF' */

CALL PGM(BLDDAYLINF)

/* Build file of PO fill rates */

/* log entry is 'BLDPOFRT' */

CALL PGM(BLDPOFRT) PARM(' ')

/* Build file of sales and budget by item account group */

/* log entry is 'BLDSLSBUD' */

CALL PGM(BLDSLSBUD) PARM(' ')

/* Build summary file of lost sales by warehouse */

/* log entry is 'SUMWHSLST' */

CLRPFM FILE(SUMWHSLST)
CALL PGM(BLDWHSLST)

/* Build file of VEBA by province by day */

/* log entry is 'BLDVEBA' */

CALL PGM(BLDVEBA) PARM(' ')

/* send email that rebuild is complete */

CHGVAR VAR(&SMSG) VALUE('Statistics files rebuild +
is complete')
CHGVAR VAR(&LMSG) VALUE(&SMSG)
CALL PGM(OPMSGSEND) PARM(&SMSG &LMSG)

[[Category:Overnight Processing]]

Sheilav at 21:04, 18 March 2016

2016-03-18T21:04:52Z

Sheilav at 17:43, 9 February 2016

2016-02-09T17:43:00Z

Sheilav at 17:41, 9 February 2016

2016-02-09T17:41:43Z

Sheilav at 17:38, 9 February 2016

2016-02-09T17:38:53Z

Sheilav at 00:14, 5 February 2016

2016-02-05T00:14:50Z

Sheilav: Created page with " /* clear files and folders for Web Orders / / there are some Unix commands run in Qshell that sometimes fail, so / / submit it to ba..."

2016-02-05T00:13:54Z

Created page with " clear files and folders for Web Orders: there are some Unix commands run in Qshell that sometimes fail, so: /* submit it to ba..."

New page

/* clear files and folders for Web Orders */
/* there are some Unix commands run in Qshell that sometimes fail, so */
/* submit it to batch and wait for it to complete. If it doesn't, it */
/* won't affect the end of day - but the image and specification in Web */
/* Orders may not be correct. */

SBMJOB CMD(CALL PGM(WSOVERNIT1)) JOBQ(QS36EVOKE)
DLYJOB DLY(420)

/* Build consolidated item master file (XXITEMP). This must run before */
/* Web Order files are rebuilt. */

CALL PGM(ITEMINFOCA)

/* rebuild files for Web Orders */

CALL PGM([[Overnight ENDOFDAY#WSOVERNIT2|WSOVERNIT2]])

/* Run End of Day housekeeping. */

CALL PGM(EODCLR)

/* Build summary file of lost sales */
/* (ITEMSTAT uses this file, so this has to run first) */

CLRPFM FILE(SUMVENLST)
CALL PGM(BLDSUMLST)

/* Rebuild item statistics file (XXSTATSP) */

CLRPFM FILE(XXSTATSP)
CALL PGM(ITEMSTAT)

/* Rebuild promo results files (for InfoNet) */

CALL PGM(PXRESBUILD)

/* Build summary file of sales (including brand) by customer */
/* (for IN_CUSTSLS) */

CALL PGM(BLDCSTSL2) PARM(' ')

/* Build summary file of freight vs sales (current and previous month) */

CALL PGM(BLDSUMFRT) PARM(' ')
CALL PGM(BLDSUMFRTP)

/* Build summary file to validate Analyser */

CALL PGM(BLDANAWRK)

/* Search for duplicate keys in ANOSTK */

RUNQRY QRY(ANOSTKCNT1) QRYFILE((*LIBL/ANOSTK))
RUNQRY QRY(ANOSTKCNT2) QRYFILE((*LIBL/ANOCOUNT))

/* Build file of sales order pattern - sales by the hour */

CALL PGM(BLDORDLIN) PARM(' ')

/* Build file of sales order statistics by day */

CALL PGM(BLDDAYLINF)

/* Build file of PO fill rates */

CALL PGM(BLDPOFRT) PARM(' ')

/* Build file of sales and budget by item account group */

CALL PGM(BLDSLSBUD) PARM(' ')

/* Build summary file of lost sales by warehouse */

CLRPFM FILE(SUMWHSLST)
CALL PGM(BLDWHSLST)

/* Build file of VEBA by province by day */

CALL PGM(BLDVEBA) PARM(' ')

/* send email that rebuild is complete */

CHGVAR VAR(&SMSG) VALUE('Statistics files rebuild +
is complete')
CHGVAR VAR(&LMSG) VALUE(&SMSG)
CALL PGM(OPMSGSEND) PARM(&SMSG &LMSG)

@@ Line 112: / Line 112: @@
              CALL       PGM(BLDVEBA) PARM('        ')
  /* Print EDI supplier invoices (EIN) by calling same program as from     */
  /* menu option 9 in EDI menu                                             */
  /* log entry is 'EINPRINT'                                               */
              CALL       PGM(EDINVSUPC)
  /* send email that rebuild is complete                                   */

← Older revision		Revision as of 23:18, 24 November 2016
Line 112:		Line 112:

	CALL PGM(BLDVEBA) PARM(' ')		CALL PGM(BLDVEBA) PARM(' ')
		+
⚫
		+	/* Print EDI supplier invoices (EIN) by calling same program as from */
		+	/* menu option 9 in EDI menu */
		+
		+	/* log entry is 'EINPRINT' */
		+
		⚫	CALL PGM(EDINVSUPC)
		+
	/* send email that rebuild is complete */		/* send email that rebuild is complete */

@@ Line 6: / Line 6: @@
  /* of day - but the image and specification in Web Orders may not be     */
  /* correct.                                                              */
              SBMJOB     CMD(CALL PGM([[WSOVERNIT1]])) JOBQ(QS36EVOKE)
@@ Line 11: / Line 13: @@
  /* Build consolidated item master file (XXITEMP).  This must run before */
  /* Web Order files are rebuilt.                                         */
              CALL       PGM(ITEMINFOCA)
  /* rebuild files for Web Orders                                         */
              CALL       PGM([[WSOVERNIT2]])
  /* Run End of Day housekeeping.                                         */
              CALL       PGM([[EODCLR]])
@@ Line 24: / Line 32: @@
  /* Build summary file of lost sales                                      */
  /* (ITEMSTAT uses this file, so this has to run first)                   */
              CLRPFM     FILE(SUMVENLST)
@@ Line 29: / Line 39: @@
  /* Rebuild item statistics file (XXSTATSP)                               */
              CLRPFM     FILE(XXSTATSP)
@@ Line 34: / Line 46: @@
  /* Rebuild promo results files (for InfoNet)                             */
              CALL       PGM(PXRESBUILD)
@@ Line 39: / Line 53: @@
  /* Build summary file of sales (including brand) by customer             */
  /* (for IN_CUSTSLS)                                                      */
              CALL       PGM(BLDCSTSL2) PARM('      ')
  /* Build summary file of freight vs sales (current and previous month)   */
              CALL       PGM(BLDSUMFRT) PARM('      ')
@@ Line 48: / Line 66: @@
  /* Build summary file to validate Analyser                               */
              CALL       PGM(BLDANAWRK)
@@ Line 57: / Line 77: @@
  /* Build file of sales order pattern - sales by the hour                 */
              CALL       PGM(BLDORDLIN) PARM('        ')
  /* Build file of sales order statistics by day                           */
              CALL       PGM(BLDDAYLINF)
  /* Build file of PO fill rates                                           */
              CALL       PGM(BLDPOFRT) PARM('        ')
  /* Build file of sales and budget by item account group                  */
              CALL       PGM(BLDSLSBUD) PARM('      ')
  /* Build summary file of lost sales by warehouse                         */
              CLRPFM     FILE(SUMWHSLST)
@@ Line 78: / Line 108: @@
  /* Build file of VEBA by province by day                                 */
              CALL       PGM(BLDVEBA) PARM('        ')

@@ Line 3: / Line 3: @@
  /* clear files and folders for Web Orders                                */
  /* there are some Unix commands run in Qshell that sometimes fail, so    */
- /* submit it to batch and wait for it to complete.  If it doesn't, it    */
+ /* submit it to batch.  If it doesn't complete, it won't affect the end  */
- /* won't affect the end of day - but the image and specification in Web  */
+ /* of day - but the image and specification in Web Orders may not be     */
- /* Orders may not be correct.                                            */
+ /* correct.                                                              */
              SBMJOB     CMD(CALL PGM([[WSOVERNIT1]])) JOBQ(QS36EVOKE)

← Older revision		Revision as of 17:41, 9 February 2016
Line 8:		Line 8:

	SBMJOB CMD(CALL PGM([[WSOVERNIT1]])) JOBQ(QS36EVOKE)		SBMJOB CMD(CALL PGM([[WSOVERNIT1]])) JOBQ(QS36EVOKE)
−	DLYJOB DLY(420)

	/* Build consolidated item master file (XXITEMP). This must run before */		/* Build consolidated item master file (XXITEMP). This must run before */

← Older revision		Revision as of 17:38, 9 February 2016
Line 1:		Line 1:
		+	This rebuilds/updates master and statistic files used by Web Orders and InfoNet. These are built as part of the overnight processing instead of when a user requests the information. This also clears work files and spool files. It is submitted to QBATCH by [[EOD]], to run after the restricted state has ended; about 5:00AM.
		+
	/* clear files and folders for Web Orders */		/* clear files and folders for Web Orders */
	/* there are some Unix commands run in Qshell that sometimes fail, so */		/* there are some Unix commands run in Qshell that sometimes fail, so */

Information Systems:EODREBLD - Revision history

Norwinu at 23:18, 24 November 2016

Norwinu at 23:18, 24 November 2016

Norwinu at 17:24, 20 July 2016

Sheilav at 21:04, 18 March 2016

Sheilav at 17:43, 9 February 2016

Sheilav at 17:41, 9 February 2016

Sheilav at 17:38, 9 February 2016

Sheilav at 00:14, 5 February 2016

Sheilav: Created page with " /* clear files and folders for Web Orders */ /* there are some Unix commands run in Qshell that sometimes fail, so */ /* submit it to ba..."

Sheilav: Created page with " /* clear files and folders for Web Orders / / there are some Unix commands run in Qshell that sometimes fail, so / / submit it to ba..."