Jump to content


jcjones

Member Since 13 Apr 2006
Offline Last Active Aug 08 2008 10:00 PM
-----

Posts I've Made

In Topic: File read performance

07 May 2007 - 11:23 PM

Joseph,

Thank you very much - this function was originally talking to a different source file which did have sorting, but the requirements of the report changed so it had to deal with the history file and while the sorting parameters were removed, the sort flag was still in place. So, I guess it was sorting the file by nothing, but still sorting the entire file.

I removed the sort flag and now it gets to the requested records immediately. :)

Certainly a "duh" moment.. :unsure:

Thanks,
JC Jones

In Topic: Greenscreen - report (LR) and skipping lines

25 July 2006 - 01:45 PM

Lewis,

Thank you very much - that was exactly what I was looking for.

In Topic: File read in LS with unknown key field

24 May 2006 - 08:47 PM

The file is a ProISAM file.

Since my initial question, I have tried adding an LS to just read through this file with the SEL-ONLY in the default logic for the new LS, having it select all records from the file with the first key. However, it is executing the default logic, and I'm checking the value of key passed in the SEL-ONLY statement to be the correct first key. It does execute the Read No Error function for the file in this LS, but only once and all of the fields that should be read are empty after the read, then it exits without reading another record. I have verified that there are hundreds of records in this file with the requested key. Not sure what it's doing, but I'm still working on it and tracing things out with UMSG statements.

Any help would be appreciated.

Thanks,
JC Jones

In Topic: Strange LU problem - skipping records on read

24 May 2006 - 01:03 AM

Ok, I think the problem with the regen was that there are more then 9999 functions in the gen list when using P\ with no other filters. After going one letter/character at a time (ie: P\A, P\B, .... P\%, P\@, etc.) I finally got through the entire list of functions.

There were around 50 functions and/or reports that would not gen - various errors, including some @ functions.

Do I need to worry about those functions that would not gen if they are not used, or is that an indication of corruption in the bootstraps somewhere?

JC Jones

In Topic: Strange LU problem - skipping records on read

24 May 2006 - 12:18 AM

Thanks Joseph,

When asked to press to start generation, I press return and immediately I get the ? prompt at the top of the screen and the following message at the bottom of the screen: "GENERATION IS BEING PERFORMED FOR SCREEN QUEUE#: 1"

At this point it does not appear to be doing anything, and at the ? prompt I have to enter the name of a function twice to leave that screen. Am I missing something?

JC Jones