this statement works fine
Code:
SELECT DISTINCT users.id AS userid, persons.familyname || ' ' || persons.name
|| ' ' || persons.patronymic AS ulogin, organisations.name AS orgname, org
.get_path( organisations.id, ' / ' ) AS orgpath, persons.position,
persons.email, persons.phone, persons.id AS personid
FROM util.users AS users
LEFT JOIN util.persons AS persons
ON persons.id = users.personid
LEFT JOIN org.organisations AS organisations
ON organisations.id = persons.orgid
WHERE users.id >= 6;
Also, I have a view on this select, called stats.userinfo and then I call
Code:
select * from stats.userinfo
DB2 "crashing" (I get 'communication link failed')
What's wrong??