<?xml version="1.0" encoding="UTF-8" standalone="no"?>
|
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
|
<properties>
|
<comment>
|
SQL-Kommandos der Anwendung Nutzerverwaltung
|
</comment>
|
<entry key="dbVorhanden">
|
select s.schemaname, t.tablename
|
from SYS.SYSSCHEMAS as s,
|
SYS.SYSTABLES as t
|
where s.schemaid = t.schemaid
|
and s.schemaname = 'APP'
|
and t.tablename = 'USERS'
|
</entry>
|
<entry key="incrementKey">
|
update app.keytable
|
set key_next = ?
|
where key_name = ?
|
and key_next = ?
|
</entry>
|
<entry key="getNextKey">
|
select key_next from
|
app.keytable
|
where key_name = ?
|
</entry>
|
<entry key="getTrackpoints">
|
select * from
|
app.orte
|
where or_zeit larger ?
|
and or_zeit smaller ?
|
and or_pers_id = ?
|
</entry>
|
<entry key="getFirstTrackpoint">
|
select * from
|
app.orte
|
where or_zeit larger ?
|
and or_zeit smaller ?
|
and or_pers_id = ?
|
fetch first row only
|
</entry>
|
<entry key="getDateList">
|
select substr(or_zeit,1,8) as tag, count(*) as anz from app.orte as orte
|
where or_pers_id = ?
|
and substr(or_zeit,1,8) like ?
|
group by substr(or_zeit,1,8)
|
</entry>
|
</properties>
|
