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-

www.google.fr	url?sa=t&source=web&ct=res&cd=14&ved=0CBYQFjADOAo&url=http%3A%2F%2Fwww.umsl.edu%2F~joshik%2Fdatabase%2Flarge-embed-sql2.doc&ei=i5H1SqSWEcaz4QbmuvnoAw&usg=AFQjCNF4v6b8RvltA8SjsGCNp8NvG2GcZA&sig2=zIGD-ZV-X7ewgtoSFSO39g	url	s	1	2	3
www.umsl.edu	large-embed-sql2.doc	Embedded SQL for COBOL in large font	s	1	2	3

EMBEDDED SQL COBOL - ENGLISH - HTML

benoit.astruc.free.fr	cobol	Index of /cobol	s	1	2	3	t
db2examples.googlepages.com	embeddedsql%28db2inapplicationprogramming%29	Embedded SQL	s	1	2	3	t
docs.hp.com	1	ALLBASE/SQL COBOL Application Programming Guide	s	1	2	3	t
	ix5000.htm	MPE/iX 5.0 Reference Manuals	s	1	2	3	t
en.wikipedia.org	Embedded_SQL	Embedded SQL - Wikipedia, the free encyclopedia	s	1	2	3	t
fibetips.blogspot.com	determinando-equivalencias-de-tipo-de.html	Fibetips: Equivalencias de tipo de datos SQL y COBOL Equivalencias de tipo de datos SQL y COBOL	s	1	2	3	t
mainframefundas.blogspot.com	performance-enhancement-of-cobol-db2.html	Performance enhancement of Cobol Db2	s	1	2	3	t
waltoncollege.uark.edu	CISQ5833_H1N.html	unsaved:///newpage2.htm Quick Guide To SQL With DB2 On Windows NT - HTML	s	1	2	3	t
	CISQ5833_H2N.html	unsaved:///newpage3.htm Quick Guide To SQL And Cobol With DB2 On Windows NT - HTML	s	1	2	3	t
	SQL-COBOL	waltoncollege.uark.edu - /lab/PCronan/CISQ 5833-html/SQL-COBOL/	s	1	2	3	t
www.cs.sfu.ca	node33.html	Embedded SQL	s	1	2	3	t
www.cs.toronto.edu	d-and-t-select.sqc	Embedded SQL Examples Using Date &	s	1	2	3	t
	embedsql.html	Embedded SQL Examples	s	1	2	3	t
www.emunix.emich.edu	dbcsqlcn.htm	Ch 9 TOC	s	1	2	3	t
	dbtocc.htm	dbtocc.htm	s	1	2	3	t
www.esnips.com	COBDB2	COBDB2.txt	s	1	2	3	t
	COBDB2	COBDB2.DOC	s	1	2	3	t
	cobol-db2-program	cobol-db2-program.txt	s	1	2	3	t
	Cobol-DB2	Cobol-DB2.rar	s	1	2	3	t
	cobdb2_compile	cobdb2_compile.txt	s	1	2	3	t
www.geocities.com	DB2_SQL_TUTORIAL.html	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	s	1	2	3	t
www.mainframegurukul.com	db2.html	IBM MAINFRAME - Cobol DB2 Programming DB2 TUTORIAL - COBOL DB2 Application Programming - DB2 Interview Questions Cobol DB2 Programming	s	1	2	3	t
www.scribd.com	Embeded-SQL	Embeded SQL	s	1	2	3	t
www.simotime.com	sim4dzip.htm	SimoTime Z-Pack Down Load Options	s	1	2	3	t
www.umsl.edu	cobsql.htm	Untitled Imbedded COBOL	s	1	2	3	t
	sql2.htm	Inserts, Deletes, Updates	s	1	2	3	t

EMBEDDED SQL COBOL - ENGLISH - PDF-

www-ti.informatik.uni-tuebingen.de

tutor05.pdf

Tutorial 5. tutor05.pdf database access with CICS

EMBEDDED SQL COBOL - ENGLISH - PPT-

waltoncollege.uark.edu	QuickGuideToDB2.ppt	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	s	1	2	3
	SQL-COBOL.ppt	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	s	1	2	3
web.sau.edu	Pratt%20SQL%20Chapter%208.ppt	Pratt SQL Chapter 8.ppt	s	1	2	3
www.tarleton.edu	Pratt%20SQL%20Chapter%208.ppt	www.tarleton.edu/~abane/CIS4523/Pratt SQL Chapter 8.ppt	s	1	2	3

EMBEDDED SQL COBOL -

EMBEDDED SQL COBOL - - HTML

benoit.astruc.free.fr

sqlcobol.txt

EMBEDDED SQL COBOL - PORTUGUESE

EMBEDDED SQL COBOL - PORTUGUESE - HTML

www.cadcobol.com	mapasite.htm	Mapa do site - www.cadbocol.com	s	1	2	3	t
www.lnatural.com	sqlcode.htm	SQLCode'	s	1	2	3	t

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)