HP 3000 Manuals

Answers [ HP ALLBASE/4GL Developer Self-Paced Training Guide ] MPE/iX 5.0 Documentation


HP ALLBASE/4GL Developer Self-Paced Training Guide

Answers 

Answer 1.  Alphanumeric variables are initialized to spaces.  Numeric
variables are initialized to zero.

Answer 2.  Variables and application titles.

Answer 3. 

KSAM Developers and HP TurboIMAGE/iX Developers Only:  19111 is the file
error returned when a record cannot be found.

HP ALLBASE/SQL Developers Only:  60110 is the file error returned when
the beginning or the end of a table is reached.

Answer 4.  A2, B4, C5, D3, E1.

Answer 5.  For KSAM and HP TurboIMAGE/iX files, use FILE *WRITE filename
or FILE *INSERT filename.  For HP ALLBASE/SQL tables, use FILE *INSERT
tablename.

Answer 6.  For KSAM and HP TurboIMAGE/iX files, use FILE *WRITE filename.
For HP ALLBASE/SQL tables, use an SQL logic block with the following
command:

     UPDATE tablename SET
        field_spec     = :F-field_spec.tablename,
        ............., =
        ............., =
        ............., =
     WHERE CURRENT OF sql_block_name;

Answer 7.  For KSAM and HP TurboIMAGE/iX files, use FILE*DELETE filename.

For HP ALLBASE/SQL tables, use an SQL logic block with the following
command:

DELETE FROM tablename
   WHERE key_field = :F-field_spec.tablename;

You can also delete an HP ALLBASE/SQL record by using a SELECT command, a
FILE *NEXT command, and a FILE *DELETE command to declare and open a
cursor, position the cursor, and delete the record.

Answer 8.  If the screen field is a dictionary field, then the validation
range name is specified in the dictionary during field specification
definition.

If the screen field is not a dictionary field (that is, it has not been
defined as a field on the field specification screen), the table name can
be specified on the screen field details screen.



MPE/iX 5.0 Documentation