GRANDSYSTEME.COM: SITE DE RESSOURCES MAINFRAME

 

EMBEDDED SQL COBOL

LANGUE TYPE DOCUMENT NB URL
ENGLISH
DOC 2
HTML 26
PDF 1
PPT 4
FRANCAIS
HTML 1
PORTUGUESE
HTML 2

EMBEDDED SQL COBOL - ENGLISH

EMBEDDED SQL COBOL - ENGLISH - DOC- disquette

EMBEDDED SQL COBOL - ENGLISH - HTML

benoit.astruc.free.fr
Index of /cobol
db2examples.googlepages.com
Embedded SQL
docs.hp.com
ALLBASE/SQL COBOL Application Programming Guide
MPE/iX 5.0 Reference Manuals
en.wikipedia.org
Embedded SQL - Wikipedia, the free encyclopedia
fibetips.blogspot.com
Fibetips: Equivalencias de tipo de datos SQL y COBOL Equivalencias de tipo de datos SQL y COBOL
mainframefundas.blogspot.com
Performance enhancement of Cobol Db2
waltoncollege.uark.edu
unsaved:///newpage2.htm Quick Guide To SQL With DB2 On Windows NT - HTML
unsaved:///newpage3.htm Quick Guide To SQL And Cobol With DB2 On Windows NT - HTML
waltoncollege.uark.edu - /lab/PCronan/CISQ 5833-html/SQL-COBOL/
www.cs.sfu.ca
Embedded SQL
www.cs.toronto.edu
Embedded SQL Examples Using Date &
Embedded SQL Examples
www.emunix.emich.edu
Ch 9 TOC
dbtocc.htm
www.esnips.com
COBDB2.txt
COBDB2.DOC
cobol-db2-program.txt
Cobol-DB2.rar
cobdb2_compile.txt
www.geocities.com
SQL TUTORIAL - DB2 SQL TUTORIALS - SQL TUTOR SQL TUTORIAL - DB2 SQL TUTORIALS SQL Tutorial http://www.geocities.com/srcsinc/database/db2_tutorials/sql_tutorials/DB2_SQL_TUTORIAL.html DB2 SQL Tutorial Primary DB2 SQL Tutorial
www.mainframegurukul.com
IBM MAINFRAME - Cobol DB2 Programming DB2 TUTORIAL - COBOL DB2 Application Programming - DB2 Interview Questions Cobol DB2 Programming
www.scribd.com
Embeded SQL
www.simotime.com
SimoTime Z-Pack Down Load Options
www.umsl.edu
Untitled Imbedded COBOL
Inserts, Deletes, Updates

EMBEDDED SQL COBOL - ENGLISH - PDF- disquette

www-ti.informatik.uni-tuebingen.de
Tutorial 5. tutor05.pdf database access with CICS

EMBEDDED SQL COBOL - ENGLISH - PPT- disquette

waltoncollege.uark.edu
waltoncollege.uark.edu/lab/DDouglas/CISQ4283/QuickGuideToDB2.ppt QuickGuideToDB2.ppt Quick Guide To SQL With DB2 On Windows NT - PPT QUICK GUIDE TO SQL WITH DB2 ON WINDOWS NT
waltoncollege.uark.edu/lab/PCronan/CISQ 5833-html/SQL-COBOL/SQL-COBOL.ppt SQL-COBOL.ppt Quick Guide To SQL And Cobol With DB2 On Windows NT -PPT QUICK GUIDE TO SQL AND COBOL WITH DB2 ON WINDOWS NT http://waltoncollege.uark.edu/lab/PCronan/CISQ 5833-html/SQL-COBOL/SQL-COBOL.ppt
web.sau.edu
Pratt SQL Chapter 8.ppt
www.tarleton.edu
www.tarleton.edu/~abane/CIS4523/Pratt SQL Chapter 8.ppt

EMBEDDED SQL COBOL - drapeau

EMBEDDED SQL COBOL - drapeau - HTML

benoit.astruc.free.fr
sqlcobol.txt

EMBEDDED SQL COBOL - PORTUGUESE

EMBEDDED SQL COBOL - PORTUGUESE - HTML

www.cadcobol.com
Mapa do site - www.cadbocol.com
www.lnatural.com
SQLCode'
MOTCLE ABBREVIATION DESCRIPTION
access plan (1) The set of access paths that is selected by the query optimizer to evaluate a particular SQL or XQuery statement. The access plan specifies the order of operations to resolve the execution plan, the implementation methods (such as JOIN), and the access path for each table that is referenced in the statement (2) In DB2 for i5/OS, the control structure produced during compile time that is used to process SQL statements encountered when the program is run
application plan The control structure that is produced during the bind process. DB2 for z/OS uses an application plan to execute SQL statements
application plan The control structure that is produced during the bind process. DB2 uses the application plan to process SQL statements that it encounters during statement execution
bind (1) To create a program, which can be run, by combining one or more modules created by an Integrated Language Environment (ILE) compiler (2) To relate an identifier to another object in a program for example, to relate an identifier to a value, an address or another identifier, or to associate formal parameters and actual parameters (3) To convert the output from the DBMS precompiler to a usable control structure, such as an access plan, an application plan, or a package (4) To establish a connection between software components on a network using an agreed-to protocol. In Web services, the bind operation occurs when the service requestor invokes or initiates an interaction with the service at run time using the binding details in the service description to locate, contact, and invoke the service (5) To logically associate a program with data or another program (6) To combine object code from one or more sources into an executable load module or program object
bind To convert the output from the DBMS precompiler |to a usable control structure, such as an access plan, an application plan, |or a package
BIND Within DB2, the process of extracting and converting embedded SQL statements into a plan. The bind determines access paths to data.
bind A process by which a usable control structure with SQL statements is generated the structure is often called an access plan, an application plan, or a package. During this bind process, access paths to the data are selected, and some authorization checking is performed. See also automatic bind
Call Level Interface CLI An API for database access that provides a standard set of functions to process SQL statements, XQuery expressions, and related services at run time. See also embedded SQL
call-level interface CLI A callable application programming interface (API) for database access, which is an alternative to using embedded SQL
configured name binding Persistent storage of an object in the name space that is created using either the administrative console or the wsadmin program
database request module DBRM A data set member that is created by the DB2 for z/OS precompiler and that contains information about SQL statements. DBRMs are used in the bind process
database request module DBRM A data set member that is created by the DB2 precompiler and that contains information about SQL statements. DBRMs are used in the bind process
DB2 Catalog The set of tables within DB2 which maintain the descriptions of objects such as tables, plans, views, and indexes. See DBRAD.
DBRM DataBase Request Module. Dataset containing source SQL code created by the DB2 pre-compiler. The SQL is removed from the source code of the program and replaced by calls to DB2 modules. The DBRM entry is used as input to the bind processor to create a plan which is stored with a time stamp in the database.
DBRM See database request module
deferred embedded SQL In DB2 for z/OS, SQL statements that are neither fully static nor fully dynamic. Like static statements, they are embedded within an application, but like dynamic statements, they are prepared during the execution of an application. See also dynamic SQL, static SQL, incremental bind statement
deferred embedded SQL SQL statements that are neither fully static nor fully dynamic. These statements are embedded within an application and are prepared during the execution of the application
dynamic bind A process by which SQL statements or XQuery expressions are bound when they are executed. See also static bind, automatic bind
dynamic SQL An SQL statement that is prepared and executed at run time. In dynamic SQL, the SQL statement is contained as a character string in a host variable and is not precompiled. See also deferred embedded SQL, static SQL, incremental bind statement
dynamic SQL SQL statements that are prepared and executed at run time. In dynamic SQL, the SQL statement is contained as a character string in a host variable or as a constant, and it is not precompiled
embedded SQL An SQL statement that is coded within an application program. See also Call Level Interface
embedded SQL SQL statements that are coded within an application program. See static SQL
ESQL Embedded SQL. SQL statements coded explicitly in an application program.
explain To capture detailed information about the access plan that was chosen by the SQL and XQuery compiler to resolve an SQL or XQuery statement. The information describes the decision criteria that are used to choose the access plan
host language Any programming language in which SQL statements or XQuery expressions can be embedded
host program An application program that is written in a host language and that contains embedded SQL statements or XQuery expressions
host program An application program that is written in a host language and that contains embedded SQL statements
host structure In an application program, a structure that contains a list of host variables that can be referred to by embedded SQL statements
host structure In an application program, a structure that is referenced by embedded SQL statements
host variable (1) In an application program, a variable that is referred to by embedded SQL statements. Host variables are programming variables in the application program and are the primary mechanism for transmitting data between tables in the database and application program work areas (2) A program data area that provides value to or receives value from a column in an SQL table
host variable In an application program written in a host language, an application variable that is referenced by embedded SQL statements
package (1) A control-structure database object produced during program preparation that can contain both executable forms of static SQL statements or XQuery expressions and placement holders for executable forms of dynamic SQL statements (2) A function that allows an application programmer to collect all the parts of an application together for distribution (3) In Java programming, a group of types. Packages are declared with the package keyword (4) An installable unit of a software product. Software product packages are separately installable units that can operate independently from other packages of that software product (5) A collection of catalog entries that has a SKU and may be ordered as a single item. See also bundle, stock keeping unit (6) A shipping unit that may be tracked by a shipping carrier (7) A collection
package A control-structure database object produced |during program preparation that can contain both executable forms of static |SQL statements or XQuery expressions and placement holders for executable |forms of dynamic SQL statements
package An object containing a set of SQL statements that have been statically bound and that is available for processing. A package is sometimes also called an application package
package name The name of an object that is created by the BIND, PRECOMPILE, or REBIND command. The object is a bound version of a database request module (DBRM). The name consists of a location name, a collection ID, a package ID, and a version ID
package name The name of an object that is used for an application package or an SQL procedure package. An application package is a bound version of a database request module (DBRM) that is created by a BIND PACKAGE or REBIND PACKAGE command. An SQL procedural language package is created by a CREATE or ALTER PROCEDURE statement for a native SQL procedure. The name of a package consists of a location name, a collection ID, a package ID, and a version ID
Plan The basic information extracted with the bind processor from SQL statements embedded in the user?s application, and used to determine the access strategy to a relational database. The plan is stored in the database and linked with its corresponding program. Plan is also known as application plan or access plan.
plan See application plan
plan member The bound copy of a DBRM that is identified in the member clause
precompilation A processing of application programs containing SQL statements that takes place before compilation. SQL statements are replaced with statements that are recognized by the host language compiler. Output from this precompilation includes source code that can be submitted to the compiler and the database request module (DBRM) that is input to the bind process
precompile To process programs that contain SQL statements before they are compiled. SQL statements are replaced with statements that will be recognized by the host language compiler. The output from a precompile process includes source code that can be submitted to the compiler and used in the bind process
Precompiler A program which converts application-oriented statements (e.g., 4GL, CICS Command-Level, DB2) into statements of a high-level language (e.g., COBOL). The processed output is compiled in the usual manner. A COBOL program using DB2 for a CICS environment would have run the output from the DB2 precompiler through the CICS precompiler, then compiling that output with the COBOL compiler.
Precompiler Services A z/OS DB2 API that can be called from the COBOL compiler to run the DB2 precompiler, eliminating the normal precompile job step. It also allows use of language capabilities that had been restricted by the precompiler, such as nested COBOL programs.
SQL statement coprocessor An alternative to the DB2 for z/OS precompiler that lets the user process SQL statements at compile time. The user invokes an SQL statement coprocessor by specifying a compiler option
SQL statement coprocessor An alternative to the DB2 precompiler that lets the user process SQL statements at compile time. The user invokes an SQL statement coprocessor by specifying a compiler option
static SQL SQL statements that are embedded within a program and are bound before the program is executed. After being bound, a static SQL statement does not change, although values of host variables specified by the statement can change. See also deferred embedded SQL, dynamic SQL, incremental bind statement
static SQL SQL statements, embedded within a program, that are prepared during the program preparation process (before the program is executed). After being prepared, the SQL statement does not change (although values of variables that are specified by the statement might change)