Pacific Southwestern User Group Conference April 6th, 2006 Change Enhancemant Proposal Dieter W' Sto

1
Pacific Southwestern User GroupConference April
6th, 2006 Change Enhancemant Proposal Dieter
W. Storrdieter.storr_at_latimes.com213-237-6086
2
Agenda

• 5 ADABAS C/Es
• 5 NATURAL C/Es
• Discuss
• Vote to be submitted to SAG RD

3
ADABAS 7.4.4 z/OS 4295

• Enhancement to the ADALOD utility
• Add an overwrite and FMOVE parm, like in the
  ADASAV restore, to allow the DBA to load a file
  without having to delete an existing file first.
• Business Reason This would simplify the load
  making it a one step process rather than the
  current 2-step process. It would still require
  the DBA to code the overwrite, but the DBA
  wouldn't have to run the ADADBS delete step
  first. It would make similar to the ADASAV
  restore.

4
ADABAS 3.3.1 HP-UX 4116

• IDTNAME on UNIX
• Customer wishes to have a feature like 'IDTNAME'
  on mainframe so that he can run different ADABAS
  environment (with same dbid) on same machine
  without knowing each other.
• Like it is done in Natural where it is possible
  to set the names for semaphores and shared memory
  addresses in NATURAL.INI with the parameters
• SHMKEY 0x4e061113
• SEMKEY 0x4e061113

5
ADABAS 3.3.3 SUSE Linux 4084

• Init.Script for ADABAS Database is not created
• Each ADABAS Database should start with a
  Server-Start and should stop while Server-Stop.
•  The entry in /etc/init.d is not available.. No
  Script is created during the installation. This
  feature should be available in future versions

6
ADABAS 7.4.3 BS2000/OSD 4067

• Support for adding a field within a PE group
• Currently the procedure is very complex, if a
  field should be added within a Periodic group
• Decompress with the format parameter, specifying
  all fields of the Periodic group
• Compress again with the new FDT
• There should be a function which generates this
  in the background.
• (Perhaps with Predict involved)

7
ADABAS 3.3.1 WinServer 2003 3988

• Workbench "Stop Users" screen is protected - does
  not allow scrolling
• The purpose of the "Stop Users" screen is to
  monitor the User Queue and to flush users if
  necessary.  
• However, this screen is not accessible (it is
  protected) and therefore one cannot scroll down
  the full list of user jobs to view them. This
  screen needs to remain active even when another
  popup window is active.  
• A Support Request was submitted however I was
  advised that this is how the screen was designed,
  and therefore I need to submit an ER.

8
NATURAL 6.1.1 HP-UX 4307

• Direct Access to UNIX environment variables
• Give NATURAL the ability to access UNIX
  environment variables directly within its own
  syntax without the programmer having to create a
  variable and call the USR1053N user exit to
  populate it.
• Some examplesIF ORACLE_SID 'oraDevl'
  ...WRITE 'The Current ORACLE SID is' ORACLE_SID
  ...
• Business ReasonWould reduce code.

9
NATURAL 4.1.3 VSE/ESA 4256

• Expression as value control in FOR statement
• You cannot use an expression as control value
  within a FOR statement. We wish to use an
  expression as value control.
• The following examples were tested with NAT 6.1.1
  PL 16 / Win XP and NAT 4.1.3 / VSE. Example ?

10
NATURAL 4.1.3 VSE/ESA 4256
0010 FOR with expression 0020 0030 DEFINE
DATA 0040 LOCAL 0050 1 I (N3) 0060 1 J
(N3) 0070 END-DEFINE 0080 0090 FOR I 1 TO
(J - 1) / error 0100 WRITE 'Hello
world!' 0110 END-FOR 0120 0130 END   You'll
receive NAT0027 (Error in value specification)
on Mainframe or NAT0067 (Error in control value
specification of FOR statement) on Windows. ?
11
NATURAL 4.1.3 VSE/ESA 4256
Workaround Define an additional help
variable 0010 FOR with expression 0020 0030
DEFINE DATA 0040 LOCAL 0050 1 I (N3) 0060 1 J
(N3) 0070 1 HELPVAR (N3) ? 0080
END-DEFINE 0090 0100 HELPVAR J - 1 /
additional 0110 0120 FOR I 1 TO
HELPVAR 0130 WRITE 'Hello world!' 0140
END-FOR 0150 0160 END
12
NATURAL 6.1.1 Windows XP Prof. 4223

• Application workspace - "passive reference" for
  object usage.
• Right clicking on a module in Application
  workspace (and perhaps also in library workspace)
  should give a context menu with a kind of passive
  reference giving a list of all Applications where
  the specific module is linked.
• Similarly a context menu on a Base application
  should reveal which Compound applications
  reference this specific Base application.
• Business ReasonApplication overview ! Users are
  still a little unsure to the usage of Application
  view. If a large organization starts using
  application they will need tools to get an
  overview of which modules belong in multiple
  applications.

13
NATURAL 4.1.3 z/OS 4292

• Get rid of messageNAT7732 NDV not installed on
  Natural system file
• We don't have NDV, don't plan to install it, so
  once in the Natural Security Maintenance screen
  if by any chance we select Application we get
  back the message of NAT7732 NDV not installed on
  Natural system file, which has created some
  confusion among users. Is there a way to get rid
  of the Application select field? Or how about
  telling us the name of this map/window being used
  for NSC so we can remove is our self.
• Business Reason Natural new version testing
  results came out negative cause user thought it
  was an error after reading the detail message.

14
NATURAL 4.1.3 z/OS 4322

• Apply save sets to other libraries.
• With SYSMAIN/NATLOAD/NATUNLD it is only possible
  to use a save set with the library it was created
  for. A set of objects may be copied/moved through
  a series of libraries during testing/implementatio
  n and it would be useful to use a save set of
  objects created in one library, in another
  library so the same objects get acted upon. At
  the moment a new save set for each library has to
  be created. This could be time consuming and
  there is great possibility for error.