Results 1 to 4 of 4

Thread: DML and DDL

  1. #1
    Join Date
    Dec 2003
    Location
    India
    Posts
    7

    Unanswered: DML and DDL

    Hi,

    When I run DML commands (insert, update, delete) from my dbaccess
    it is not prompting me to commit or rollback when I come out of dbaccess.

    Where as when I run DDL commands (create, alter, drop) it is prompting for commit or rollback.

    Can anyone justify the above.

  2. #2
    Join Date
    Nov 2003
    Location
    Mumbai, India
    Posts
    92
    Hi,

    I, too have noticed this behaviour of dbaccess for DDE and DML.
    Apparently, dbaccess precedes DDEs with begin keyword. If you need the dbaccess to prompt you for your DML for Commit/Rollback, you need to start block of SQLs with "BEGIN ;" sql statement in the dbaccess -> Query-Language option.

    Regards,
    Shriyan

  3. #3
    Join Date
    Dec 2003
    Location
    India
    Posts
    7

    DML and DDL

    Hi Shriyan,

    That's ok, but what's point in prompting for commit or rollback when we issue any DDL statement ???

  4. #4
    Join Date
    Nov 2003
    Location
    Mumbai, India
    Posts
    92
    Hi Mathavakrishnan,

    You will agree a point that DDLs are not used on every day basis, hence creation of an object are done after a long planning, strategy and diligence. As you know in DB-Access after the completion of operation it prompts for Build & Discard "ring" menu, if you select Discard, you may have noticed that, it does not prompt for Commit/Rollback, But only ask for it if you have opted for Build the object prompt.

    This way It gives an opportunity to reverse your effects in case if you wish; since any such change may backfire if not logically proper to a domain requirement. It's your last resort to keep the original object unaffected.

    By the way, dbservers supports DDL statements with transactions. Like:
    begin;
    create table tab1 (f1 char(1));
    rollback

    Regards,
    Shriyan

Posting Permissions

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