I have been tasked with creating a list of possible combinations for standard parts.
I have a list of standard parts that look something like this:
I also have a list of color codes that are all two digits:
I am wondering if it is possible in SQL and ultimately in a CL program on our i series to generate a list of all possible final part combinations and put them in a table?
In this example:
I don't have any experience with loops in SQL and am having trouble making sense of the examples I have found.
I can do this in Visual Basic or other languages but the goal is to have it on a schedule and automated on our job scheduler.
Any guidance is appreciated.