User bio
404 bio not found
Member since Oct 13, 2016
Posts:
show all 1
Replies:
show all 21
Manel Trèmols · Sep 3, 2024 go to post

Hi Richard,

Parameter 1 is namespace where routine1 is.

Parameter 2 is routine1 name

Parameter 3 is namespace where routine2 is.

Parameter 4 is routine2 name

Parameter 5 is global where differences are saved.

If you want to compare same routine in different servers, you should use ECP for to see the other namespace.

Syntax for to call it:

USER>do##class(%Library.Routine).RoutineCompare("USER","routine","TEST","routine","^x")
 
USER>d^%GFor help on global specifications DO HELP^%G
Global ^x^x(1)=$lb("","","+372",$c(9)_"; New comment")

I think it would be better to have a small front-end that connects to a server1 and export routine1, connets to server 2 for to get routine2 and then compare both text file using any compare program like Beyond Compare 4

Regards

Manel

Manel Trèmols · Jul 18, 2024 go to post

I guess script getting wrong time has a set $ztimezone=5 or -5 somewhere, this will change $horolog only for this process

Manel Trèmols · Jun 12, 2024 go to post

Hi Steven,

You can user the CONCAT function

select OEORI_Date, OEORI_TimeOrd, OEORI_UpdateDate, OEORI_UpdateTime, DATEDIFF('n',{fn CONCAT({fn CONCAT(OEORI_Date,',')},OEORI_TimeOrd)},{fn CONCAT({fn CONCAT(OEORI_UpdateDate,',')},OEORI_UpdateTime)}) from SQLUser.OE_orditem
Certifications & Credly badges:
Manel has no Certifications & Credly badges yet.
Followers:
Manel has no followers yet.
Following:
Manel has not followed anybody yet.