I am loading a text file and I want to know if there is system global
variable into which stores the current record # from the file being
processed.

If so please let me know method of finding the record #

Thanks
Karen

There is nothing you can get internally AFAIK that would tell you the
current row being loaded. How would expect to use that Row number?

Allan



"karenmiddleol (AT) yahoo (DOT) com" <karenmiddleol (AT) yahoo (DOT) com> wrote

Hi Allan

How do I get the row number is it I need to maintain a global variable
for this.

Thanks
Karen

Hi Allan

How do I get the row number is it I need to maintain a global variable
for this.

Thanks
Karen

Sure you could maintain a GV but what do you want to do with that GV?

Do you intend to add an auto incrementing attribute to the destination?


Allan


"karenmiddleol (AT) yahoo (DOT) com" <karenmiddleol (AT) yahoo (DOT) com> wrote

No all I need the record # is when the record # is a particular value I
want to do a specific processing.

Thanks
Karen

Then sure have a counter.

Wouldn't you be better looking for a feature of the data rather than a
counter though?

"karenmiddleol (AT) yahoo (DOT) com" <karenmiddleol (AT) yahoo (DOT) com> wrote