Sounds like you are getting some good advice. I am on UniData, but I would do is a quick ISTAT filename and see what that looks like and then run guide against the file. It could be on extreme Overflow, also when attempting Selects and such monitor the temp space file it creates and see how large that gets and if it fails.
Good luck.
Sent from my iPhone
On Sep 9, 2022, at 3:32 PM, Neil Morris via Rocket Forum <
mail@forum.rocketsoftware.com> wrote:
CAUTION: External Sender
________________________________
Is the SELECT doing any sorting or just the selection criteria based on the date? Just wondering if the UVTEMP space might be having a problem. So... -posted to the "Rocket U2 | UniVerse & UniData" forum
Invite your colleagues to join the Rocket Forum and grow our expert network.
________________________________
[Rocket Software] <https: community.rocketsoftware.com="">
Rocket U2 | UniVerse & UniData<https: community.rocketsoftware.com/forums/forum-home/digestviewer?communitykey="dd45d00d-59db-4884-b3eb-2b0647af231b">
Post New Message Online<http: community.rocketsoftware.com/participate/postmessage?groupid="49">
Invite your colleagues to join the Rocket Forum and grow our expert network. Share this link.<https: community.rocketsoftware.com/register="">
Re: 35GB File Help<https: community.rocketsoftware.com/discussion/35gb-file-help#bmf7b7cae2-68c0-4a19-8db9-944576560a0b="">
Reply to Group Online<https: community.rocketsoftware.com/forums/all-discussions/postreply?messagekey="f7b7cae2-68c0-4a19-8db9-944576560a0b&ListKey=1daf02a1-f0f0-4a5c-a95d-a2b9f11dcf4b"> Reply to Group<mailto:
rocket_universe_f7b7cae2-68c0-4a19-8db9-944576560a0b@connectedcommunity.org?subject=re:%2035gb%20file%20help>
[Neil Morris]<https: community.rocketsoftware.com/network/members/profile?userkey="c6fd2c93-5160-4efd-b570-fd195fb1353c">
Sep 9, 2022 3:33 PM
Neil Morris<https: community.rocketsoftware.com/network/members/profile?userkey="c6fd2c93-5160-4efd-b570-fd195fb1353c">
Is the SELECT doing any sorting or just the selection criteria based on the date?
Just wondering if the UVTEMP space might be having a problem.
So the SELECT just never finishes but there are no obvious error messages?
------------------------------
Neil Morris
Universe Advanced Technical Support
Rocket Software
------------------------------
Original Message:
Sent: 08-27-2022 11:44
Original Message:
Sent: 9/9/2022 3:33:00 PM
From: Neil Morris
Subject: RE: 35GB File Help
Is the SELECT doing any sorting or just the selection criteria based on the date?
Just wondering if the UVTEMP space might be having a problem.
So the SELECT just never finishes but there are no obvious error messages?
------------------------------
Neil Morris
Universe Advanced Technical Support
Rocket Software
------------------------------