<?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 radiozentrale
|
</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 = 'SENDER'
|
</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="getSenderList">
|
select * from
|
app.sender
|
</entry>
|
<entry key="getSender">
|
select * from
|
app.sender
|
where sender_id = ?
|
</entry>
|
<entry key="getAbspielerList">
|
select * from
|
app.abspieler
|
</entry>
|
<entry key="getAbspieler">
|
select * from
|
app.abspieler
|
where abs_id = ?
|
</entry>
|
<entry key="unselectAbspieler">
|
update app.abspieler
|
set abs_zustand = ?
|
where abs_zustand = ?
|
</entry>
|
</properties>
|
