Start a new topic

Export More than 1 Million Rows

anonymous

started a topic over 8 years ago

[This topic is migrated from our old forums. The original author name has been removed]

Hi! First time poster. I did some research on this but couldn't find a discussion.

I am using the @export function and it seems to be limiting the number of export rows to 1 million. Is this the limit? Can I make it go higher?

Thanks!

1 Comment

Hans Bergsten

said over 8 years ago

[This reply is migrated from our old forums.]

Re: Export More than 1 Million Rows

Hi Kevin,

The @export command does not limit the number of rows in itself, but it is limited by the value in the *Max Rows* field or by the number specified by the *@set maxrows* command, if any. To ensure that all rows are exported, I suggest you use the @set maxrows command in the script, e.g.::

@export on;
@export set ...;
@set maxrows -1;
select ...
@export off;

Best Regards,
Hans

How can we help you today?

Export More than 1 Million Rows

anonymous

Hans Bergsten