Course Description
A three-day course that involves learning the basic language to query the FLIS DB2 database. Day 1 is spent learning (via many hand-on exercises) the relationship between the FLIS TIR (NSN), Volume 12, and the DB2 tables. Day 2 involves learning how to build basic SELECT statements and gradually adding several various clauses and query functions in their proper order to affect desired results. It also covers learning how to manipulate query result with continuous exercises. Day 3 is spent focusing on the versatility of the WHERE clause, Comparison Operators, and the CONCAT, BETWEEN, LIKE, IN, NOT IN, and DISTINCT functions. Constant query construction will be expected based on a variety of situational query requests. In preparation for the class, attendees should have access to the DB2 TEST region and DoD 4100.39-M Volume 12.
Target Audience
Wholesale level logisticians and supply support personnel who wish to gain an understanding of the FLIS and related data elements.
Delivery Methods
Classroom (24 Hours)
Classroom Dates:
May 20-22, 2025
September 16-18, 2025
Contact us
For questions or additional interest in Training, contact the Customer Support Training at:
E-mail: dla.tng@dla.mil