Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Good afteroon in my timezone.

I want to update a table , the RDBMS used is the the Sybase ASE 15. Because the table contains almost 1 million rows , and i have to run this update in Production environment, i want to update and commit every 10000 rows.I do not have experience in Sysbase. Can anyone help me, if possible putting some code example

Thanks in advance Best Regards

asked 10 Sep '13, 15:28

tt0686's gravatar image

accept rate: 0%

closed 10 Sep '13, 15:30

Mark%20Culp's gravatar image

Mark Culp

This forum is for questions relating to SQL Anywhere, not ASE. Please refer to the FAQ and ask your question on the SAP ASE forum. (see last question in the FAQ for link)

Having said the above, if I were writing such a program I would simply keep a count of the number of inserts/updates (or bulk inserts/updates since that would be more efficient) and issue a commit every N rows (N equal to 10000 in your case if you are issuing 1 insert/update per request... or 10000/x if you are issuing bulk inserts/updates of x per request).


permanent link

answered 10 Sep '13, 15:29

Mark%20Culp's gravatar image

Mark Culp
accept rate: 41%

edited 10 Sep '13, 15:35

In case you want to make your update via plain SQL and you can distinguish "already updated" and "still to be updated" rows by a simple condition, a simple loop with a UPDATE TOP statement comes handy, such as:

   UPDATE 10000 YourTable SET ... WHERE <not already modified>;
   IF @@ROWCOUNT < 10000 THEN
      LEAVE lbl;
   END IF;

Note: This is in SQL Anywhere Watcom-SQL syntax, however, AFAIK, ASE does support UPDATE TOP..., too, so this could be adapted to T-SQL syntax.

(11 Sep '13, 03:59) Volker Barth
Replies hidden

Sorry, it should read "UPDATE TOP 10000 ...", and I should not post untested code:(

(11 Sep '13, 08:47) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 10 Sep '13, 15:28

question was seen: 3,210 times

last updated: 11 Sep '13, 08:57