Hi,
I have three questions:
The first concerns a query against two views bring down our test database:
the query looks something like:
create view view1 as
select a+b as no1, c as no2, d as no3 from table1
select * from view1, table2 where
view1.no1=table2.key
Note how we want to match two fields concatenated from one table against
one field from another table. Doing this directly didn't seem to work, so
we came up with the idea to use a view. This seems to bring down that
server instance! The full SQL is below. (I can supply the complete table
definition if needed).
Question number 2 results from Number 1:
When the instance died from running the above mentioned query, I was able
to restart it. After it died a few more times from further
experimentation, I no longer can restart it. I am getting:
-24994 runtime environment error (param_getvalue INSTANCE_TYPE), cannot
acces PARAM file (32).
How can this easily be solved?
Question #3:
Will the SAPDB development team still be available for support after the
MySQL team goes through?
Thank you,
Noah Silva
IS&T - Programmer Analyst
(215) 419 - 7916
----- Forwarded by Noah J SILVA/INT/CHEM/Corp on 05/29/2003 04:29 PM -----
James ROBIE
05/29/2003 04:26 PM
To: Noah J SILVA/INT/CHEM/[EMAIL PROTECTED]
cc:
Subject: SQL
Here is the SQL for the views and the query.
create view VW_LD_PR as
select
"PR_NAME_FULL",
"PR_CLOCK_NO",
"LD_LOCATION",
"LD_SSN",
"LD_NAME_LAST",
"LD_NAME_FIRST",
"LD_NAME_MIDDLE",
"LD_PHONE",
"LD_EMAIL_INT",
"LD_GOLDID",
TRIM(CHR("PR_SITE"))&
TRIM(CHR("PR_DEPT") )AS "COST_CNTR"
from "TEST"."LD_TABLE", "TEST"."PR_TABLE"
where "LD_SSN" = "PR_SSN"
and "PR_TERM_FLAG" = FALSE
create view VW_COST_CNTR as
select
"CC_COST_CNTR",
"CC_COMP_CODE",
"CC_BUS_AREA",
"BA_NAME"
from "TEST"."CC_COST_CENTER","TEST"."BA_BUS_AREA"
where "CC_BUS_AREA" = "BA_BUS_AREA_NO"
select
"LD_LOCATION"&'_'&
"LD_NAME_LAST"&'_'&
"LD_NAME_FIRST"&'_'&
"PR_CLOCK_NO"
AS "CN",
"PR_NAME_FULL",
"PR_CLOCK_NO",
"LD_LOCATION",
"LD_SSN",
"LD_NAME_LAST",
"LD_NAME_FIRST",
"LD_NAME_MIDDLE",
"LD_PHONE",
"LD_EMAIL_INT",
"LD_GOLDID",
"COST_CNTR",
"CC_COMP_CODE",
"CC_BUS_AREA",
"BA_NAME"
from "TEST".VW_LD_PR, "TEST".VW_COST_CNTR
where "CC_COST_CNTR" = "COST_CNTR"=
