thx. I wasn't sure this works also for IRISTEMP
- Log in to post comments
thx. I wasn't sure this works also for IRISTEMP
There is some 'silent' period during the night.
Actually, a snapshot (~380 GB) is taken during a Freeze-Thaw window, Which is not really RO.
the format ./IOTABLE="CP1252" applies only using the OPEN command
$ZCONVERT and %Stream.FileCharacter just use "CP1252" just by the name
In namespace %SYS you have a utility NLS that shows your installed conversion table and its short names.
%SYS>d ^NLS
2) Select defaults
2) I/O tables
Items marked with (*) represent the locale's original default
I/O table Current default
--------------------- --------------------
1) Process RAW (*)
2) Cache Terminal UTF8 (*)
3) Other terminal UTF8 (*)
4) File RAW (*)
5) Magtape RAW (*)
6) TCP/IP RAW (*)
7) System call RAW (*)
8) Printer RAW (*)
I/O table: 4
1) RAW (*) 2) UTF8
3) UnicodeLittle 4) UnicodeBig
5) CP1250 6) CP1251
7) CP1252 8) CP1253
9) CP1255 10) CP437
11) CP850 12) CP852
13) CP866 14) CP874
15) EBCDIC 16) Latin2
17) Latin9 18) LatinC
19) LatinG 20) LatinH
21) LatinT
So you see the shortnames but no Latin1 but CP1252 which is almost identical.
the related problem is described here:
https://www.i18nqa.com/debug/table-iso8859-1-vs-windows-1252.html
"ISO-8859-1 (also called Latin-1) is identical to Windows-1252 (also called CP1252) except for the code points 128-159 (0x80-0x9F). ISO-8859-1 assigns several control codes in this range. Windows-1252 has several characters, punctuation, arithmetic and business symbols assigned to these code points."
and Encoding Problem: ISO-8859-1 vs Windows-1252
So you should check what your customer really does (some hide the fact they use Windows)
The appropriate table can be used in
SUPER ! ![]()
![]()
![]()
![]()
![]()
![]()
![]()
![]()
![]()
![]()
Robert
Sorry! That doesn't indicate any reason. $zf(-1) is just a spawn.
I just verified:
If this record is
Property Record as %STRING;you can use 2 calculated properties
/// true if Header/Trailer
Property HeaderTrailer as %Boolean [Calculated,SqlComputed,
SqlComputeCode = { set {*} = $extract({Record},1,20)?20" " } ];
/// make integer, 0 for Header / Trailer
Property RecordType as %Integer [Calculated,SqlComputed,
SqlComputeCode = { set {*} = $extract({Record},21,23)\1 } ]; @Mike Minor
I just installed a full instance on WIN10. boooooring slow!!
If you don't disable AutoStart @ Boot in the config Win reacts rather confused.
Especially if your drive has changed by dynamics from F : -> D: or similar.
In addition, a lot of info is saved in Win-Registry. ![]()
Overall performance is not a thrill but acceptable
Next trouble: Dismount of the flash drive. Painful
My strong recommendation: Use a Docker container instead. Example here CrossECP-Cache
Then you are really mobile and fast
using LOG^%ETN gives a full stack trace. without breaking the process
you just have to place it into your code at the critical points.
https://docs.intersystems.com/iris20201/csp/docbook/Doc.View.cls?KEY=GCOS_errors#GCOS_errors_log_etn
Instead of the double $ZF() I'd suggest using the query in Library class %File.
set rs=##class(%ResultSet).%New("%File:FileSet")
do rs.Execute(SDIR,"*",1)
while rs.Next() { write !,rs.GetData(1) }Let's analyze this: [leaving aside that $Zf(-1 .. is Deprecated)
To verify what's really happening run fg,fg1,fg1,bg (JOB ), bg1,bg2
So they both can't influence each other.
You may use this at init time
https://openexchange.intersystems.com/package/helper-for-objectscript-language-extensions
to add your ZPM command and function. It does a unique insert of the label
When I was Software Support Manager @ Digital Equipment Corp. in a former life
in the previous millennium we had 2 basic rules graved in stone:
I won with my team the annual European customer survey competition
over several years in sequence.
@Vic.Sun. your reaction is - to formulate it politely - a disappointment.
But no surprise to me.
I miss a button "Excellent Answer" in the community
I understood that 14 licenses + Grace Period are your biggest pains.
In past, I decreased the risk by moving ALL (suspicious) connections to a dedicated User
observing his maxConnection limit using %CSP.Session.Login() especially this explanation:
This can't avoid a DDoS attack but it limits the initial impact and allows you to
protect some emergency licenses.
[As I know the inventor of Grace Period since it was rolled out with a lot of pain for customers
I'm not willing to discuss this "feature" in public again]
Yes, pls. share!
I always liked to see not just the ONE and ONLY solution but a choice.
as you are in SMP anyhow just try to do an insert manually.
Just 1 row.
you seem to require something else <UNDEFINED>
in addition, if your record exists already You may need an
INSERT OR UPDATE (if this is possible in postgreSQL)
It could be OK, but I wonder that you insert just 1 value
Eventually, there is something required that is missing?
Check the definition of the generated Caché class,
Seems just a typo in INSERT statement.
Target Columns must be in parenthesis.
INSERT INTO HSIPIData.datos_usarios2 (addresses)
SELECT Addresses FROM HSPI_Data.patient
This article and the related example in OEX may be helful.
Effective use of Collection Indexing and Querying Collections through SQL
eg. with SQL:
INSERT INTO... Linked_Table Select ...from Cache_Table
as described in docs
you are mixing up 2 things:
so the LINKED describes the structure that is used by generated SQL statements
to work on postgreSQL. Take a look at the storage definition of the class
and see the difference.
But your code in Cache acts as if data were local !!
Either by Objects or by Tables.
if you issue a %Save() on the class it runs a INSERT OR UPDATE undercover.
a few simple steps.
a nice description of what a sub-select does preparing the resultset
similar to the proposal of @Timothy Leavitt you use a Sub-Select for sorting
and do the output in the outer SELECT
SELECT Name, SSN, Home_State, Home_Street, Age, Company, DOB FROM (
SELECT top all * FROM Sample.Person
order by ID desc
)
As you use Caché you may try in Namespace SAMPLES
In a recent example I posted, I had the need to extend the naming and proposed folder structure
It was obvious if you were reading the downloaded repository.
The related article was an advertisement and a "heads up" that it just wasn't the default structure as usual.