The following document explains how complex indexing works in map editor
The input file is an XML IDoc file and we want to group all LOT_NUMBER fields together along with the quantity accumulated per Lot Number. The only way to do this is using indexing within the Extended Rules as shown below. Continue reading
This paper will discuss SQL (ODBC) maps and outline general information necessary to complete a SQL map. The paper will also cover the flow of the translator for outbound SQL (ODBC) Maps and how to use the components available with the SQL File Format to design a map to process the result set returned via the SQL statement defined in the map. Continue reading
Storing values into process data can be really useful. However, when you “update” process data, it is an update TO process data. It is not an update OF process data. If you have multiple updates, it will create multiple entries. Multiple updates will NOT overwrite the value in process data. Continue reading
Uppercase and Lowercase in mapping
#stringField = new("java.lang.String",#stringField).toUpperCase();
#stringField = new("java.lang.String",#stringField).toLowerCase();
Date Difference in map extended rule
object date1;
object date2;
date1=new("java.util.GregorianCalendar");
date2=new("java.util.GregorianCalendar");
date1.set(2008,08,01);
date2.set(2008,09,31);
#Number_of_days = (date2.getTimeInMillis() - date1.getTimeInMillis()) / 86400000;
Using Replace Function
object obj;
if len(#0166:19) > 0 then
begin
obj = new ("java.lang.String",#0166:19);
#0166:19 = obj.replace("*","");
end
X-path interaction
String[20] BPID; SELECT XPATHRESULT INTO BPID FROM PROCESSDATA WHERE XPATH="/ProcessData/SIFramework/SFG/WorkflowId/text()";
Customised java class calling from ER
Object xref;
xref = new("com.CVAM.utility.CVAMUserExits");
xref.method(parameter1,parameter2);
The input file is a flat-file and we want to group all PROD’s together as shown in the OUTPUT file result. The only way to do this is using indexing within the Sterling Integrator Mapper Extended Rules. Continue reading
This document will discuss how Gentran Integration Suite uses the SAP Meta Data Builder to generate a Data Definition File (DDF) from an IDoc layout. This functionality saves time by generating the IDoc layout in a format that can be imported into the Map Editor so users do not have to create the IDoc layout by hand. Continue reading