Hi Kunduri,
OK, but the output still has the query at the top of the output.
Output for:The fields are not comma separated.
As a result if I open in Excel it does not open with columns separated.
Annoyingly it also has heading under lines "----------------------" below the column names. You may need to delete that row.
To create a workable sheet I have to use Data-Text To Columns and base it on White Space as it is not even tab deliminated.
If your data is VARCHAR and has white space in the value it will split that based on white space too.
Has it been enhanced in 12.2?
Original Message:
Sent: 03-05-2020 02:14 AM
From: KUNDURI Kiran
Subject: DB Query To CSV File Format
Hi,
Can you look at the 'Output File' option in the SQL job type as shown below in color.
Hope it helps!
- Ravi Kiran
Original Message:
Sent: 03-04-2020 03:36 PM
From: David Lock
Subject: DB Query To CSV File Format
Hi Guys,
Can DE Series DB Agent job query a table and format the output as a CSV format without the need to write the query with concatenation || etc.
It would be nice to be able to export the data to a readable format than just the spool format.
Thanks