Skip to Content
avatar image
Former Member

Is there any function in BODS to generate a row sequence, but you cann't use Key_Tansfertion transform

How to generate a row sequence (using function) without using Key_Generate transform

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Dec 29, 2014 at 04:20 AM

    Use gen_row_num() function

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 29, 2014 at 08:12 AM

    Use gen_row_num() function.

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 25, 2014 at 08:52 PM

    Use the key_generation built-in function.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 29, 2014 at 07:33 AM

    Use Gen_row_num() built in functions which is available in Data services designer 😊

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 29, 2014 at 08:22 AM

    Use gen_row_num() function for this. This is a built in fuctions of designer. Jst use this in any Query transform and get the row number generated automatically.

    Add comment
    10|10000 characters needed characters exceeded

    • There are gen_row_num() and gen_row_num_by_group() functions that can be used to automatically generate row numbers from a query transform.

      If you are using a roe_generation transform, you can specifiy the number of rows you need and the DI_ROW_ID column will have an auto-generated row number as per the settings specified.

      kind regards

      Raghu