[EMAIL PROTECTED] wrote: > > I try create view and occur error > > ---- Error ------------------------------- > Auto Commit: On, SQL Mode: Internal, Isolation Level: Serializable > General error;-9205 POS(1) System error: AK Catalog information not > found: > CREATE VIEW LAB.authorized_services > > if I remove string 'LAB.rangeToString(c.normal_range) normal_range' from > select view created succeeded > > 'test view' > > CREATE VIEW LAB.authorized_services > > AS > > SELECT > f.patient_code, > g.profile_code service_code, > v.profile_name service_name, > a.counter, > DECODE(a.profile_state, 'archived', 'authorized', a.profile_state) > profile_state, > a.scheduled_time, > a.authorized_time, > a.conclusion, > a.doctor, > c.scheduled_test, > h.test, > h.test_type, > h.test_code, > x.test_name, > k.unit_name, > d.sampling_time, > i.material_name, > e.result_type, > e.value_type, > CASE > WHEN e.value_type = 'result' THEN > CASE > WHEN e.result_type = 'qual' THEN j.flag_name > WHEN e.result_type = 'quantflag' THEN > DECODE(e.outofrange, NULL, '', e.outofrange || ' ') || e.er_result > END > WHEN e.value_type = 'comment' THEN e.comment > END result, > CASE > WHEN e.value_type = 'result' THEN e.comment > WHEN e.value_type = 'comment' THEN NULL > END comment, > c.rule, > c.rulerevisionno, > c.normal_node normal_node, > > LAB.rangeToString(c.normal_range) normal_range, > > CASE > WHEN e.result_type = 'qual' THEN NULL > WHEN e.result_type = 'quantflag' THEN j.flag_name > END flag_name > > FROM > > LAB.scheduled_profiles a, > LAB.scheduled_investigations b, > LAB.scheduled_tests c, > LAB.scheduled_samples d, > LAB.raw_results e, > LAB.rt_patients f, > > LAB.rt_profiles g, > LAB.rt_profile_properties v, > > LAB.rt_tests h, > LAB.rt_test_properties x, > > > LAB.rt_materials i, > LAB.er_reference_flags j, > LAB.rt_units k > > WHERE > > a.scheduled_profile = b.scheduled_profile > AND b.scheduled_invest = c.scheduled_invest > AND b.scheduled_sample = d.scheduled_sample > AND c.raw_result = e.raw_result > > AND a.patient = f.patient > > AND a.profile = g.profile > AND g.profile = v.profile > AND v.FromRevisionNo <= g.RevisionNo > AND g.RevisionNo < DECODE(v.ToRevisionNo, NULL, g.RevisionNo + 1, > v.ToRevisionNo) > > AND c.test = h.test > AND h.test = x.test > AND x.FromRevisionNo <= h.RevisionNo > AND h.RevisionNo < DECODE(x.ToRevisionNo, NULL, h.RevisionNo + 1, > x.ToRevisionNo) > > AND d.work_material = i.material > > AND e.reference_flag = j.reference_flag (+) > AND e.er_unit = k.unit (+) > >
Please provide which system information is missing (can be found in knldiag). On the other hand: I do not remember exactly, but it may help to get rid of LAB. In front of the function-name. Elke SAP Labs Berlin > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
