Converting Progress / 4gl To Sql

[Michael Vincent]

I need to convert a number of queries and functions from Progress / 4GL to SQL.

Can you help me get started, please? Here is one of the 4GL statements I need to convert.

for each Part where (
Part.NonStock = false AND
Part.InActive = false AND
Part.QtyBearing = true) no-lock ,

each PartWhse outer-join where (
Part.Company = PartWhse.Company and
Part.PartNum = PartWhse.PartNum) no-lock ,

each PartCost outer-join where (
Part.Company = PartCost.Company and
Part.PartNum = PartCost.PartNum) no-lock .


Can you explain the 4GL bits and give some hints as to what the SQL would look like.

I have some SQL knowledge, but next to no 4GL knowledge.

Continue reading...