All
Accepted answers
Robert Cemper 路 Oct 26, 2023 go to post

Simplified:
WIJ is the on-disk image of your modified buffers.
If buffers are changed they get updated on-disk by an asynchronous background process.
The modified date is typically the last modification at file close.
writing modification date at every file update as you expect will break every file system.

Transposing your expectation to a text editor would mean to update the file and date at every new line:
I suppose you would be disappointed by the related performance reduction.
Though, from personal experience, this seems to be the standard operating style of almost every government.馃槈

Robert Cemper 路 Oct 26, 2023 go to post 
n i f i=1:1:20 w !,$$save(file,glob) s id=^TEST zw id

it looks like magic and the issue is independent of Global name
for testing, I would suggest this extension to the loop.
zw also shows any $Lb() in readable format
6, 7, seem to break sometimes ??

Robert Cemper 路 Oct 26, 2023 go to post

after I called the label a second time

pls. check ^TEST or ^TEST2 before the 2nd call
if it isn't starting with a number it throws <ILLEGAL VALUE>
I see no obvious reason in your code why it should NOT be Numeric.
so in your test loop you may do a "write ^TEST,! " to check this condition   
 

Robert Cemper 路 Oct 26, 2023 go to post

what OS are you working with ?  "C:/temp/file.xslt"

  • this is wrong in Windows >>>   "C:\temp\file.xslt"
  • and wrong in Linux, Unix,, ...  >>>  "/temp/file.xslt"
Robert Cemper 路 Oct 24, 2023 go to post

even deleting the lock from Terminal doesn't seems to work

Whatever you try to express doesn't make sense
Any kind of LOCK  is bound just to the job that executes it
there is just no "UNLOCK" from outside except job termination.

the locking job in your screenshot is 9908
but your terminal is job 10376  
expressed in a picture:
- you try to catch a fly in your room  that is flying somewhere outside the building

Robert Cemper 路 Oct 23, 2023 go to post

Part of it (KILL, SET, TSTART, TCOMMIT, TROLLBACK) by global by process can be traced by examination of JOURNAL

There is nothing similar for Global READ
  

Robert Cemper 路 Oct 23, 2023 go to post 
ClassMethod Calendar(y As %Integer) As %String
{
 s a=$lfs("Monkey,Rooster,Dog,Pig,Rat,Ox,Tiger,Rabbit,Dragon,Snake,Horse,Goat,Metal,Water,Wood,Fire,Earth") q $li(a,y\2#5+13)_" "_$li(a,y#12+1)
}
Robert Cemper 路 Oct 23, 2023 go to post

great idea::  integers as separators!

just realized the separating blank broke the line in display.

Robert Cemper 路 Oct 22, 2023 go to post

I didn't get the meaning of  Field(ge=0) immediately
I see 6 variants to achieve this in IRIS in order of my personal preference

  1. use SQL NULLIF function
  2. use SQL CASE..END block if more complex
  3. use a custom SQL Function = ClassMethod projected as SQLProcedure
  4. create a TRIGGER if this is not just a single case 
  5. use calculated properties with on Change clause
  6. create a customized  OdbcToLogical method 

There are eventually more options  

Robert Cemper 路 Oct 20, 2023 go to post

First bid:

  • 145 by code checker
  • 35 real code - the rest is text + packing + "cosmetics"
Robert Cemper 路 Oct 19, 2023 go to post

#1)  Subscript > 511 chars is not allowed

#2) your browser broke the CSPCHD token for some CSP page

Robert Cemper 路 Oct 12, 2023 go to post

contact ISC sales, buy an appropriate license, and  you get access to WRC and the Kit repo

Robert Cemper 路 Oct 10, 2023 go to post

If this is your own CSP page you may set  %session.EndSession =1

OR
you have a dummy page that does just this and you call it manually
I did it mostly during testing 

Robert Cemper 路 Oct 10, 2023 go to post
  • <ROLLFAIL>   rollback of any transaction crashed
  • by <FILEFUL>  your DB or JOURNAL can't be expanded

Check available disk space

Robert Cemper 路 Oct 10, 2023 go to post

since the invention of Grace Period by BdK  I'm fighting hanging CSP connections.
my approach:

  •  
     

in most cases, it is sufficient to get free locked licenses

Robert Cemper 路 Oct 5, 2023 go to post

when I worked in Italy and Spain 40+ years back we always went to the cafeteria next door.
They served excellent "caf茅 correto".  
BTW: I'd definetly prefer Sangia over Cold Water
馃構

Robert Cemper 路 Oct 4, 2023 go to post

I assume "water cooler tank" has the same social functionality
as the kitchenette with the common coffee machine in central and northern Europe

Robert Cemper 路 Oct 3, 2023 go to post

Hi @Raj Singh,  @Lorenzo Scalese , @Evgeny Shvarov 

  • I'm fully for developer-to-developer initiatives.
    • though in practice, this is too often developer-to-nirvana 
    •   
  • dark-corner:   
    • several months back I suggested having an ARCHIVE option
    • so that packages stay in OEX but don't show up in the directory 
    • if not explicitly requested similar to SPAM in DC.  
    •  
  • But something like this seems to exist already.
    • My recent update of my OEX web sniffer found 2 packages
    • that do NOT show up in directory.
    • don't ask me how this works but that tool is there somehow.  
    •  
  • The actual critical corners might be identified by a combination of
    • LastUpdate in OEX and pending PR.
    • >>  

 

Robert Cemper 路 Oct 3, 2023 go to post

I suggest to have globals and routines in separate databases.
Keep the routines always local and only use Global DB over ECP for shared access.
The price is you have routines to maintain in 2 instances.