When matching the DB field names to the NJ structure for the variables connected to the database you do not have to have all the field names – nor do they have to be in order. The variable types will not match exactly and the manual shows you how to match them up. IBM DB2 Field names Sysmac Studio Variables using Structures – to match the IBM DB2 field names. You then create a variable for the DB_Insert and DB_Select Instructions – note that both are of the same structure but the DB_Select can be an array (DB_Insert variable cannot be an array). In this case the variables were made in the Global Variables area. Page 11 of 21