Pct.DRRT LIKE 'SY' AND pct.DRKY NOT LIKE ' %' AND (SELECT pct.DRDL01 FROM PRODCTL.F0005 pct WHERE pct.DRSY like '98 ' AND Pct.DRDL01 FROM PRODCTL.F0005 pct WHERE pct.DRSY like '98 ' AND pct.DRRTĬREATE VIEW PRODCTL.F0005_F9860_TEMP (OBNM,DRDL01) AS SELECT appt.SIOBNM , TRIM(a.FRDTAI),a.FRDSCA FROM DD910.F9203 a ĬREATE VIEW PRODCTL.F0005_TEMP (DRKY,DRDL01) AS SELECT TRIM(pct.DRKY) , TRIM(a.SWFMNM),a.SWOBNM FROM OL910.F9865 a ĬREATE VIEW OL910.F9865_TEMP2 (SWFMNM,SWMD) AS SELECT TRIM(a.SWFMNM),a.SWMDĬREATE VIEW OL910.F9860_TEMP1 (SIOBNM,SIMD) AS SELECT TRIM(a.SIOBNM),a.SIMDĬREATE VIEW DV910.F983051_TEMP (VRPID_VRVERS,VRJD) AS SELECT TRIM(a.VRPID) || Select the appropriate Databases\schema branch inside iSeries Navigator.Ĭreate temporary views to export the data.Ĭlick Run a SQL Script in iSeries NaviagatorĬREATE VIEW OL910.F9865_TEMP1 (SWFMNM,SWOBNM) AS SELECT This requires System I Navigator (iseries Navigator for windows). This is because the script tries to detect the correct schema for the various tables used.įollow the procedure described in Section 10.1.2, "Uploading Configuration Files" to upload the generated files to the Reporter System.Īn alternative to running the create_JDE_info.sh script is to create the info files manually. Note the connect string must authenticate as "sys as sysdba" to your database. The script reads from the schemas, and generates. ![]() ![]() Where connect-string is the string used to authorize the script to access the JD Edwards database. The create_JDE_info.sh script must be run with the following required parameter: Foot 1 This script assigns an identification to the identified page IDs within the environment. Run the create_JDE_info.sh script as any user on the JD Edwards server. It is located in the /var/opt/ruei/processor/local/download/JDE directory of the RUEI system. In order for RUEI to correctly translate the JD Edwards business logic within your environment, do the following:Ĭopy the create_JDE_info.sh script to the home directory of the JD Edwards server. O.4 Running the create_JDE_info.sh Script
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |