>Hi Tamar,
>
>
> insert into ERRORLOG ;
> (DATE, TIME, USER, TERMINAL, CUSTOMER, ALIAS,;
> RECNUM, KEYFLD, ERRMSG1, ERRMSG2, ERRMSG3, ACTION, ;
> MEMVARS, DETAILS, CALLSTACK) ;
> values ;
> (date(), time(), gcUSER_NAME, SysZero(), space(len(customer)), lcALIAS, ;
> lnREC, lcKEY, lcLINE1, lcLINE2, lcLINE3, 'REBOOT',;
> '', m.lcDetails, m.lcStackInfo)
>
>
>- Could SysZero() change alias() or insert a log row itself or otherwise interfere with the insert midstream?
>
Nope, SysZero reads one environmental variable (GETENV()) and cleans up and returns the result.
>- and -
>
>Does space(len(customer)) rely on selected alias? If it's a variable, try with mdot or what happens if you replace with "" ?
Nope, Customer here is a field in ErrorLog, so just inserting an empty value there. Guess I could try just the empty string. (Inherited code, and policy through the app is to use space(len(field)) for empty values, but certainly makes no difference here.
The weird thing, of course, is that all this is working for everyone else, so it has to be something local.
Tamar