This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
31
Nomads / Hotlink Logic
« on: October 03, 2019, 08:56:42 PM »
Hi All,
In v16.1. I've defined a column in a report view list box as a hotlink in the Format screen in Nomads. The column appears as a hotlink in the panel now, but I cannot work out how to assign logic to process the user clicking on the hotlink, nor can I see any variables changing that I could interrogate in my PROCESS logic even with the list box is set to automatic.
I'm loading the contents on the list box in my own logic, ie I do not use smart loading from a query.
Can someone please help?!?! This looks like an amazing feature that we would love to start implementing throughout our system.
Chris
In v16.1. I've defined a column in a report view list box as a hotlink in the Format screen in Nomads. The column appears as a hotlink in the panel now, but I cannot work out how to assign logic to process the user clicking on the hotlink, nor can I see any variables changing that I could interrogate in my PROCESS logic even with the list box is set to automatic.
I'm loading the contents on the list box in my own logic, ie I do not use smart loading from a query.
Can someone please help?!?! This looks like an amazing feature that we would love to start implementing throughout our system.
Chris
32
Language / Re: Sort File 2GB Limit
« on: October 03, 2019, 08:06:51 PM »
Hi Mike,
Any guidance to the best way to recreate this file to avoid the 2GB limit?
Any guidance to the best way to recreate this file to avoid the 2GB limit?
33
Language / Re: Sort File 2GB Limit
« on: September 26, 2019, 05:46:30 PM »
Hi Mike,
Sorry for the slow response. This was my first forum post since you guys have done away with the mailing list and even though i thought i had set up email notifications I didn't seem to receive on. I'll go play with the settings again.
Here is the *UFI for the original sort file which is almost at its limit.
-------
Keyed file: U:\DATA\DATA.TO\INFSILSTO
Maximum Record size ..........: 0 (Sort file)
Maximum # records ............: (No limit)
Current # records ............: 20852709
Size of key block ............: 4096 bytes
External key size ............: 50
-------
When i convert the file to a VLR using the data dictionary with only the 50b external element.
-----
Keyed file: V:\TEST\DATA\DATA.TO\infsilsto
Maximum Record size ..........: 256 (Variable)
Maximum # records ............: (No limit)
Current # records ............: 20852709
Size of key block ............: 4096 bytes
Record Expansion factor ......: 10%
Total # of Keyed File Segments: 2
External key size ............: 50
----
I'm happy to tweak the settings as you suggest.
Sorry for the slow response. This was my first forum post since you guys have done away with the mailing list and even though i thought i had set up email notifications I didn't seem to receive on. I'll go play with the settings again.
Here is the *UFI for the original sort file which is almost at its limit.
-------
Keyed file: U:\DATA\DATA.TO\INFSILSTO
Maximum Record size ..........: 0 (Sort file)
Maximum # records ............: (No limit)
Current # records ............: 20852709
Size of key block ............: 4096 bytes
External key size ............: 50
-------
When i convert the file to a VLR using the data dictionary with only the 50b external element.
-----
Keyed file: V:\TEST\DATA\DATA.TO\infsilsto
Maximum Record size ..........: 256 (Variable)
Maximum # records ............: (No limit)
Current # records ............: 20852709
Size of key block ............: 4096 bytes
Record Expansion factor ......: 10%
Total # of Keyed File Segments: 2
External key size ............: 50
----
I'm happy to tweak the settings as you suggest.
34
Language / Sort File 2GB Limit
« on: September 23, 2019, 08:54:15 PM »
Hi All,
We have just had a customer hit a 2GB limit on a sort file. We have multi-segmenting enabled and it works for VLR files but i'm guessing not for sort files?
Problem is, if we convert this file to a VLR or EFF, even with a RSZ of 1, the file grows from 2GB to 3.5GB which seems excessive.
Does anyone have any other method to get around this, or am I stuck with just changing the file to VLR across all our systems?
Thanks,
Chris
We have just had a customer hit a 2GB limit on a sort file. We have multi-segmenting enabled and it works for VLR files but i'm guessing not for sort files?
Problem is, if we convert this file to a VLR or EFF, even with a RSZ of 1, the file grows from 2GB to 3.5GB which seems excessive.
Does anyone have any other method to get around this, or am I stuck with just changing the file to VLR across all our systems?
Thanks,
Chris