Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    6

    Unanswered: recordset is not updatable

    Where can I find the rules for joining tables so that I can add new information via the query?

  2. #2
    Join Date
    Jan 2003
    Location
    Wellesley, Massachusetts
    Posts
    3

    Re: recordset is not updatable

    Originally posted by ehollis
    Where can I find the rules for joining tables so that I can add new information via the query?
    If you're using Natural for DB2 use the JOIN option of the SELECT clause - works every time. Natural for DB2 is 100% ANSI compliant in regards to the SQL syntax.
    If you're using Natural/ADABAS all you need to do is link the primary file via a similar descriptor (key) on the secondary file - data from both are available in the processing loop for either the major loop or minor loop.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •