Use the following filenames for the appropriate viewį9865_TEMP1 => JDE_formcode2applicationcode.txtį9860_TEMP1 => JDE_applicationcode2applicationname.txtį983051_TEMP => JDE_applicationversioncode2applicationversiondescription.txtį9203_TEMP => JDE_errorcode2errordescription.txtį0005_TEMP => JDE_applicationcode2productname.txtį0005_F9860_TEMP => JDE_applicationcode2productcode.txtį9860_TEMP2 => JDE_productcode2productname.txtĬhange the String delimiter and choose None and change the Column delimiter and choose None.Ĭonvert all the files from EBCIDIC to UTF-8. Right click on the view name and select Data\Export from the popup menu Use the export wizard to save the data to a file, accepting default options except for the following: Make sure that the SQL has run successfully before proceeding with the rest of this procedure.Įxport the views to a file. Please make sure you replace the schema in the SQL with appropriate schema/library name on your DB2400 install. Make sure you provide the proper schema name before running the above SQL. In the example above, the schema is named as OL910, PRODCTL, DD910, DV910 etc. TRIM(appt.SIOBNM),TRIM(appt.SISY) FROM OL910.F9860 appt WHERE appt.SIOBNM Like 'P%' AND appt.SISY NOT LIKE '%55%' AND appt.SISY NOT LIKE '%87%' ANDĪppt.SISY NOT LIKE '%88%' AND appt.SISY NOT LIKE '%89%' AND appt.SISY NOTĬREATE VIEW OL910.F9860_TEMP2 (SIOBNM,SISY) AS SELECT TRIM(pct.DRKY)=TRIM(appt.SISY) ) FROM OL910.F9860 appt WHERE appt.SIOBNM 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 |