RE: SPLs (created field) with todays date.

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] > On Behalf Of Cesae Cruz > Sent: Thursday, April 28, 2005 1:34 PM > To: robert.seifert@de.ibm.com; John Adamski; DirkM@mxgroup.co.za > Cc: informix-list@iiug.org; owner-informix-list@iiug.org > Subject: SPLs (created field) with todays date. > > 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 <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