Jump to content

Los Rouse

Member Since 19 Jun 2003
Offline Last Active Aug 02 2013 11:28 AM

Posts I've Made

In Topic: 010 - function excedes workspace

19 November 2008 - 01:04 PM

We occasionally hit this limitation with Mainframe PRO IV.

Try checking logic zero for large scratch array(s) and, if possible, reduce their size. This has been a ‘quick win’ in the past until we have had time to break the function down.

In Topic: VARDEF - length of @VDTVL

27 June 2006 - 01:02 PM

.. but it's Version 1.8 (MF)! We dont like to waste our money on upgrades here .. :rolleyes:

V5.0 MF is 79 by default also.

Scott, interesting....1.8 MF I guess there was some magic happening at Y2K.

In Topic: ProIV and MQ Series

14 February 2006 - 12:24 PM

Mainframe PRO IV (Version 5) supports MQ as supplied. Maybe none mainframe PRO IV will have MQ support in the near future? It might be worth checking.

In Topic: Slow SQL execution

04 January 2005 - 01:48 PM

As a matter of interest...

On the mainframe it is good practice to use file variables for database calls where possible.

The reason being the PRO IV file layout can be generated from DB2 tables which means the variables precisely match the size/format of the columns. If a scratch variable is defined that doesn't match, say is larger, than the column then the optimiser index or tablespace scans when it might not need to. A big performance killer.

I believe this 'feature' has been fixed in DB2 v8.

In Topic: Proiv Single Developer

28 October 2004 - 04:43 PM

I downloaded Single Developer a while ago and it has been working fine for me - Windows XP Home SP2.

I just received a note from 'The Single Developer Team' saying that the version on the partner site was a beta version and that I should now download the production release. I guess I need to give this one a bash.