Re: Good instructions/hints on using Pro*COBOL on UNIX
From: Tony Damon <bfntd_at_aimnet.com>
Date: 1996/02/21
Message-ID: <4gfid5$mnh_at_news2.aimnet.com>#1/1
Date: 1996/02/21
Message-ID: <4gfid5$mnh_at_news2.aimnet.com>#1/1
Brian M. Biggs (bbiggs_at_cincom.com) wrote:
[request for Pro*cobol tuning hints deleted]
My suggestions would be to set the precompiler options RELEASE_CURSOR=NO and HOLD_CURSOR=YES. This will minimize the creation/destruction of cursors which have a high cost performance wise.
Use array fetches when possible ! The downside is that each column in a select list must be fetched into its own cobol 'table/array' (unless they've improved the pre-compiler recently).
Oracle sells 'guide to the precompilers' as well as a pro*cobol supplement (or they used to).
HTH,
Tony Damon
Received on Wed Feb 21 1996 - 00:00:00 CET