| commit | author | age | ||
| 314fea | 1 | <?xml version="1.0" encoding="UTF-8" standalone="no"?> |
| U | 2 | <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd"> |
| 3 | <properties> | |
| 4 | <comment> | |
| 5 | SQL-Kommandos der Anwendung Nutzerverwaltung | |
| 6 | </comment> | |
| 7 | <entry key="dbVorhanden"> | |
| 8 | select s.schemaname, t.tablename | |
| 9 | from SYS.SYSSCHEMAS as s, | |
| 10 | SYS.SYSTABLES as t | |
| 11 | where s.schemaid = t.schemaid | |
| 12 | and s.schemaname = 'APP' | |
| 8b423e | 13 | and t.tablename = 'USERS' |
| 314fea | 14 | </entry> |
| U | 15 | <entry key="incrementKey"> |
| 16 | update app.keytable | |
| 17 | set key_next = ? | |
| 18 | where key_name = ? | |
| 19 | and key_next = ? | |
| 20 | </entry> | |
| 21 | <entry key="getNextKey"> | |
| 22 | select key_next from | |
| 23 | app.keytable | |
| 24 | where key_name = ? | |
| 25 | </entry> | |
| 26 | <entry key="getTrackpoints"> | |
| 27 | select * from | |
| 28 | app.orte | |
| 29 | where or_zeit larger ? | |
| 30 | and or_zeit smaller ? | |
| 31 | and or_pers_id = ? | |
| 32 | </entry> | |
| 33 | <entry key="getFirstTrackpoint"> | |
| 34 | select * from | |
| 35 | app.orte | |
| 36 | where or_zeit larger ? | |
| 37 | and or_zeit smaller ? | |
| 38 | and or_pers_id = ? | |
| 39 | fetch first row only | |
| 40 | </entry> | |
| 41 | <entry key="getDateList"> | |
| 42 | select substr(or_zeit,1,8) as tag, count(*) as anz from app.orte as orte | |
| 43 | where or_pers_id = ? | |
| 44 | and substr(or_zeit,1,8) like ? | |
| 45 | group by substr(or_zeit,1,8) | |
| 46 | </entry> | |
| 47 | </properties> | |
