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.
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