TeamDeveloper Informix Stored Procedure

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
! ------------------------------ DB Connection
Set SqlDatabase = 'island'
Set SqlUser = 'sysadm'
Set SqlPassword = 'sysadm'
! ------------------------------ Set Params
If SqlConnect( hSql )
  Call SqlSetIsolationLevel( hSql, 'RO' )
  Call SqlSetParameter( hSql, DBP_AUTOCOMMIT, FALSE, '' )
  Call SqlSetParameter( hSql, DBP_ROLLBACKONTIMEOUT, TRUE, '' )
  Call SqlSetParameter( hSql DBP_LOCKWAITTIMEOUT, 07, '' )
  ! following line allow the stored proc to return value
  Call SqlSetResultSet(hSqlgCGR,TRUE)
  ! ------------------------------ Procedure aufrufen
  Set sParam = 'ProcedureParameter'
  If NOT SqlRetrieve( hSqlgCGR, 'procedure_name', ':sParam', ':nReturnA,:nReturnB,:sReturnC' )
    Return FALSE
  If NOT SqlExecute( hSqlgCGR )
    Return FALSE
  If NOT SqlFetchNext( hSqlgCGR, nRetVal )
    Return FALSE
  Return TRUE

Quelle: Jean-Philippe VICTOIRE (06 Oct 2007, 22:45) store procedure on informix database http://forum.tdcommunity.net/viewtopic.php?f=58&t=39199&p=131209&hilit=informix+procedure#p131209 

T4 Bett

  • http://www.little-devil.de/ldp/files/LDP_Vito_Viano_Bauanleitung_ausziehbares_Bett_V0_8.pdf
  • http://www.t4forum.de/wbb3/index.php?page=Attachment&attachmentID=171326&h=5ae912938d2599047df9a4f30a8837f5017311d2&s=acd55c9b3fa5b5ace8bfde60d53dae31852679ac
  • http://www.t4forum.de/wbb3/board19-technik-bereich/board121-camping/board81-wohnmobil-und-wohnwagentechnik/113296-bett-aus-aluprofil-möglich-sinnvoll/

Alu-Profile

  • https://www.ebay.de/p/?iid=381783070349&chn=ps&var=650818414024

RASPi Webcam

Ziel

Raspberry Pi Webcam

Lösung

Motion Bibliothek [3].

Infos


1
 

1
sudo service motion start

1
sudo service motion stop

1
sudo service motion restart

Quellen

  1. Gus, 2015: Build a Raspberry Pi Webcam Server in Minutes,
    https://pimylifeup.com/raspberry-pi-webcam-server/ (abgerufen: 2017-05-21)
  2. Gus, 2014: Dead Easy Guide To Installing NOOBS Raspberry Pi,
    https://pimylifeup.com/noobs-raspberry-pi/ (abgerufen: 2017-05-21)
  3. Kenneth Lavrsen, 2016: Motion, a software motion detector,
    http://www.lavrsen.dk/foswiki/bin/view/Motion/WebHome (abgerufen: 2017-05-21)

PL/SQL Aufruf

SKRIPT:

1
2
3
4
5
6
7
8
9
10
CREATE OR REPLACE PROCEDURE Warenentnahme (warid IN INTEGER, menge IN INTEGER) AS minanz INTEGER;

anz INTEGER;
BEGIN
    UPDATE lager SET anzahl = anzahl - menge WHERE warenid = warid;
    SELECT w.mindestvorratsmenge, l.anzahl INTO minanz, anz FROM lager l JOIN ware w ON w.warenid = warid;
    IF minanz > anz THEN
        UPDATE lager SET anzahl = anzahl + 50 WHERE warenid = warid;
    END IF;
END;

AUFRUF:

1
begin
1
 Warenentnahme(5,2);
1
 end;
1
 /

 

(Quelle: https://entwickler-forum.de/showthread.php/9941-Stored-Procedure-ausführen, Abruf: 2017-05-21)