Results for FETCH


1 to 20 of 1188 results. Prev  Next
Results per page:   20  | 40 | 60


Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

ANSI Dynamic SQL

FETCHPurpose The FETCH statement fetches a row for a cursor declared with a dynamic DECLARE statement … . Syntax EXEC SQL [FOR [:]array_size] FETCH cursor INTO [SQL] DESCRIPTOR [GLOBAL | LOCAL] {:desc_nam … . RETURNED_LENGTH is undefined for fixed-length character types. Examples EXEC SQL FETCH FROM C1 INTO … DESCRIPTOR 'SELDES' END-EXEC.

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

ANSI Dynamic SQL

FETCH:array_size] FETCH cursor INTO [SQL] DESCRIPTOR [GLOBAL | LOCAL] {:desc_nam | string_literal … statement. Examples EXEC SQL FETCH FROM C1 INTO DESCRIPTOR 'SELDES'. EXEC SQL FOR:arsz FETCH C2 INTO DESCRIPTOR:desc;

Precompilers, 9i Release 2 (9.2.0.2)

Using Dynamic SQL

FETCH, as follows: EXEC SQL OPEN emp_cursor USING:salary; FETCH FETCH returns a row from the active set … advances the cursor to the next row. When no more rows are found, FETCH returns the \"no data found\" Oracle error code to SQLCODE in the SQLCA.

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Oracle Dynamic SQL

FETCHThe FETCH statement returns a row from the active set, assigns column values in the select list to … more rows are found, FETCH returns the \"no data found\" error code to SQLCODE in the SQLCA. In our … example, FETCH returns a row from the active set and assigns the values of columns MGR and JOB to host … variables MGR-NUMBER

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Oracle Dynamic SQL

FETCH, FETCH returns the \"no data found\" Oracle error code to sqlca.sqlcode. In our example, FETCH returns a … and job_title, as follows: EXEC SQL FETCH emp_cursor INTO:mgr_number,:job_title; If the cursor is … declared in SCROLL mode, you can then use the various FETCH orientation modes to randomly access the result set.

JDBC Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Result Set Enhancements

Fetch Sizewith each database round trip for a query, and this number is referred to as the fetch size. In … Oracle JDBC, the row-prefetch value is used as the default fetch size in a statement object. Setting … the fetch size overrides the row-prefetch setting and affects subsequent queries executed through that … statement object. Fetch

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 21 of 52

FETCH StatementThe FETCH statement retrieves rows of data one at a time from the result set of a multi-row query

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Embedded SQL

Fetch NULLsWhen DBMS=V7 or DBMS=V8, if you SELECT or FETCH NULLs into a host variable not associated with an

OLAP Developer's Guide to the OLAP API, 9i Release 2 (9.2.0.2)

Retrieving Query Results, 6 of 6

Specifying Fetch Sizes and Fetch Blocksfetch operation depends on the fetch size specified for that Cursor. For a CompoundCursor, you can set … the fetch size on the CompoundCursor itself or at one or more levels of its descendent Cursor … components. Setting the fetch size on a CompoundCursor specifies that fetch size for its child Cursor

OLAP Developer's Guide to the OLAP API, 9i Release 2 (9.2.0.2)

Understanding Cursor Classes and Concepts, 6 of 6

About Fetch Sizes and Fetch Blocks… The amount of data that a Cursor retrieves in a single fetch operation is determined by the fetch … is the product of the fetch sizes of all of its descendent ValueCursor objects. The total set of … values retrieved in a single fetch is the fetch block for the Cursor. You specify fetch

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Embedded SQL Statements and Precompiler Directives

FETCH (Executable Embedded SQL)variables. For ANSI Dynamic SQL Method 4, see \"FETCH DESCRIPTOR (Executable Embedded SQL … DECLARE CURSOR statement. The FETCH statement returns one of the rows selected by the query associated … with the cursor. cursor_variable A cursor variable is allocated an ALLOCATE statement. The FETCH … variable. Usage Notes The FETCH

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Database Concepts

Fetch Across COMMITsFETCH emp_cursor INTO:emp_name,:salary,:row_id;... EXEC SQL UPDATE emp SET sal =:new_salary

Precompilers, 9i Release 2 (9.2.0.2)

Embedded SQL Commands and Directives

FETCH (Executable Embedded SQL)Purpose To retrieve one or more rows returned by a query, assigning the select list values to host variables.

OLAP Developer's Guide to the OLAP API, 9i Release 2 (9.2.0.2)

Understanding Cursor Classes and Concepts, 6 of 6

About Sharing Fetch Blockshaving separate data caches, because the shape of the fetch blocks is the same for both Cursor objects … . The shape of the fetch blocks is determined by the levels of the CursorManagerSpecification on which … the fetch size is specified. An example is an application that displays the results of a query to

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Embedded SQL Statements and Directives

FETCH (Executable Embedded SQL)select list values to host variables. For ANSI Dynamic SQL Method 4 see \"FETCH DESCRIPTOR (Executable … declared by a DECLARE CURSOR statement. The FETCH statement returns one of the rows selected by the … . The FETCH statement returns one of the rows selected by the query associated with the cursor … . Usage Notes The FETCH

JDBC Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Result Set Enhancements

Setting the Fetch SizeResultSet objects for setting and getting the fetch size: void setFetchSize(int rows) throws … SQLException int getFetchSize() throws SQLException To set the fetch size for a query, call setFetchSize() on … the statement object prior to executing the query. If you set the fetch size to N, then N rows are … () on the result set

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

Design Considerations

Multi-Row Fetch2000. Anyone implementing indexes which use callouts should use multirow fetch to fetch the largest

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Embedded SQL

The FETCH StatementYou use the FETCH statement to retrieve rows from the active set and specify the output host … FETCH statement. In the following example, you FETCH INTO three host variables: EXEC SQL FETCH … . The first time you execute FETCH, the cursor moves from before the first row in the active set to

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

SQLJ Error Messages

Expected: FETCH :cursor INTO ...Cause: The FETCH statement must have a cursor host variable, from which values are to be fetched.

Programmer's Guide, 9i Release 2 (9.2.0.2)

Binding and Defining

Providing FETCH Information at Runtimeapplication can specify information about the data buffer at the time of fetch. You also may need to call … Datatypes for Piecewise Operations\". Performing a Piecewise Fetch Once the OCI environment has been … initialized, and a database connection and session have been established, a piecewise fetch begins … complete. Keep in





Was this page helpful?

Integrated Cloud Applications & Platform Services