SQL ERROR 408 Need GURU HELP !!!
INFORMIX SQL GURUS... Informix On-Line 5.01UD1
Ladies and Gents... I run the following Query either stand alone or in an
ACE and it works if I use a date range of 9 months. However when I use a full
year range like below I get a @!*&^^% Informix 408 error.
No space problems.... I have 50,000 pages free in rootdbs and .5 Gig /usr/tmp
free
Any Ideas Please reply to list or tkmclean@ingr.com
I've tried redoing query... drop reload tables new indexes etc.
select s.sort_order,
s.sort_des,
c.pt_sub_cd,
c.pt_sub_des,
sum(p.sales) sales,
sum(p.cost) cost,
sum(p.pmargin) pmargin
from csa_margin p, c_pt_sub c, c_sort s
where
p.pt_sub_cd = c.pt_sub_cd and
c.sort_order = s.sort_order
and p.time_pd between "01/01/94"
and "01/01/95"
and p.wa_nbr matches "*"
group by s.sort_order, c.pt_sub_cd, s.sort_des,c.pt_sub_des
order by sort_order, pt_sub_cd
END
BELOW SCHEMA FOR TABLES IN QUERY.............
DBSCHEMA Schema Utility INFORMIX-SQL Version 5.01.UD1
Copyright (C) Informix Software, Inc., 1984-1991
Software Serial Number ITG#R690192
{ TABLE "padba".csa_margin row size = 48 number of columns = 9 index size = 91 }
create table "padba".csa_margin
(
wa_nbr char(8),
rgn_cd char(5),
rgn_gp_cd char(1),
sort_order smallint, Note about 600,000 records
pt_sub_cd char(4),
sales money(13,2),
cost money(13,2),
pmargin money(13,2),
time_pd date
);
create index "padba".i_sorsub on "padba".csa_margin
(sort_order,pt_sub_cd,time_pd);
create index "padba".i_wrgnsub on "padba".csa_margin
(wa_nbr,rgn_cd,rgn_gp_cd,time_pd);
create unique index "padba".i_wrptmarg on "padba".csa_margin
(wa_nbr,rgn_cd,pt_sub_cd,time_pd);
{ TABLE "padba".c_pt_sub row size = 36 number of columns = 3 index size = 0 }
create table "padba".c_pt_sub
(
pt_sub_cd char(4),
pt_sub_des char(30), Note about 7 records
sort_order smallint
);
{ TABLE "informix".c_sort row size = 22 number of columns = 2 index size = 9 }
create table "informix".c_sort
(
sort_order smallint, Note: about 126 records
sort_des char(20)
);
create index "informix".i_sorcd on "informix".c_sort (sort_order);