Version control in SPL
Posted in 2006
Topics: Installation, Setup & Upgrades, Stored Procedures & SPL
Hi all; Whats the preferred way to embed version control into SPL. I have a fairly basic string that I test for, in my "install/rollback", but there is no guarranttee that this does not end up split across two rows. EI the data boundary problem. Regards Ian
An easy way to do this is to embed your version control string in a comment on the first line of the SPL file (assuming one procedure per file). Then where you look at sysprocbody, it will be in datakey="T" and seqno=1 right at the beginning of the "data" field. You can also embed it in a comment on the second line of the procedure. Then the string will be a little further into that field. This is safe for multiple procedures in a single file, as long as the header and args don't go beyond ~200 bytes. Zachi Klopman ian wrote: > Hi all; > > Whats the preferred way to embed version control into SPL. > > I have a fairly basic string that I test for, in my "install/rollback", > but there is no guarranttee that this does not end up split across two > rows. EI the data boundary problem. > > Regards > Ian