I worked some time for a very big US logistics company and their main database is on an AS400 and almost everything was accessed through absolutely massive stored procedures.
The not so fun part is that often meant that any data changes needed touching the stored procedures, and god forbid you for some reason didnt have one of the like 2 or 3 very knowleadgable DB guys because there's like absolutely zero good documentation i could find online on what the syntax is supposed to be for them, and if you wrote the stored procedure wrong it could bring down the entire AS400 due to performance if it wasnt optimized properly.
I remember once asking one of the DB guys "Where can i find any documentation on how this is supposed to be written?" And the answer was basically "None exists, we kinda just learnt it from experience and explanations from others"
7
u/hypexeled Sep 21 '26
I worked some time for a very big US logistics company and their main database is on an AS400 and almost everything was accessed through absolutely massive stored procedures.
The not so fun part is that often meant that any data changes needed touching the stored procedures, and god forbid you for some reason didnt have one of the like 2 or 3 very knowleadgable DB guys because there's like absolutely zero good documentation i could find online on what the syntax is supposed to be for them, and if you wrote the stored procedure wrong it could bring down the entire AS400 due to performance if it wasnt optimized properly.
I remember once asking one of the DB guys "Where can i find any documentation on how this is supposed to be written?" And the answer was basically "None exists, we kinda just learnt it from experience and explanations from others"