+ New Ticket

Aginity Script

Comments

4 comments

  • Official comment
    Avatar
    Sergey Polshvedkin

    Hi Alan,

     

    That`s correct - there is no possibility to write the header now.

    This feature is in our backlog already.

    Cannot say when it appears in the product but we release a new version every 2 weeks.

    So, keep using the product and don`t miss new updates and one day this feature will be there.

     

     

    Comment actions Permalink
  • Avatar
    Sergey Polshvedkin

    Hello Alan,

     

    Could you please provide some details like a version of product, the platform you are trying to connect and actually a script, if possible?

     

    Regards,

    Sergey

     

    0
    Comment actions Permalink
  • Avatar
    Alan Beattie

    Hi Sergey,

    Using Aginity Pro 0.17.281

    Greenplum connection

     

    Example script is:

    #+sql
    :output file
    :path 'c:/users/alan/desktop/backlog_list'
    :delimiter ','
    :null_value 'NULL'
    :quote_char '"'
    :overwrite true
     
    #+begin
    SELECT
        i.pyid , substring(i.workbasket,1,2) as market , i.workbasket , i.pyfrom , i.pyto

    FROM
    interaction_main i

    WHERE
    i.pystatuswork = 'Open' and substring(i.pyid,1,2) = 'I-' and substring(i.workbasket,1,2) is not NULL and substring(i.workbasket,1,2) <> 'TX'

    ORDERBY
    market, i.workbasket, i.pyfrom
    ;
    #+END

     

    0
    Comment actions Permalink
  • Avatar
    Jonathan Sabah

    Hi Jeff Schlitt,

     

    Coud you please update the documentation https://aginity-documentation.readthedocs.io/projects/aginity-pro/en/latest/docs/Query_Panel/using_panel/#executing-to-a-file to include the ability to add the column headers, and how to compress to Zip?

    Thanks

    Jonathan

    0
    Comment actions Permalink

Please sign in to leave a comment.