Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / April 2005

Tip: Looking for answers? Try searching our database.

SPLs (created field) with todays date.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cesae Cruz - 28 Apr 2005 18:33 GMT
--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 -&lt;&lt;EOF 2&gt;/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>&nbsp;&nbsp;&nbsp;&nbsp; procid&nbsp; procname&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; owner&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; created<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 76&nbsp;&nbsp; spl_repconf24&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; informix&nbsp;&nbsp; 04/28/2005<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 124&nbsp; spl_tramdesc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; informix&nbsp;&nbsp; 04/28/2005<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 303&nbsp; spl_mdescrip&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; informix&nbsp;&nbsp; 04/28/2005</P>
<P>&nbsp;</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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.