Db2

 View Only
Expand all | Collapse all

Is there way to not have a column title row?

  • 1.  Is there way to not have a column title row?

    Posted Thu April 29, 2021 10:29 AM

    Our customer wants to be sent a csv with no bells and whistles - just the data.

    I can blank out the column titles but can't find a way of removing the row altogether. Is it possible?

    Many thanks,

    Thomas






    #Db2
    #Support
    #SupportMigration


  • 2.  RE: Is there way to not have a column title row?
    Best Answer

    Posted Thu April 29, 2021 04:18 PM

    Hello Thomas,

    sorry because I don't know how to do that with csv output format.

    But just in case that could help, if you blank out the column titles (with '' in title of each column), with HTML and Excel (xls or xlsx) format, the title row doesn't appear in result as expected.

    Gautier






    #Db2
    #Support
    #SupportMigration


  • 3.  RE: Is there way to not have a column title row?
    Best Answer

    Posted Fri May 07, 2021 08:11 PM

    Thomas,

    The best solution would be to replace the column titles with a space, as you did. This will still create an empty row in the CSV, but unfortunately there is no way to remove that row entirely.






    #Db2
    #Support
    #SupportMigration


  • 4.  RE: Is there way to not have a column title row?
    Best Answer

    Posted Mon May 10, 2021 08:14 AM

    Hi Ann,

    Many thanks for your response. Luckily the customer seems to have accepted the blank row.

    Kind regards,

    Thomas






    #Db2
    #Support
    #SupportMigration