<div>
<div class="content wysiwyg-content">
I always though that it was necessary to do an open cursor, select without into, fetch and close cursor for embedded DB2 SQL in COBOL.<br />
<br />
However, I just coded, compile and tested a SELECT INTO in COBOL and from the testing it appears to be working. &nbsp;Am I just being fooled, I want to make sure that it is okay to do this and it is correct.<br />
<br />
Thanks, MarOS
</div>
</div>


I always though that it was necessary to do an open cursor, select without into, fetch and close cursor for embedded DB2 SQL in COBOL.

However, I just coded, compile and tested a SELECT INTO in COBOL and from the testing it appears to be working.  Am I just being fooled, I want to make sure that it is okay to do this and it is correct.

Thanks, MarOS

DB2 SQL EMBEDDED IN COBOL SELECT INTO

Remote access may refer to the connection to a data-processing system from a remote location, for example through a virtual private network remote desktop software, terminal emulation, or the activation of features of a business telephone system from outside the business's premises.

Remote Access

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

There are many computer languages, and they have been evolving from machine language into a more natural way of writing. Languages are generally classified into machine language (direct machine code); assembly (using mnemonics to present the instructions to be translated later into machine language by an assembly program); procedural languages, also known as high-level languages (HLL) (Pascal, FORTRAN, Algol, JCL, COBOL, REXX, PL/I, Basic, and C are common), along with several other types. Mainframe programming is largely done in the procedural languages.

Mainframe Languages

COBOL (Common Business-Oriented Language) is a programming language with English-like syntax. It is readable but verbose compared to other programming languages. CODASYL (Conference on Data Systems Languages) created COBOL in 1959 based on design work from Grace Hopper. It was standardized in 1968. COBOL is still present in large-scale batch processing and transaction processing where legacy applications are being used, usually in government, financial, and administrative systems.