I've inherited a data model with the following code. 1st, table "tmp_SIC" is loaded, it is then followed by a Concatenate statement. I understand what a Concatenate statement does; however, I'm confused as to how this one works. This LOAD statement (the first one) does not use a FROM clause. Is it implied by the following LOAD?
Concatenate (tmp_SIC) LOAD * WHERE SICConcatIncludeFlag = 1 ;
I think what you have here is something called "LOAD on LOAD" or "Preceding load on preceding load". You effectively do a load right on top of the next load (so you read the who structure from the "from" part up).
I am sure there are documents about this, but a quick search on "load on load" on the help did not give me anything to show you.