SAP HANA : A Developer’s Database [Part 3]

    By: Paul Vero on Oct 01, 2013

    This month I wrap up my HANA series with more concepts related to development on the HANA system. For part three I want to cover more database objects, the sequence, sql view and SAP HANA specific views: Attribute, Analytic and Calculation views. In a later article, I will cover SQLScript, OData and Server-side JavaScript development. The database objects to cover are sequences, SQL views and HANA specific view types.

    Sequences
    A sequence is a database object used to generate an incremental list of numeric values in ascending or descending order. Applications use sequences to reference sequence objects, generate primary key values, identify rows and columns and coordinate keys across the data. In typical HANA fashion these are design-time objects and they are transportable to other systems (they are a flat text file when created). The suffix used for the file is, you guessed it: “.hdbsequence”. Once your file exists, you commit/activate it in the Repository to create the actual runtime object in the catalog.

    Login to read the article. Not a member? Create a free account!

    Read Part 1.

    Read Part 2.

    Released: October 1, 2013, 10:15 am | Updated: January 27, 2014, 6:25 pm
    Keywords: HANA Article | Technical Journal | Development | HANA | Paul Vero | SAP Development Platform


     

     

    TwitterLLinkedinLFacebook

    Copyright © 2014 ISUG-TECH. All Rights Reserved
    All material, files, logos and trademarks within this site are copyright their respective organizations

    Terms of Service - Privacy Policy - Contact the Help Desk