Teaches you to grasp the chart from DB2 to delete several lines

Q: "How to remove the chart from a number of DB2 line?"

A: "First, you need to update your" relational "database management system of knowledge. In the chart there is no" top "or" bottom "of the N-line concept. But the result set has the top or bottom of the concept. You can use FETCH FIRST N ROWS ONLY clause to be the beginning of the N-line, but get the bottom of the N-line is a more difficult problem. To achieve this, you need to scroll the pointer. can scroll the pointer allows you to not read / get all the rows in the result set before moving around. I suggest you read the DB2 SQL reference manual and the manual DB2 applications can scroll the contents of a pointer (all DB2 manuals can be online free download). Basically, you should use a scrollable cursor FETCH LAST statement, then FETCH PRIOR loop to N-1 times. that would give any result set "bottom" of the N-line "(classification or unclassified).

If you remove the N from the chart in a row. I guess you will ask how to DELETE a WHERE condition Department subset of the removal of restrictions on line, the answer is no. WHERE in the same condition you have to specify FOR UPDATE OF office to open a pointer, then you need to row in the loop N times to open the FETCH and DELETE WHERE CURRENT OF pointer. Of course, this means that you have to rewrite a program.







Recommended links:



Reduce carbon emissions, EastFax paperless fax you the MORE green the more resounding



AVI to IPOD



CEO Online: Yan Huang Star CEO Chang On August 15 Guest Sina



"Grey Dove" into a small penguin confuse users into a "chicken"



Themes And Wallpaper Shop



software development project feasibility analysis



In SDH / SONET 155M on CARRYING IP packet solution



3GP to MPEG



Management And Distribution Specialist



MKV to VOB



Ubuntu will build a full team in China



Training Into The Domestic Game Breakthrough



CREATE visual impact



Additional team bonus, energy stimulate TEAM

China has announced measures in the United States blocked WAPI appeal to the international organizat

To reverse the adverse situation of competition with international standards, China's national technical standards for wireless LAN security standard WAPI interest groups, the U.S. blocked a fierce struggle was launched. Yesterday, the China Broadband Wireless IP Standard Working Group officially released outside was submitted to the International Organization for Standardization (ISO) of up to 38, listing the American standard block measures camp 49 complaints files.

The Working Group said its April 29 this year to submit the complaint to the ISO file "unfair activities, not the right process, unfair results: on WAPI-11i voting process and procedures for reporting violations of ethics," and on May 18 Supplementary material "WAPI voting analysis and rebuttal comments" (the former 38, the latter 58). The two documents, the Chinese adopt a tough attitude detailed the Institute of Electrical and Electronics Engineers (IEEE) affect the voting process, "immoral behavior" in order to reverse the current competition in the international standard WAPI unfavorable situation.

WAPI is China's proposed technical standards for wireless LAN security, embody our standards for information security strategy and strategic intent. As the security of existing wireless LAN technology supplement proposals, WAPI and American IEEE's 802.11i technology is the leading platform competition with the chance to become an international standard. American Standard behind the Intel-led group of interest group support, and therefore the international standard WAPI way towards being the unscrupulous block.

March 7 this year, the relevant part of the end of voting, members of the body of 30 countries to vote against WAPI, which is only eight votes. Despite this long expected, but the Chinese WAPI camp was quite angry.

"Vote is unfair, unjust and unacceptable." The Working Group has repeatedly stated. Because the vote is not final, China defeated the United States still have a chance WAPI standard, the success or failure will be overwhelmed by complaints about the situation.

In the complaint file, the Chinese that the United States IEEE continuous "immoral conduct" to influence voting. Such as IEEE and public incitement to other countries to vote against WAPI, organized a conspiracy against WAPI, which have greatly damaged the leadership of the ISO and just creed.

China demands ISO investigation. China firmly that if the investigation confirmed that China is innocent, ISO should be seriously dealt with IEEE, especially those who vote against WAPI should be declared null and void.






Recommended links:



FACEBOOK'S growing pains



TOP Religion



How to identify real and can automatically create Index index



Realplayer flv



My favorite Web Servers



E-cology in the Pan Micro Series 14



windows media player PSP



Landscape engineering company in Yantai in hand Weaver



About GROOVY and Grails



Wmv Mpeg Converter



FMC from theory to PRACTICE



Digital TV Chunjiang Plumbing



Youtube video formats



Photoshop top aides - EXTENSIS Photo Graphics (1)



MSN photo worm attacking Jiangmin Christmas warning Qi Rising