Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

sql syntax checking at precompiled stage to bind stage

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
shalem

New User


Joined: 11 Apr 2005
Posts: 2

PostPosted: Mon Apr 11, 2005 9:18 pm    Post subject: sql syntax checking at precompiled stage to bind stage
Reply with quote

What is the difference between sql syntax checking at precompiled stage to bind stage
Back to top
View user's profile Send private message

priya

Moderator


Joined: 24 Jul 2003
Posts: 568
Location: Bangalore

PostPosted: Mon Apr 11, 2005 10:41 pm    Post subject:
Reply with quote

Precompiler doesn't check the SQL statements for availability, I hope.
Back to top
View user's profile Send private message
shalem

New User


Joined: 11 Apr 2005
Posts: 2

PostPosted: Thu Apr 14, 2005 1:52 pm    Post subject: syntax checking at precompiled stage to bind stage
Reply with quote

There is difference between syntax checking in Precompiler and Bind.If delimiters surround an SQL statement, the precompiler does a very basic syntax check to make sure that the column and table names are valid (that they're spelled correctly and that the columns and the table exist).This validation is not done by DB2 or its CATALOG.The DB2 Precompiler uses the top part of the DCLGEN to validate the SQL syntax.

BIND, like precompile, must also check the syntax of the SQL, but the BIND check is more sophisticated. Instead of using the top, DECLARE TABLE portion of the DCLGEN, BIND uses the DB2 CATALOG table information to make sure that the column names are valid, that comparisons are numeric-to-numeric, and so on. This second syntax check occurs because you can't trust the one done by the precompiler because the precompiler check used the DCLGEN.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Checking wether a string starts from ... sundaram.naveen CLIST & REXX 9 Thu Oct 06, 2016 11:56 am
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am
No new posts Reasonable way of checking wildcards ... sergeyken CLIST & REXX 5 Wed Sep 07, 2016 8:43 pm
No new posts Checking for availability of a data set steve-myers JCL & VSAM 1 Wed Jul 13, 2016 5:17 pm
No new posts Syntax for running batch history repo... polymathtarun CA Products 1 Tue Jun 21, 2016 1:51 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us