In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned ?
+100 (for successful completion of the query), 0 (for successful COMMIT if AUTOCOMMIT is set to Yes).
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Give suitable code for all login controls 11.11.08
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e) { string u_id=Login1.UserName; string pwd=Login1.Password;...How many ways we can we find the current date using MySQL? 06.11.08
SELECT CURDATE(); SELECT CURRENT_DATE(); SELECT CURTIME(); SELECT CURRENT_TIME();...How would you find out the total number of rows in a table ? 26.07.08
Use SELECT COUNT(*) ......What is a pseudo column. Give some examples 11.05.08
It is a column that is not an actual column in the table. eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL. Suppose customer table is there having di...Compare a subselect to a join ? 03.04.08
Any subselect can be rewritten as a join, but not vice versa. Joins are usually more efficient as join rows can be returned immediately, subselects require a...What is a subselect? Is it different from a nested select? 26.03.08
A subselect is a select which works in conjunction with another select. A nested select is a kind of subselect where the inner select passes to the where criter...B37 abend during SPUFI ? 24.03.08
The b37 abend in the SPUFI is because of space requirements , the query has resulted in so many rows that the SPUFI. out file is not large enough to handle it,...Give some example of statistics collected during RUNSTATS ? 18.03.08
Number of rows in the table, Percent of rows in clustering sequence, Number of distinct values of indexed column, Number of rows moved to a nearby/fairway pag...What is the difference among “dropping a table”, “truncating a table” and “deleting all records” from a table. 16.11.06
Drop Table - will remove the existence of the table from the database along with its data and structure and all the constraints. The table will be no longer ava...What command is used to create a table by copying the structure of another table? 09.03.06
CREATE TABLE .. AS SELECT command Explanation : To copy only the structure, the WHERE clause of the SELECT command should contain a FALSE statement as in the f...