<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
pkid is of type GUID, but as you found, unfortunately informix GUID
doesn't clearly contain timestamp as microsft SQL server GUID does.<br>
<br>
that was my only idea for creation time.<br>
<br>
/wes<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Thorsten.Mayr@barclayscapital.com">Thorsten.Mayr@barclayscapital.com</a> wrote:
<blockquote
cite="mid:568BC086983B9544993FA5104CF68E1A030053D0@LDNPCMEU304VEUA.INTRANET.BARCAPINT.COM"
type="cite">
<pre wrap="">That'd be more then good enough.
GUID... Hm, can't select it as a column and I assume
guid != pkid
(at least not obvious to me pkid doesn't seem to contain a
(unix)timestamp)
Sorry if thick question - where could I retrieve the GUID from?
Also what's the determination of why some rows/entries were given have a
versionstamp and some don't?
The closest match to guid I was able to find was guidtable from the
output of the syscolumns but that's probably the wrong direction...
Thanks in advance
T
</pre>
<blockquote type="cite">
<pre wrap="">-----Original Message-----
From: Wes Sisk [<a class="moz-txt-link-freetext" href="mailto:wsisk@cisco.com">mailto:wsisk@cisco.com</a>]
Sent: Wednesday, July 02, 2008 2:01 PM
To: Mayr, Thorsten: IT (LDN)
Cc: <a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
Subject: Re: [cisco-voip] Database callmanager 5.x
unfortunately not. the closest would be to derrive the
timestamp from the GUID.
GUID is unique for every row in a table and timestamp is part
of the GUID. given the GUID is only generated when the row
is inserted....
/wes
<a class="moz-txt-link-abbreviated" href="mailto:Thorsten.Mayr@barclayscapital.com">Thorsten.Mayr@barclayscapital.com</a> wrote:
Wes,
CDRTIME = last touch
Is there a hidden column for creation time as well by
any chance? ;)
Thanks
T
-----Original Message-----
From: Wes Sisk [<a class="moz-txt-link-freetext" href="mailto:wsisk@cisco.com">mailto:wsisk@cisco.com</a>]
Sent: Tuesday, July 01, 2008 6:44 PM
To: Mayr, Thorsten: IT (LDN)
Subject: Re: [cisco-voip] Database callmanager 5.x
welcome. wasn't avoiding you, just wanted to
get correct
answer out for all. /wes
<a class="moz-txt-link-abbreviated" href="mailto:Thorsten.Mayr@barclayscapital.com">Thorsten.Mayr@barclayscapital.com</a> wrote:
Thanks Wes
-----Original Message-----
From: Wes Sisk [<a class="moz-txt-link-freetext" href="mailto:wsisk@cisco.com">mailto:wsisk@cisco.com</a>]
Sent: Tuesday, July 01, 2008 5:36 PM
To: Mayr, Thorsten: IT (LDN)
Cc: <a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
Subject: Re: [cisco-voip]
Database callmanager 5.x
correction: numplan. short
circuit between
keyboard and monitor
admin:run sql select * from
typepatternusage
enum name moniker
==== ==================
==========================
0 CallPark
PATTERN_CALL_PARK
1 Conference PATTERN_CONF
2 Device PATTERN_DEVICE
3 Translation
PATTERN_TRANSLATION
4 Call Pick Up Group
PATTERN_CALL_PICK_UP_GROUP
5 Route PATTERN_ROUTE
6 Message Waiting
PATTERN_MESSAGE_WAITING
7 Hunt Pilot
PATTERN_HUNT_PILOT
8 Voice Mail Port
PATTERN_VOICE_MAIL_PORT
9 Domain Routing
PATTERN_ROUTE_DOMAIN
10 IPAddress Routing
PATTERN_ROUTE_IPNET
11 Device template
PATTERN_DEVICE_TEMPLATE
admin:run sql select
pkid,dnorpattern from
numplan where
tkpatternusage=5
/Wes
Wes Sisk wrote:
routeplan primarily.
CM 5.0 database
dictionary:
<a class="moz-txt-link-freetext" href="http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/5_0_4/dd50">http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/5_0_4/dd50</a>
4.pdf
some interesting things
change in 6
with database user
facing features:
<a class="moz-txt-link-freetext" href="http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/6_0_1/dd60">http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/datadict/6_0_1/dd60</a>
1.pdf
/Wes
<a class="moz-txt-link-abbreviated" href="mailto:Thorsten.Mayr@barclayscapital.com">Thorsten.Mayr@barclayscapital.com</a> wrote:
Guys,
I am looking
for the name of
the table that would contain the
routepatterns
in the informix database.
I did look at
the systables etc
but couldn't make it out.
If anybody
knows... much
appreciated
Thanks
T
_______________________________________________
This e-mail may contain
information that is confidential,
privileged
or otherwise
protected from
disclosure. If you are not an intended
recipient of
this e-mail, do
not duplicate or redistribute
it by any
means. Please
delete it and any
attachments and notify the sender
that you have
received it in
error. Unless specifically indicated,
this e-mail is
not an offer to
buy or sell or a
solicitation to buy
or sell any securities,
investment products or other financial
product or
service, an official
confirmation of any
transaction, or
an official
statement of
Barclays. Any views or opinions presented
are solely
those of the author
and do not necessarily
represent those
of Barclays.
This e-mail is
subject to terms available at the
following link:
<a class="moz-txt-link-abbreviated" href="http://www.barcap.com/emaildisclaimer">www.barcap.com/emaildisclaimer</a>. By messaging with
Barclays you
consent to the
foregoing. Barclays Capital is the
investment
banking division of
Barclays Bank PLC, a company
registered in
England (number
1026167) with its registered offi!
ce at 1
Churchill Place,
London, E14 5HP. This email may
relate to
or be sent from
other members
of the Barclays Group.
_______________________________________________
_______________________________________________
cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
_______________________________________________
This e-mail may contain information that is
confidential, privileged or otherwise protected from
disclosure. If you are not an intended
recipient of this
e-mail, do not duplicate or redistribute it by
any means.
Please delete it and any attachments and notify
the sender
that you have received it in error. Unless specifically
indicated, this e-mail is not an offer to buy
or sell or a
solicitation to buy or sell any securities, investment
products or other financial product or service,
an official
confirmation of any transaction, or an official
statement of
Barclays. Any views or opinions presented are
solely those of
the author and do not necessarily represent those of
Barclays. This e-mail is subject to terms
available at the
following link: <a class="moz-txt-link-abbreviated" href="http://www.barcap.com/emaildisclaimer">www.barcap.com/emaildisclaimer</a>.
By messaging
with Barclays you consent to the foregoing.
Barclays Capital
is the investment banking division of Barclay
s Bank PLC, a company registered in
England (number
1026167) with its registered office at 1
Churchill Place,
London, E14 5HP. This email may relate to or
be sent from
other members of the Barclays Group.
_______________________________________________
_______________________________________________
This e-mail may contain information that is
confidential, privileged or otherwise protected from
disclosure. If you are not an intended recipient of this
e-mail, do not duplicate or redistribute it by any means.
Please delete it and any attachments and notify the sender
that you have received it in error. Unless specifically
indicated, this e-mail is not an offer to buy or sell or a
solicitation to buy or sell any securities, investment
products or other financial product or service, an official
confirmation of any transaction, or an official statement of
Barclays. Any views or opinions presented are solely those of
the author and do not necessarily represent those of
Barclays. This e-mail is subject to terms available at the
following link: <a class="moz-txt-link-abbreviated" href="http://www.barcap.com/emaildisclaimer">www.barcap.com/emaildisclaimer</a>. By messaging
with Barclays you consent to the foregoing. Barclays Capital
is the investment banking division of Barclay
s Bank PLC, a company registered in England (number
1026167) with its registered office at 1 Churchill Place,
London, E14 5HP. This email may relate to or be sent from
other members of the Barclays Group.
_______________________________________________
</pre>
</blockquote>
<pre wrap=""><!---->_______________________________________________
This e-mail may contain information that is confidential, privileged or otherwise protected from disclosure. If you are not an intended recipient of this e-mail, do not duplicate or redistribute it by any means. Please delete it and any attachments and notify the sender that you have received it in error. Unless specifically indicated, this e-mail is not an offer to buy or sell or a solicitation to buy or sell any securities, investment products or other financial product or service, an official confirmation of any transaction, or an official statement of Barclays. Any views or opinions presented are solely those of the author and do not necessarily represent those of Barclays. This e-mail is subject to terms available at the following link: <a class="moz-txt-link-abbreviated" href="http://www.barcap.com/emaildisclaimer">www.barcap.com/emaildisclaimer</a>. By messaging with Barclays you consent to the foregoing. Barclays Capital is the investment banking division of Barclay
s Bank PLC, a company registered in England (number 1026167) with its registered office at 1 Churchill Place, London, E14 5HP. This email may relate to or be sent from other members of the Barclays Group.
_______________________________________________
</pre>
</blockquote>
</body>
</html>