devxlogo

Outputting query data to a file

Outputting query data to a file

Question:
I am trying to list out the contents of a field, and there are so many, that I need to send the output to a file. Can you tell me how to do this? I am using a select statement to get the data out of a certain field.

Answer:
Just remember that someone will still have to interpret the output if it is to be of any use. :-)You can run isql from the command line and specify both an input file and an output file. To see all the syntax of the parameters type isql /? ( In version 7, osql is preferred)

devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist