IIUG francophone

Re: Digest 123 - 124

Posted By: Hubert Bellings
Date: Wednesday, 6 May 2009, at 3:09 p.m.

Bonsoir ,

Tu peux - peut-=EAtre -utiliser une astuce qui n'est autre que les trace =
=20
de debugging.

Example
CREATE PROCEDURE testproc()
DEFINE i INT;
SET DEBUG FILE TO '/tmp/testproc.out';
TRACE ON;
TRACE 'Entering foo';
LET i =3D test2();
LET i =3D i + 1;
TRACE 'i+1 =3D ' || i+1;
TRACE 'Exiting testproc';
TRACE OFF';
END PROCEDURE

Le 05-mai-09 =E0 22:00, iiug-fra@iiug.org a =E9crit :

> The following new messages have been posted on IIUG Francophone at
> <http://www.iiug.org/forums/iiug-fra/index.cgi>.
>
>
> =
**************************************************************************=
*****
>
> #123: Ecrire dans des fichiers par proc=E9dures stock=E9es (MARC =20
> AURELE....)
> #124: Mohamed Afeilal est absent (Mohamed Afeilal)
>
>
> =
**************************************************************************=
*****
>
> MESSAGE: (#123) Ecrire dans des fichiers par proc=E9dures stock=E9es
> <http://www.iiug.org/forums/iiug-fra/index.cgi?rev=3D123>
> AUTHOR: MARC AURELE....
> DATE: Tuesday, 5 May 2009, at 6:30 a.m.
>
> Bonjour =E0 tous,
>
> Je cherche =E0 savoir s'il est possible d'=E9crire dans un fichier des
> informations, notamment, le r=E9sultat d'une requ=EAte.
>
> L'id=E9e serait, lorsqu'une requ=EAte est adress=E9e =E0 la base de =
donn=E9e =20
> par une
> application ext=E9rieure, que le r=E9sultat de cette requ=EAte soit =20=

> enregistr=E9 par
> une proc=E9dure stock=E9e de la base de donn=E9es. Un trigger se =20
> d=E9clencherait lors
> de l'acc=E8s =E0 la base de donn=E9es et appellerait la proc=E9dure =
stock=E9e.
>
> D'apr=E8s les premi=E8res recherches que j'ai pu faire, je n'ai pas =20=

> trouv=E9 le
> moyen d'enregistrer un fichier =E0 partir d'une proc=E9dure stock=E9e.
>
> Quelqu'un sait-il comment faire ? Toute aide serait pr=E9cieuse. Merci =
=20
> d'avance
> !
>
>
> =
**************************************************************************=
*****
>
> MESSAGE: (#124) Mohamed Afeilal est absent
> <http://www.iiug.org/forums/iiug-fra/index.cgi?rev=3D124>
> AUTHOR: Mohamed Afeilal
> DATE: Tuesday, 5 May 2009, at 12:02 p.m.
>
> =
DQpKZSBzZXJhaSBhYnNlbnQoZSkgZHUgIDI3LzA0LzIwMDkgYXUgMTEvMDUvMjAwOS4NCg0KSm=
Ug
> =
csOpcG9uZHJhaSDDoCB2b3RyZSBtZXNzYWdlIGTDqHMgbW9uIHJldG91ci4gUG91ciB0b3V0ZS=
Bp
> =
bmZvcm1hdGlvbiwgbWVyY2kNCmRlIGNvbnRhY3RlciBNciBIYXNzYW7CoEVswqBPdWF6emFuaS=
zC
> =
oE1hbmFnZXLCoHN5c3TDqG1lc8KgZXTCoFNBTiBzdXLCoGxlcw0KbnVtw6lyb3PCoHN1aXZhbn=
Rz
> =
wqA6DQpHU03CoDrCoCAgIDA2NjTCoDE3wqAxMcKgMjcNCkJ1cmVhdcKgOsKgICAwNjY1wqA1MM=
Kg
> =
MTbCoDYyDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS=
0t
> =
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS=
0t
> =
LS0tLS0NCiJDZSBtZXNzYWdlIGNvbnRpZW50IGRlcyBpbmZvcm1hdGlvbnMgY29uZmlkZW50aW=
Vs
> =
bGVzIHByb3TDqWfDqWVzIHBhciBsZQ0Kc2VjcmV0IHByb2Zlc3Npb25uZWwuIEF1IGNhcyBvw7=
kg
> =
aWwgbmUgdm91cyBzZXJhaXQgcGFzIGRlc3RpbsOpLCBub3VzIHZvdXMNCnJlbWVyY2lvbnMgZG=
Ug
> =
YmllbiB2b3Vsb2lyIG5vdXMgZW4gYXZpc2VyIGltbcOpZGlhdGVtZW50IGV0IGRlIGxlIHN1cH=
By
> =
aW1lci4NCkxlcyBvcGluaW9ucyBleHByaW3DqWVzIGF1IHNlaW4gZGUgY2UgbWVzc2FnZSBu4o=
CZ
> =
ZW5nYWdlbnQgcXVlIGxldXIgYXV0ZXVyIGV0DQpuZSBzb250IHBhcyBuw6ljZXNzYWlyZW1lbn=
Qg
> =
Y2VsbGUgZGUgbGEgc29jacOpdMOpLiBNRURJIFRFTEVDT00gUy5BLiBu4oCZYXNzdW1lDQphdW=
N1
> bmUgb2JsaWdhdGlvbiBuaSByZXNwb25zYWJpbGl0w6kgc=20
> +KAmWFnaXNzYW50IGR1IGNvbnRlbnUg
> =
ZGUgY2UgY291cnJpZXINCsOpbGVjdHJvbmlxdWUsIHNhdWYgc2kgbOKAmWluZm9ybWF0aW9uIG=
Vz
> =
dCB1bHTDqXJpZXVyZW1lbnQgY29uZmlybcOpZSBwYXIgw6ljcml0DQpwYXIgdW4gcmVwcsOpc2=
Vu
> =
dGFudCBoYWJpbGl0w6kgZGUgbGEgc29jacOpdMOpLiBMYSB0cmFuc21pc3Npb24gZHUgY291cn=
Jp
> =
ZXINCsOpbGVjdHJvbmlxdWUgbmUgcGV1dCDDqnRyZSBnYXJhbnRpZSBjb21tZSBzw7tyZSBvdS=
Bk
> =
w6ludcOpZSBk4oCZZXJyZXVyIGRhbnMgbGENCm1lc3VyZSBvw7kgZWxsZSBwZXV0IMOqdHJlIG=
Fs
> =
dMOpcsOpZSwgcGVyZHVlLCBkw6l0cnVpdGUsIHJldGFyZMOpZSBvdSBpbmNvbXBsw6h0ZSwNCm=
91
> =
IGNvbnRlbmlyIGRlcyB2aXJ1cy4NCg0KVGhpcyBlLW1haWwgYW5kIGl0cyBhdHRhY2htZW50cy=
Bt
> =
YXkgY29udGFpbiBDT05GSURFTlRJQUwgaW5mb3JtYXRpb24gYW5kDQphcmUgc29sZWx5IGZvci=
B0
> =
aGUgaW50ZW5kZWQgcmVjaXBpZW50LiBJZiB5b3UgaGF2ZSByZWNlaXZlZCB0aGlzIGUtbWFpbC=
Bp
> =
bg0KZXJyb3IsIHBsZWFzZSBpbW1lZGlhdGVseSBub3RpZnkgdGhlIHNlbmRlciBhbmQgZGVsZX=
Rl
> =
IGl0IGZyb20geW91ciBzeXN0ZW0uDQpUaGUgdmlld3MgZXhwcmVzc2VkIGluIHRoaXMgZS1tYW=
ls
> =
IGFyZSBzb2xlbHkgdGhvc2Ugb2YgdGhlIGF1dGhvciBhbmQgbWF5DQpub3QgbmVjZXNzYXJpbH=
kg
> =
YmUgdGhvc2Ugb2YsIG9yIHN1cHBvcnRlZCBieSwgdGhlIGNvbXBhbnkuIE1FREkgVEVMRUNPTS=
BT
> =
QS4NCm5laXRoZXIgYXNzdW1lcyBvYmxpZ2F0aW9ucyBub3IgYWNjZXB0cyBsaWFiaWxpdHkgZm=
9y
> =
IHRoZSBjb250ZW50IG9mIHRoaXMNCmUtbWFpbCwgdW5sZXNzIHRoYXQgaW5mb3JtYXRpb24gaX=
Mg
> =
c3Vic2VxdWVudGx5IGNvbmZpcm1lZCBpbiB3cml0aW5nIGJ5IGENCmR1bHkgYXV0aG9yaXNlZC=
By
> =
ZXByZXNlbnRhdGl2ZS4gRS1tYWlsIHRyYW5zbWlzc2lvbiBjYW5ub3QgYmUgZ3VhcmFudGVlZC=
B0
> =
bw0KYmUgc2VjdXJlIG9yIGVycm9yLWZyZWUgYXMgaW5mb3JtYXRpb24gY291bGQgYmUgY29ycn=
Vw
> =
dGVkLCBsb3N0LCBkZXN0cm95ZWQsDQphcnJpdmUgbGF0ZSBvciBpbmNvbXBsZXRlLCBvciBjb2=
50
> =
YWluIFZJUlVTRVMuICINCiJOb3V2ZWxsZSBudW3DqXJvdGF0aW9uIHTDqWzDqXBob25pcXVlIG=
5h
> =
dGlvbmFsZSDDoCBjb21wdGVyIGR1IHNhbWVkaSA3IG1hcnMNCjIwMDk6IHRvdXMgbGVzIG51bc=
Op
> =
cm9zIGZpeGVzIGV0IG1vYmlsZSBwYXNzZW50IGRlIDkgw6AgMTAgY2hpZmZyZXMuDQoNClBvdX=
Ig
> =
bGUgbW9iaWxlIDogYWpvdXRleiBsZSBjaGlmZnJlIDYgYXByw6hzIGxlIHrDqXJvLiBFeGVtcG=
xl
> =
OiBsZSAwNnggeHggeHgNCnh4IGRldmllbnQgbGUgMDYgNnggeHggeHggeHgNClBvdXIgbGUgZm=
l4
> =
ZSA6IGFqb3V0ZXogbGUgY2hpZmZyZSA1IGFwcsOocyBsZSB6w6lyby4gRXhlbXBsZSA6IGxlID=
Ay
> =
MiB4eCB4eA0KeHggZGV2aWVudCAgMDUgMjIgeHggeHggeHgNClBvdXIgY29udGFjdGVyIGxlIE=
1h
> =
cm9jIGRlcHVpcyBs4oCZw6l0cmFuZ2VyOiBham91dGVyIGFwcsOocyBsZSAyMTIgbGVzDQpjaG=
lm
> =
ZnJlcyA2IHBvdXIgbGUgbW9iaWxlIGV0IDUgcG91ciBsZSBmaXhlIGltbcOpZGlhdGVtZW50IH=
N1
> =
aXZpcyBkdSBudW3DqXJvDQrDoCA4IGNoaWZmcmVzIGRlIHZvdHJlIGNvcnJlc3BvbmRhbnQuIE=
V4
> =
ZW1wbGUgcG91ciBsZSBtb2JpbGU6IGxlIDIxMiA2eCB4eA0KeHggeHggZGV2aWVudCBsZSAyMT=
Ig
> =
NiA2eCB4eCB4eCB4eCBFeGVtcGxlIHBvdXIgbGUgZml4ZTogbGUgMjEyIDIyIHh4IHh4IHh4DQ=
pk
> ZXZpZW50IGxlIDIxMiA1IDIyIHh4IHh4IHh4ICI=3D
>
>
> =
**************************************************************************=
*****
>
> This is an automatically-generated notice. If you'd like to be =20
> removed from
> the mailing list, please unsubscribe in the IIUG Member Area at
> http://www.iiug.org or email forummaster@iiug.org .

Hubert Bellings
hubert.bellings@mac.com

IIUG francophone is maintained by Administrator with WebBBS 5.12.