The REVUBEXML command allows you to soft code #variables as well as making the RUNUBEXML process more secure.
The REVUBEXML on non IBMi Series looks like
revubexml.exe |
|
/PATH= |
Location of the RUNUBEXML command. |
/USER= |
E1 User ID. |
/PWD= |
Password for value in /USER. |
/ENV= |
E1 Environment. |
/ROLE= |
E1 Role. |
/REPORT= |
E1 Report ID. |
/VERSION= |
E1 Report Version. |
/JOBQ= |
Job Queue. |
/HOLD= |
Hold on Job Queue. |
/CREATECSV= |
Create CSV file output. |
/PRINTER= |
Printer ID. |
/DATASELECT= |
Data Selection. |
/PROCESSOPTIONS= |
Processing Options. |
/DELETE= |
Delete .xml files. |
/JDECONNECT= |
DSN for E1 Database. |
/JDESCHEMA= |
E1 Schema name. |
/JDEHOST= |
E1 Host name. |
The REVUBEXML on IBMi Series looks like
REV RUNUBEXML (REVUBEXML) |
Type choices, press Enter. |
|
RUNUBEXML location . . . . . . . PATH |
Library of the RUNUBEXML command. |
User Name . . . . . . . . . . . USER |
E1 User ID. |
Password . . . . . . . . . . . . PWD |
Password for value in USER. |
Password File . . . . . . . . . PWDFILE |
Password file with USER & PWD. |
Library . . . . . . . . . . . |
|
Environment . . . . . . . . . . ENV |
E1 Environment. |
Role . . . . . . . . . . . . . . ROLE |
E1 Role. |
Report . . . . . . . . . . . . . REPORT |
E1 Report ID. |
Version . . . . . . . . . . . . VERSION |
E1 Report Version. |
Job Queue . . . . . . . . . . . JOBQ |
Job Queue. |
Hold . . . . . . . . . . . . . . HOLD |
Hold on Job Queue. |
Printer . . . . . . . . . . . . PRINTER |
Printer ID. |
Create CSV . . . . . . . . . . . CREATE_CSV |
Create CSV file output. |
Data Selection . . . . . . . . . DATA_SEL |
Data Selection. |
Processing Options . . . . . . . PROC_OPT |
Processing Options. |
Delete .xml files . . . . . . . DELETE |
Delete .xml files. |
SVM Library . . . . . . . . . . JDESCHEMA |
E1 library name. |
SVM Library local . . . . . . . SCHEMALCL |
Local Server or DRDA. |
Variables in RevSoft modules are identified by a # Prefix.
Defining some of the REVUBEXML arguments/keywords with User variables (#USR) makes updating the value quick and centralized:
/PATH=#USR_E1_INST_LOC\System\bin64
/USER=#USR_E1_USER
/JDESCHEDMA=#USR_SVM_DB_SCHEMA
will execute as:
/PATH=C:\JDEdwards\E920\System\bin64
/USER=RevSoft
/JDESCHEDMA=SVM920
Defining /PWD an Encrypted variable (#ENC) will NEVER expose the Password in Scripts and DB Tables:
/PWD=#ENC_E1_PWD
will execute as:
/PWD=<encrypted>
The Password is displayed in ALL of the .xml files so the REVUBEXML command has the /DELETE argument/keyword to delete all .xml files used in the process.
Date variables can be passed in the Data Selection (/DATASELECT):
/DATASELECT="UPMJ,LT,#DATPSCH"
Where #DATPSCH is defined as Today less 4 months in CCYYMMDD Format.
When executed on 4th May 2022 would look like:
/DATASELECT="UPMJ,LT,20220104"
User variables can also be used in the Processing Options:
/PROCESSOPTIONS="nDaysOld,#USR_PWSJ;szServerDataSource,"
Where #USR_PWSJ is defined as 90.
When executed this would look like:
/PROCESSOPTIONS="nDaysOld,90;szServerDataSource,"
When the REVUBEXML command is executed REV SCH stores the E1 execution value in #OW variables that can be used:
Value |
Variable Name |
Length |
|
Description |
20220503 |
#OWACDT |
8 |
|
JDE Last Date. |
71551 |
#OWACTM |
6 |
|
JDE Last Time. |
VBQCLOUD |
#OWEHST |
40 |
|
JDE Exe Host. |
JDV920 |
#OWENHV |
10 |
|
JDE Environment. |
R09801_ZJDE0001 |
#OWFUF2 |
30 |
|
JDE Future Use 2. |
UBE |
#OWFUNO |
4 |
|
JDE Object Type. |
01JDEDBENWB |
#OWFUS1 |
30 |
|
JDE Future Use 1. |
11888 |
#OWJOBN |
15 |
|
JDE Job Number. |
01 |
#OWJTYP |
2 |
|
JDE Job Type. |
01JDEDBENWB |
#OWOHST |
40 |
|
JDE Origin Host. |
16560 |
#OWPROC |
15 |
|
JDE Process ID. |
6017 |
#OWPRTQ |
10 |
|
JDE Print Queue. |
5 |
#OWPTY |
2 |
|
JDE Priority. |
QBATCH |
#OWQUE |
10 |
|
JDE Job Queue. |
R09801 |
#OWREPT |
20 |
|
JDE Report Name. |
20220503 |
#OWSBDT |
8 |
|
JDE Submit Date. |
71549 |
#OWSBTM |
6 |
|
JDE Submit Time. |
REVSOFT |
#OWUSER |
10 |
|
JDE User. |
ZJDE0001 |
#OWVERS |
20 |
|
JDE Version Name. |
As an example we can access the .pdf created by using the variables:
/PDF=#USR_PRINT_QUEUE\PrintQueue\#OWFUF2_#OWJOBN_PDF.pdf
, Or
/PDF=#USR_PRINT_QUEUE\PrintQueue\#OWREPT_#OWVERS_#OWJOBN_PDF.pdf
Would be translated and execute as:
/PDF=C:\JDEdwards\E920\PrintQueue\R09801_ZJDE0001_11888_PDF.pdf
The UBE .pdf can be sent as an attachment to an email.
Using the RJCHKPDF command you can search for strings on the UBE .pdf. e.g. After the GLPOST (R09801) search for 'One or more batches had errors'.
Using RJRTVPDF you can retrieve strings/data from the UBE .pdf.
Script Definition |
⟶ |
Script Execution |
revubexml.exe |
|
revubexml.exe |
/PATH="#USR_E1_INST_LOC\System\bin64" |
|
/PATH="C:\JDEdwards\E920\System\bin64" |
/USER=Revsoft |
|
/USER=Revsoft |
/PWD=#ENCREVSOFT_PWD |
|
/PWD=<encrypted> |
/ENV=#USR_ENV |
|
/ENV=DV920 |
/ROLE=*ALL |
|
/ROLE=*ALL |
/REPORT=R0006P |
|
/REPORT=R0006P |
/VERSION=XJDE0001 |
|
/VERSION=XJDE0001 |
/JOBQ=QSINGLE |
|
/JOBQ=QSINGLE |
/HOLD=H |
|
/HOLD=H |
/CREATECSV=N |
|
/CREATECSV=N |
/PRINTER= |
|
/PRINTER= |
/DATASELECT= |
|
/DATASELECT= |
/PROCESSOPTIONS= |
|
/PROCESSOPTIONS= |
/DELETE=N |
|
/DELETE=N |
/JDECONNECT=#USR_DBE1 |
|
/JDECONNECT=E1DB01 |
/JDESCHEMA=#USR_SVM_DB_SCHEMA |
|
/JDESCHEMA=SVM920 |
/JDEHOST= |
|
/JDEHOST= |
|