Does anyone know where in the repo the order of serial execution is stored. We can get the parent child relationship, but the order of the siblings is a little more tricky. The only place we can find it is AL_LANGTEXT or AL_LANGXMLTEXT and getting it out takes a bit of effort.
We ideally would like to get it out in straight sql, but need a clear relationship to AL_PARENT_CHILD so can get the heirarchy and order out in plain sql.
If the object contains the PARALLEL keyword in the AL_LANGTEXT table the object calls inside are parallel, else sequentially. So you would need to parse the ATL, find the keyword and the objects being called.
Does anyone have the XML schema for AL_LANGXMLTEXT.TEXT_VALUE or for the XML export.
This would allow us to extract information about the structure of jobs also the transforms used, as were currently looking at an upgrade problem where a DF has both a left outer and an inner join in seperate transforms.
actaully the XML language generation doesn’t uses any XSD
you colud try using xsd generator tools by giving the XML file, but again depending on the transforms that you use, you will have to keep updating the xsd, a lot of manual work till you get everything covered