SAS Note V6-ACCIDM-F953

From: tsdlist@UNX.SAS.COM
Date: Wed May 12 1999 - 07:20:18 EDT


>>>>>>>> SAS Notes -- Copyright (c) 1991 - 1999 by SAS Institute Inc. <<<<<<<<

V6-ENGINE-F953 *** ALERT NOTE *** PRODUCT: ACCIDM
                                                        PROCEDURE: ENGINE
TITLE: IDMS numeric field defined as 9(16) COMP converted to missing

KEYS: IDMS ENGINE ACCESS MISSING VALUE NUMERIC DICTIONARY LARGE COMP USAGE

    A data field defined to the IDMS IDD (Integrated Data Dictionary) as
    binary (USAGE IS COMP) with a length of 8 bytes in order to store
    numeric values with the number of digits > 9 but <= 18 is being
    converted to a missing value by the SAS/ACCESS Interface to CA-IDMS
    engine conversion routines. The IDMS DBMS allows for 8 byte binary
    field definitions but the SAS System is encountering problems
    trying to convert these numbers to a double precision float.

    Currently there is no circumvention or solution to the problem other
    than to redefine these fields to the IDD as float.

+------REPORTED------+ +---FIXED---+
SYSTEM RELEASE LEVEL RELEASE LEVEL

MVS 6.08 TS420



This archive was generated by hypermail 2b29 : Mon Jan 10 2000 - 10:10:19 EST