Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2011

    Unanswered: Lag and Lead Function


    I am wondering what version f INformix Lag and Leafd were introduced? I am currently working on a version of informix which I think is relatively old and have been trying to use Lag and Lead but I get the following syntex error

    Error: A syntax error has occurred. (State:37000, Native Code: FFFFFF37)

    My code is as follows:

    LAG(id) OVER (ORDER BY id) Test,
    FROM a

    Any help on the version of Lag and Lead would be great

    Kind Regards

  2. #2
    Join Date
    Sep 2011
    Pont l'Abbé, Brittany, France
    Provided Answers: 1

    a bit late, I agree. Sorry for that

    Informix has introduced OLAP functions in version 12.10.

    The IBM documentation is a bit 'silent' about them, but there is an excellent presentation of Informix OLAP function done in last years (2014) IIUG Conference.

    If you are registered on the website, you can have access to this presentation called "D14-UnderstandingTheNewOlapFunctionsInIbmInformix.pdf"

    If you are not registered, it's time to do it now, and why not come directly to the Conference this Year in San Diego - CA

    check here too

Posting Permissions

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