How to count rows extracted from MS Sql table

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
cbres00
Participant
Posts: 34
Joined: Tue Sep 21, 2004 9:20 am

How to count rows extracted from MS Sql table

Post by cbres00 »

I'm doing a full extract of all rows from a MS SQL table and then building a flat file from it. I want to delete all of the rows from the table when I'm confident that the number of rows in the flat file are equal to the number of rows in the table.

What would I do to get a row count of the file I created?

Regards,
CB
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

This is a duplicate post.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”