How to Write One row of dyanamic data from the query result

Raj6778 · Post by **Raj6778** » Mon Nov 12, 2007 5:03 pm

I am trying to write 1 row of query data runtime as a headerline for sequential file, just one row, any suggestions

thx in advance

jdmiceli · Post by **jdmiceli** » Mon Nov 19, 2007 2:21 pm

Is the info you are looking for a count? A single dataset? Can it be defined as a user defined SQL? Does the SQL need to change each time?

These are the first questions that pop to my mind.

Provide some more background and details and we might be able to give you more.

ray.wurlod · Post by **ray.wurlod** » Mon Nov 19, 2007 2:44 pm

Constrain your query so that it only returns one row. Problem solved.

For the rest of the data use a second job, that appends to the file.

DSXchange

How to Write One row of dyanamic data from the query result

How to Write One row of dyanamic data from the query result

Need more info