SPL routine.

Posted in 2003

Topics: Stored Procedures & SPL, Platform-Specific Issues, Versions, Editions & End-of-Life

Ljiljana Zivanovic — Thu, 14 Aug 2003 19:12:51 — source: IIUG Forums & Mailing Lists

--=_IS_MIME_Boundary Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, We are running IDS 9.3 on Solaris 8. Does any one know how can I check when some SPL routine is created in database. I need a date of creation. thanks, ljiljana --=_IS_MIME_Boundary Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit --------------------------------------------------------- This e-mail contains information some or all of which may be confidential, proprietary and/or legally privileged. If an addressing or transmission error has misdirected this e-mail, please notify the sender by replying to this e-mail. If you are not the intended recipient you must not use, disclose, distribute, copy, print or rely on this e-mail. --------------------------------------------------------- --=_IS_MIME_Boundary--

↪ replying to Ljiljana Zivanovic

Stephanie_Peltier@txnp.uscourts.gov — Thu, 14 Aug 2003 19:36:04 — source: IIUG Forums & Mailing Lists

This is a multipart message in MIME format. --=_related 006B643186256D82_= Content-Type: multipart/alternative; boundary="=_alternative 006B643286256D82_=" --=_alternative 006B643286256D82_= Content-Type: text/plain; charset="us-ascii" You can run the following query: select unique a.procname,b.created from sysprocedures a, sysprocplan b where a.procid = b.procid order by a.procname from within the database. It has the database name and the date created. "Ljiljana Zi...." <ljiljana@mizuhocap.com> Sent by: forum.subscriber@iiug.org 08/14/2003 02:12 PM To: ids@iiug.org cc: Subject: SPL routine. [1703] --=_IS_MIME_Boundary Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, We are running IDS 9.3 on Solaris 8. Does any one know how can I check when some SPL routine is created in database. I need a date of creation. thanks, ljiljana --=_IS_MIME_Boundary Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit --------------------------------------------------------- This e-mail contains information some or all of which may be confidential, proprietary and/or legally privileged. If an addressing or transmission error has misdirected this e-mail, please notify the sender by replying to this e-mail. If you are not the intended recipient you must not use, disclose, distribute, copy, print or rely on this e-mail. --------------------------------------------------------- --=_IS_MIME_Boundary-- --=_alternative 006B643286256D82_= Content-Type: text/html; charset="us-ascii" You can run the following query: select unique               a.procname,         b.created from         sysprocedures a,         sysprocplan b where         a.procid = b.procid   order by a.procname from within the database.  It has the database name and the date created. <img src=cid:_1_1A7C00005E70006B643186256D82> <table width=100%> <tr valign=top> <td> <td>"Ljiljana Zi...." <ljiljana@mizuhocap.com> Sent by: forum.subscriber@iiug.org 08/14/2003 02:12 PM <td>                To:        ids@iiug.org         cc:                 Subject:        SPL routine. [1703]</table> --=_IS_MIME_Boundary Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi all, We are running IDS 9.3 on Solaris 8. Does any one know how can I check when some SPL routine is created in database. I need a date of creation. thanks, ljiljana --=_IS_MIME_Boundary Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit --------------------------------------------------------- This e-mail contains information some or all of which may be confidential, proprietary and/or legally privileged.  If an addressing or transmission error has misdirected this e-mail, please notify the sender by replying to this e-mail.  If you are not the intended recipient you must not use, disclose, distribute, copy, print or rely on this e-mail. --------------------------------------------------------- --=_IS_MIME_Boundary-- --=_alternative 006B643286256D82_=-- --=_related 006B643186256D82_= Content-Type: image/gif Content-ID: <_1_1A7C00005E70006B643186256D82> Content-Transfer-Encoding: base64 R0lGODlh/wGPAOcAAAAAAP////j48AAAgAAAQCAggCAgQCAAgMDYwAAgQAAggCAAQKDI8MDAwAAA wCAgwEAggEBAgP7/+v/d3S4W3d10FAAAOAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAP7/YeL6/93d+v/d3QgCAAANC/7/AGRzQGlpdWcub3JnAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP7/+v/d3fr/3d1IAwAAGgz+/0A/AMcBQD8AxwFA PwDHAUA/AMcBQD8AxwFAPwDHAUA/AMcBygHFAEACAMUBAQBAAgDEAQEAzQHGAMoBAQDGAQEAQDQA yQEBAMUBAQDCAQEAQAIAAgEAQAQAwgEBAMUBAQDJAQEAwgEBAEA0ACwAAAAA/wGPAEAI/wADCBxI sKDBgwgTKlzIsKHDhxAjSpxIsaLFixgzatzIsaPHjxgBFBQZgORDkx9RlkxIUiXIlzBjypxJs6bN mzglAti5c2BPgTx9ljRJ1KfIlkJXAv05kiXTlkiXFs1JtarVq1izasWJ0iVBr0lTKjUINmPZplvT ql3Ltq1bhTyZLlX69KjUrnalfpUL9CDUn1Pp9h1MtO7guVCNBn7LuLHjx5AZqjw7GS7ahWfDRt7M ubPnz1zlgo27WPPXvYVF5wWsOGxm0LBjy56tVnTD0he73o74+vBl2sCDCx+OsLLew6yRP3VNNu7p 40ORt57bHLfvoYELjw1KvLv37zV1U//f+7u0eM1R0Y9dD769+/fwSZ9/Pv+uYpfy7WPnzh2+//8A BmecTOfxFd1zB+pWn3gDrmdggBBGKKFlxeUVXWrMOeWcaYT5dd901aWGIVkTlmjiiSimqOKKKQqA EAEwwlhAjDQSQJCLAeCIYwAG0GjAjzveGGQANdYopEAJENCjkkXGuCSMAu24ZAIzGinAji5mmWOO V26po45e3sjimGRadaUACBBJwAAFsKmlAD0OIOeMB60p5wBXElBAlQlweSaPd+7p559i4ohAly7G OMABBCxggIuHdrmlkncOQEACSfbI5aA4/tRAlEPt2FNPAgRV6qMuysefdnSNauCrf1H/Z9hJ+Bl1 4K22jYcdZuO5ShqucKmaHmCx9neXsbbuSmyyyEqGn4jMHjWZrxuSh1hi+/1VbUN/yninjVmeKa6k RLb5wAGVWlqpnnQOZOe6oMJpZwELtItolgZYWmWU4goEo5xMDuQiA4FaSsC9Q271YJlrLVzRtgxH LPHEFFds8cUYZ+zRctJt1zF9SQ0bIseCeWxybxqnrPLKLLfsMmcNdkiiySBf5lV2IWcocskI3vxx ei8HLfTQRBe9csxOYfbrzx/nLDPPKBst9dRUV221ylHtjPPTO7PHXtYznxx2z9epJ53PXl+t9tps t+32TQ127SCCHDp9HYZRv6333nz3/+33W/nNPNXgOpXHdNrFGs7gqE//7fjjkEcu+eSUV/4RoQSg C7Ci6VpqgMCSCoDuAZp/q1CS79LYeaNbAvpv55WSbrC7bXoOasEDLBDulaSSRy5QnwPw+a663loc rc

SPL routine.

Glossary

Your privacy choices