SELECT options
Hello, SELECT (...) (busyhourvalue(window(car_traffic.traffic,rpd,1,'RI 086400')::varcounter,busyhour(segment(car_traffic.traffic)), 1)) t_car_traffic, (...) car_traffic.traffic i know is table.column t_car_traffic i know is an alias but what about the rest? busyhourvalue, window, :: , varcounter, busyhour, segment... are speciffic of my DB or are SQL commands? if are SQL commands what they do?? Tks
These appear to be some from of SPL or data blade for your database.
Try to see if it is a SPL;
#>dbschema -d traffic_db_name -f busyhourvalue
Try to see what blades are installed for your database;
#>blademgr
traffic_instance_name> list traffic_db_name
The following will display data blades installed on the server.
#>blademgr
traffic_instance_name> show modules
On Tue, Apr 8, 2008 at 12:32 PM, Paul <petrybr@gmail.com> wrote:
> Hello,
>
> SELECT
> (...)
> (busyhourvalue(window(car_traffic.traffic,rpd,1,'RI
> 086400')::varcounter,busyhour(segment(car_traffic.traffic)), 1))
> t_car_traffic,
>
>
> (...)
>
>
> car_traffic.traffic i know is table.column
> t_car_traffic i know is an alias
>
>
> but what about the rest? busyhourvalue, window, :: , varcounter,
> busyhour, segment... are speciffic of my DB or are SQL commands? if
> are SQL commands what they do??
>
>
>
>
>
> Tks
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
its SPL
tks!
On 8 abr, 15:12, "Eric Rowell" <erow...@gmail.com> wrote:
> These appear to be some from of SPL or data blade for your database.
>
> Try to see if it is a SPL;
> #>dbschema -d traffic_db_name -f busyhourvalue
>
> Try to see what blades are installed for your database;
> #>blademgr
> traffic_instance_name> list traffic_db_name
>
> The following will display data blades installed on the server.
> #>blademgr
> traffic_instance_name> show modules
>
>
>
> On Tue, Apr 8, 2008 at 12:32 PM, Paul <petr...@gmail.com> wrote:
> > Hello,
>
> > SELECT
> > (...)
> > (busyhourvalue(window(car_traffic.traffic,rpd,1,'RI
> > 086400')::varcounter,busyhour(segment(car_traffic.traffic)), 1))
> > t_car_traffic,
>
> > (...)
>
> > car_traffic.traffic i know is table.column
> > t_car_traffic i know is an alias
>
> > but what about the rest? busyhourvalue, window, :: , varcounter,
> > busyhour, segment... are speciffic of my DB or are SQL commands? if
> > are SQL commands what they do??
>
> > Tks
> > _______________________________________________
> > Informix-list mailing list
> > Informix-l...@iiug.org
> >http://www.iiug.org/mailman/listinfo/informix-list- Ocultar texto entre aspas -
>
> - Mostrar texto entre aspas -
Paul wrote:
> Hello,
>
> SELECT
> (...)
> (busyhourvalue(window(car_traffic.traffic,rpd,1,'RI
> 086400')::varcounter,busyhour(segment(car_traffic.traffic)), 1))
> t_car_traffic,
>
>
> (...)
>
>
> car_traffic.traffic i know is table.column
> t_car_traffic i know is an alias
>
>
> but what about the rest? busyhourvalue, window, :: , varcounter,
> busyhour, segment... are speciffic of my DB or are SQL commands? if
> are SQL commands what they do??
>
Busyhourvalue, busyhour, window, and segment are User Defined Functions
(UDRs) which may be SPL, C, or Java sourced functions.
'::' introduces a type cast, in this case to type varcounter which
appears to be a User Defined Type (UDR).
The system catalog or a schema will give you the meanings of these
objects. Try:
dbschema -d mydatabase -ss >mydatabase.sql
Art S. Kagel
Oninit
>
>
>
>
> Tks
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
>
>