RE: Stored Procedure
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------ =_NextPart_000_01BDA3B5.643CFE50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Christian,
Your error 687 *may* be solved by hardcoding a path (ie. =
/tmp/trace.out)
to a known directory. I spent an embarrassing number of hours recently
trying to track down this problem. With my wonderful sense of humor, I
appreciated the catch-22 I was in--it was a good one, however my
wonderful sense of humor did become stressed as the hours wore on!
Good luck!
-Todd
> ----------
> From: Hofinger,
> Christian[SMTP:Christian.Hofinger@dresdner-bauspar.com]
> Sent: Monday, June 29, 1998 6:08 AM
> To: 'informix-list@iiug.org'
> Subject: Stored Procedure
>=20
> Hallo
>=20
>=20
> this is my stored procedure.
>=20
> -------------------------------------------------------
>=20
> create procedure pr_update_import()>=20
> define i,j INT;
>=20
> TRACE OFF;
> SET DEBUG FILE TO 'trace.out';
> TRACE ON;
>=20
> let j =3D 1;
> foreach cur1 for select testschalter into i from import
> if i > 100 and i < 1000 then
> begin work;
> update import set testschalter =3D j where current of cur1;> commit work;
> let j =3D j + 1;
> end if
> end foreach
>=20
> trace off;
>=20
> end procedure
>=20
> ----------------------------------------------------------
>=20
> Two errors : 687 : Set debug file before tracing
>=20
> If I leave the tracing :
>=20
> 255 : not in transaction=20
>=20
> I have no answer !!
>=20
> Thanks in advance
>=20
>=20
> In der Hoffnung das Deutschland Weltmeister wird verbleibe ich,
>=20
> mit freundlichem Gru=DF
>=20
> Christian Hofinger
> ------------------------------------------------
> Anwendungsentwickler Dresdner Bauspar AG
> Tel. : 069 263 - 7830
> EMail : Christian.Hofinger@dresdner-bauspar.com
>=20
------ =_NextPart_000_01BDA3B5.643CFE50
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IjMXAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQAVAAAAUkU6IFN0b3JlZCBQcm9jZWR1cmUAKwcBCYABACEA
AABBQTY3RTQ4QTVGMEZEMjExQkQ1MDAwODA1RkJDQkQzRABaBwEggAMADgAAAM4HBgAdABAAGgAy
AAEAVQEBBYADAA4AAADOBwYAHQAQABoAIgABAEUBAQ2ABAACAAAAAgACAAEDkAYA4AcAAB0AAAAD
AC4AAAAAAEAAOQDgbqxataO9AR4AcAABAAAAEQAAAFN0b3JlZCBQcm9jZWR1cmUAAAAAAgFxAAEA
AAAbAAAAAb2jeO9TNg7VzQ8XEdK4ZwCAX0v/WgAOzA0yAAIBCRABAAAAIgUAAB4FAACpCQAATFpG
dbGzoHv/AAoBDwIVAqQD5AXrAoMAUBMDVAIAY2gKwHNldO4yBgAGwwKDMgPGBxMCg7ozEw19CoAI
zwnZOxX/eDI1NQKACoENsQtgbvBnMTAzFCALChLyDAEiYwBAIENoBRBzdFkHMG4sCoUKhVkIYSAH
BJADYAXANjg3ICoBAMB5KiBiZSBzTQbwdgmAHaB5IBHBZIUFoGQLgGcgYSAKsBB0aCAoCJAuIC/o
dG1wH/ByANAfwAhgIHQpIHRvHyFrblxvdwOgHuAWAGMg8HLSeR/QIEkd0HAJ8AVAfQORZQbQCsAg
UAQQHvJuxnUG0ASQIG9mHnAIYbcEICHBIqFsHmAgQHke8vsg8SBCayGQIWIfcAQAH0BPA2ACYCMQ
IjFXaR9xbc0eYHcCIASBZnUDIBHwXwCAHcAkUiPwBbAsIlFh7nAnEAWQBzB0HiEfcB3AZmMfYBGw
LTISICJgd+UjcCALgC0tJ8Arkx8wzGdvBHAkQG5lKbAkgPx3ZR4QBcAoDykYIZEeMf8FkQeAHdAg
QAeQEfAeMCuxXyqyJIQuABYALPEhG4xHTyzCCkAmQDIdLVQEcGSDG4wK9GxpMTgwAtHgaS0xNDQN
8AzQNrP5C1kxNgqgA2AqcCHgNHBfONcKhzeLDDA4VkYDYTrnOd44VgyCIEgkUB7xBJADKbAa51tT
TVRQOqUa5y49lkBkMGFkLRC0ci0jMHUigArALi/xfl05fzqNBmACMDu/PMtNJy4RHXApsEp1LRAg
MkI5KbAxOTk4HQA68jBHAEFNQa86jTSQQ+8NPMsnC4ACEHJtaXgGLTYQGyBAaWl1ZzEgkHJnJ0ef
Qr51Ym5qIdFJvzzLUyHxHiFQawNgIHBkCHBlNN814zO+NjdXFCIaczdROGVIB0D/FZAbjAqFJsMm
4S3RGyBRg/snEVIELjOtWe9a/1wPOUg7CoUFAGUqYVhYJwFfdVZwRfAqcF8HcHAVoSgeKRuMDbEL
gB3AaSxqESJQTlQ7G4xUUkFAQ0UgT0ZGYiZTAEVUIERFQlVHyTtgSUxjUFRPS4AgR/YnYiZjFU5i
LSdQBUBh0P49RsBiJkvBXlARsCrgCHD/GsBLwSjBJ1A4oSpwGyAE8L0RwGwqcAXAC4Ag8Wlo4H8D
YSvQX/MKhWzBBpBrgT7fRsA2UCLRHjBrkDxtYm2Q3SqxbmxobMIdsGcLgDGS/mtiJm8lX3Rr9SjB
al1oQP1h0HcqwDHBaXEWACKxJFH/aXJwTS/xS/AsMXAfZ9dh0N4raFhswQnwbdFmCoV4wv9o9VZt
IFIkQRCwG4x4wlhn/1kPfn9/j4CfXR9JgC4AHKR/BCBPgB0ST4AGYAVADbBi/0ygaOADEB3AHbBo
8iYDHvHdG4xJJGAiYCdQYR4QKqP/hWWDcFJtPVIYMYNxIVAFQP9v0SBBAIAA0BswAiBWXSJgvxHA
hzEhUCLRA+AkISEyHTJUEcBuayvCHyBkdv8AcCBwVf+GcyGBJCE9kQLwz0ZQHxBF8AQgRGUgsGqx
2xjhHjBXahAgAGUbESQhWwPwCyAgLZEnQWkdsWn/EbAbfXXSA1CRkC4gNhARsMsjEDLwcgxwJ2R5
FgqFPxrnPYd975mfmq85OUFu7y1wLiCRASjRdAPwJkAnUGUFwERAZSBCQPQTcEcfYqZqECIxIkBP
gDA2OQlGgDYzNHAgNzgz+Qp2RU0LcAMgT4A/L0A/f0FDUt83Vxo1OFYKhRUhAAGngAAAAwD9P1ID
AAADACYAAAAAAAMANgAAAAAAHgAxQAEAAAAJAAAAVEJFUk5IQVIAAAAAAwAaQAAAAAAeADBAAQAA
AAkAAABUQkVSTkhBUgAAAAADABlAAAAAAAIB+T8BAAAAQwAAAAAAAADcp0DIwEIQGrS5CAArL+GC
AQAAAAYAAAAvTz1XSUkvT1U9UEQvQ049UkVDSVBJRU5UUy9DTj1UQkVSTkhBUgAAHgD4PwEAAAAP
AAAAVG9kZCBCZXJuaGFyZHQAAB4AOEABAAAACQAAAFRCRVJOSEFSAAAAAAIB+z8BAAAAQwAAAAAA
AADcp0DIwEIQGrS5CAArL+GCAQAAAAYAAAAvTz1XSUkvT1U9UEQvQ049UkVDSVBJRU5UUy9DTj1U
QkVSTkhBUgAAHgD6PwEAAAAPAAAAVG9kZCBCZXJuaGFyZHQAAB4AOUABAAAACQAAAFRCRVJOSEFS
AAAAAEAABzDgKYgftKO9AUAACDBQ/jxktaO9AR4APQABAAAABQAAAFJFOiAAAAAAHgAdDgEAAAAR
AAAAU3RvcmVkIFByb2NlZHVyZQAAAAALACkAAAAAAAsAIwAAAAAAAwAGEJgv+IsDAAcQtwQAAAMA
EBAAAAAAAwAREAEAAAAeAAgQAQAAAGUAAABDSFJJU1RJQU4sWU9VUkVSUk9SNjg3Kk1BWSpCRVNP
TFZFREJZSEFSRENPRElOR0FQQVRIKElFL1RNUC9UUkFDRU9VVClUT0FLTk9XTkRJUkVDVE9SWUlT
UEVOVEFORU1CQVJSAAAAAKhJ
------ =_NextPart_000_01BDA3B5.643CFE50--