--0-1221937068-1114709628=:15493
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Hi,
When I execute this script:
dbaccess bd_avaluos -<<EOF 2>/dev/null | grep -v ^$
select unique sysprocedures.procid, sysprocedures.procname, sysprocedures.owner, sysprocplan.created from sysprocedures, sysprocplan
where sysprocedures.procid = sysprocplan.procid
and sysprocedures.procname not like ("%sys%")
order by 1;
EOF
I saw all SPLs (created field) with todays date.
procid procname owner created
76 spl_repconf24 informix 04/28/2005
124 spl_tramdesc informix 04/28/2005
303 spl_mdescrip informix 04/28/2005
Why?
Some one are updating this SPL's?
Regards,
Cesar
---------------------------------
Do You Yahoo!?
Yahoo! Net: La mejor conexión a internet y 25MB extra a tu correo por $100 al mes.
--0-1221937068-1114709628=:15493
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
<P>Hi,</P>
<P>When I execute this script:</P>
<P>dbaccess bd_avaluos -<<EOF 2>/dev/null | grep -v ^$<BR>select unique sysprocedures.procid, sysprocedures.procname, sysprocedures.owner, sysprocplan.created from sysprocedures, sysprocplan<BR>where sysprocedures.procid = sysprocplan.procid<BR>and sysprocedures.procname not like ("%sys%")<BR>order by 1;<BR>EOF<BR></P>
<P>I saw all SPLs (created field) with todays date.</P>
<P> procid procname owner created<BR> 76 spl_repconf24 informix 04/28/2005<BR> 124 spl_tramdesc informix 04/28/2005<BR> 303 spl_mdescrip informix 04/28/2005</P>
<P> </P>
<P>Why?</P>
<P>Some one are updating this SPL's?</P>
<P>Regards,</P>
<P>Cesar </P><p><br><hr size=1><b>Do You Yahoo!?</b><br>
<a href="http://net.yahoo.com.mx"><b>Yahoo! Net</b></a>: La mejor conexión a internet y 25MB extra a tu correo por
<a href="http://net.yahoo.com.mx/">$100 al mes</a>.<br>
--0-1221937068-1114709628=:15493--
sending to informix-list
Bill Dare - 28 Apr 2005 20:32 GMT
The created date is from sysprocplan, the date the query plan for the
procedure was created. Not the date the procedure was created. See the
Guide to SQL description of sysprocplan for details.
Bill
> -----Original Message-----
> From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org]
[quoted text clipped - 39 lines]
> Yahoo! Net <http://net.yahoo.com.mx>: La mejor conexión a internet y
> 25MB extra a tu correo por $100 al mes <http://net.yahoo.com.mx/>.
sending to informix-list