change the number of rows deleted using DB UNLOAD

[Shravani Vedantham]

Hello All

I am currently running the DB Unload process and it is working fine, but it deletes only 1000 rows at a time. It is running against MELD table.

Can I increase from 1000 rows and if yes, Where can I specify number of rows to be deleted?

AE Version - 12.0.1

------------------------------
Thanks Shravani
------------------------------

[Shravani Vedantham]

This is the SQL i see when the unload is running. no idea where it is coming from

select Meld_Idnr from Meld where Meld_DeleteFlag = 1 and Meld_client = 100 and rownum <= 1000'​

------------------------------
Thanks Shravani
------------------------------

[Tim Quakulinsky]

Hi Shravani,

please have a look at the documentation: https://docs.automic.com/documentation/webhelp/english/AWA/12.0/DOCU/12.0/AWA%20Guides/help.htm#AE_AWA_Source/Administration/ucabjq.htm
The parameter "reorg_chunk_size" in [REORG] should do the job.

Good luck,
Tim

------------------------------
Automation Evangelist
Fiducia & GAD IT AG
---
Mitglied des deutschsprachigen Automic-Anwendervereins FOKUS e.V.
Member of the German speaking Automic user association FOKUS e.V.
------------------------------

[Shravani Vedantham]

​Thank you Tim. After I posted here, I was going through the documentation and found the same. Glad its the same. Trying now.

------------------------------
Thanks Shravani
------------------------------