*W* Record ... is not updatable message

Robert Edis robeconsult@sbcglobal.net
Wed, 4 May 2005 16:30:48 -0700 (PDT)


G'day all

I am a bit rusty on PH these days (too much time spent
on the *dark* side) and I am humbly asking for your
assistance. :)

Environment:  WinNT, SQL Server, PH 8.41

Concern:  When trying to create a screen in QDesign I
get the following warning:

Q D E S I G N   (PowerHouse  8.41.D)
Copyright 2004 COGNOS INCORPORATED
Licensed PH8-NT-DEVELOPMENT for customer: XXXXXXXXXX

> set dict f:\cognos\catalogs\manchk.pdc
> screen test html
> file fin_Manual_Checks IN DB_CHK
*W* Record FIN_MANUAL_CHECKS is not updatable.

The database syntax in the PDC uses a SQL Server login
that has full read & write rights in the database
DB_CHK.

> sho rec fin_manual_checks in db_chk
05/04/2005                        ManChk              
           Page    1
                         R E C O R D   R E P O R T
              For DICTIONARY: 
f:\cognos\catalogs\manchk.pdc
    Record:             FIN_MANUAL_CHECKS
    of Database:        DB_CHK
    Organization:       RELATIONAL
    Null Values Allowed:Yes
    Type:               ODBC
    Hold Cursor:        Unspecified
    Open:              
DSN=DB_Chk;UID=##;PWD=@@ASYNC=0@0/0
    Record Size:        1475 Bytes

-- Record Contents --
    Item                                 Type         
  Size  Occ  Offset
...

Why is this record not updatable?  Has it anything to
do with the ASYNC=0 attribute?  If so where do I
change this?

Blue