Jump to content


jcjones

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

Topics I've Started

Sub Reports

15 November 2007 - 09:03 PM

PROIV Version 5.0 - Green Screen - Native Development - Linux Platform

How would I go about making a sub report inside of a report?

I have a report that reports on data from a temp file, but where I have control breaks I need to have a small sub-report with detail data from another temp file to display detail totals.

Thanks in advance for any help :)

PROIV Developer with System Administration Experience

08 May 2007 - 01:59 PM

We are seeking a PROIV Developer with native development experience. This position also includes System Administration duties. Experience with Linux and Windows administration required. This is a mid-level position in a fast paced and growing IT department.

PHP, MySQL, C, C++ experience a plus.

This is a full time position in Denver, Colorado (US) with benefits. Salary DOE.

Send resume and salary requirements to jcjones@yourwish.com.

File read performance

07 May 2007 - 11:00 PM

Native development, pro-isam file question.

I have a history file that I'm generating reports from. The file is over 2.5 million records long and has 4 key fields.

I am using SEL-ONLY on the first key field in the default logic of an LU and processing other fields in the after read no error logic.

The problem is that PROIV works on reading this file for over 25 minutes before it actually gets to the after read no error logic. The SEL-ONLY is working becuase only records with the desired value in the frist key are being read, but why does it take so long to get to reading the correct records from the file? Generally file access is very fast, and screens that display data from that file run quickly without even using the keys. Is there something else that I need to do to improve the performance of reading this file?

Greenscreen - report (LR) and skipping lines

24 July 2006 - 09:01 PM

Hi,

I have a report function which is very simple, it just reads a temporary file created by an LU, sorts and breaks the output (Control Break). It does look up other information from other files, but this primary file is the file that all of my Control Breaks and logic are executed on. However, there are several records in this file that I need to process completely for summary purposes, but I don't want them to print on the report. Is there a way in the logic that I can skip printing individual records, but still process them. I have tried using a conditional DSEL in the before read of the last file that of the LR, but this skips anything remaining in the primary file until the next Control Break is encountered. I've tried looking in all the manuals that I can find any reference to printing in, but cannot find how to simply not print a single record.

Any help would be greatly appreciated.

Thanks
JC

File read in LS with unknown key field

24 May 2006 - 07:29 PM

I have a file with 4 key fields, and several data fields after that. In an LS that just looks up bits of data from various files based on user input, I need to read a record from this file, but I do not know one of the key fields. Is there a way to tell PROIV to read the first record that matches the data I do know?

For example:
Key field 1 : known
Key field 2 : not known
Key field 3 : known
Key field 4 : known
field 5 : not known
field 6 : not known
field 7 : known

How would I handle this in the file Before Read function to tell it to just read the first record that matches fields 1,3,4 and 7, ignoring the fact that I don't know the value for the key field 2? And if this is possible, for future reference, how might I do the same thing if I only knew 1 or 2 of the 4 key fields?

Thanks,
JC Jones