-007 STATEMENT CONTAINS THE ILLEGAL CHARACTER character-010 String constant beginning string is NOT TERMINATED.-029 INTO Clause Required.-060 Invalid type Specification: "Spec"-079 QUALIFIER FOR DECLARED GLOBAL TEMPORARY TABLE table-name MUST BE SESSION, NOT qualifier-084 Unacceptable SQL Statement.-097 THE USE OF LONG VARCHAR OR LONG VARGRAPHIC IS NOT ALLOWED IN THIS CONTEXT-101 Statement is Too Long, or Too Complex.-102 String constant is too long.-103 Literal is an invalid Numeric Literal.-104 Illegal Symbol token.-105 Invalid String.-107 The Name, "NAME" is Too Long, Maximum Allowable size is "SIZE".-108 THE NAME name IS QUALIFIED INCORRECTLY-109 "CLAUSE" clause is not permitted.-110 Invalid Hexadecimal Literal Beginning "STRING"-111 A Column Function does not include a column name.-112 The Operand of a Column function is Another Column Function.-113 Invalid Character found in Name: "NAME", Reason Code- "REASON-CODE".-114 THE LOCATION NAME location DOES NOT MATCH THE CURRENT SERVER-115 A PREDICATE Is Invalid because the comparison operator "OPERATOR" is followed by a 'parenthesized list' or "By Any"     or "All" with out a Sub-query -117 The number of values in the INSERT does not match the number of columns.-118 THE OBJECT TABLE OR VIEW OF THE DELETE OR UPDATE STATEMENT IS ALSO IDENTIFIED IN A FROM CLAUSE-119 A COLUMN IDENTIFIED IN A HAVING CLAUSE IS NOT INCLUDED IN THE GROUP BY CLAUSE-120 A WHERE CLAUSE, SET CLAUSE, VALUES CLAUSE, OR A SET HOST-VARIABLE STATEMENT INCLUDES A COLUMN FUNCTION-121 THE COLUMN name IS IDENTIFIED MORE THAN ONCE IN THE INSERT OR UPDATE OR SET TRANSITION VARIABLE STATEMENT-122 A SELECT STATEMENT WITH NO GROUP BY CLAUSE CONTAINS A COLUMN NAME AND A COLUMN FUNCTION IN THE SELECT CLAUSE OR A      COLUMN NAME IS CONTAINED IN THE SELECT CLAUSE BUT NOT IN THE GROUP BY CLAUSE-123 THE PARAMETER IN POSITION n IN THE FUNCTION name MUST BE A CONSTANT OR KEYWORD-125 AN INTEGER IN THE ORDER BY CLAUSE DOES NOT IDENTIFY A COLUMN OF THE RESULT-126 THE SELECT STATEMENT CONTAINS BOTH AN UPDATE CLAUSE AND AN ORDER BY CLAUSE-127 DISTINCT IS SPECIFIED MORE THAN ONCE IN A SUBSELECT-128 INVALID USE OF NULL IN A PREDICATE-129 THE STATEMENT CONTAINS TOO MANY TABLE NAMES-130 THE ESCAPE CLAUSE CONSISTS OF MORE THAN ONE CHARACTER, OR THE STRING PATTERN CONTAINS AN INVALID OCCURRENCE OF THE      ESCAPE CHARACTER-131 STATEMENT WITH LIKE PREDICATE HAS INCOMPATIBLE DATA TYPES-132 AN OPERAND OF value IS NOT VALID-133 A COLUMN FUNCTION IN A SUBQUERY OF A HAVING CLAUSE IS INVALID BECAUSE ALL COLUMN REFERENCES IN ITS ARGUMENT ARE      NOT CORRELATED TO THE GROUP BY RESULT THAT THE HAVING CLAUSE IS APPLIED TO-134 IMPROPER USE OF LONG STRING COLUMN column-name OR AN EXPRESSION THAT RESOLVES TO A LONG STRING-136 SORT CANNOT BE EXECUTED BECAUSE THE SORT KEY LENGTH IS GREATER THAN 4000 BYTES-137 THE LENGTH RESULTING FROM operation IS GREATER THAN maximum-length-138 THE SECOND OR THIRD ARGUMENT OF THE SUBSTR FUNCTION IS OUT OF RANGE-142 THE SQL STATEMENT IS NOT SUPPORTED-144 INVALID SECTION NUMBER number-147 ALTER FUNCTION function-name FAILED BECAUSE SOURCE FUNCTIONS CANNOT BE ALTERED-148 THE SOURCE TABLE source-name CANNOT BE RENAMED OR ALTERED-150 THE OBJECT OF THE INSERT, DELETE, OR UPDATE STATEMENT IS A VIEW OR TRANSITION TABLE FOR WHICH THE REQUESTED      OPERATION IS NOT PERMITTED-151 THE UPDATE STATEMENT IS INVALID BECAUSE THE CATALOG DESCRIPTION OF COLUMN column-name INDICATES THAT IT CANNOT BE      UPDATED-152 THE DROP clause CLAUSE IN THE ALTER STATEMENT IS INVALID BECAUSE constraint-name IS A constraint-type-153 THE STATEMENT IS INVALID BECAUSE THE VIEW OR TABLE DEFINITION DOES NOT INCLUDE A UNIQUE NAME FOR EACH COLUMN-154 THE STATEMENT FAILED BECAUSE VIEW OR TABLE DEFINITION IS NOT VALID-156 THE STATEMENT DOES NOT IDENTIFY A TABLE-157 ONLY A TABLE NAME CAN BE SPECIFIED IN A FOREIGN KEY CLAUSE. object-name IS NOT THE NAME OF A TABLE.-158 THE NUMBER OF COLUMNS SPECIFIED FOR THE VIEW IS NOT THE SAME AS THE NUMBER OF COLUMNS SPECIFIED BY THE SELECT      CLAUSE, OR THE NUMBER OF COLUMNS SPECIFIED IN THE CORRELATION CLAUSE IN A FROM CLAUSE IS NOT THE SAME AS THE      NUMBER OF COLUMNS IN THE CORRESPONDING TABLE, VIEW, TABLE EXPRESSION, OR TABLE FUNCTION-159 DROP OR COMMENT ON object IDENTIFIES A(N) object-type1 RATHER THAN A(N) object-type2-160 THE WITH CHECK OPTION CANNOT BE USED FOR THE SPECIFIED VIEW-161 THE INSERT OR UPDATE IS NOT ALLOWED BECAUSE A RESULTING ROW DOES NOT SATISFY THE VIEW DEFINITION-164 auth-id1 DOES NOT HAVE THE PRIVILEGE TO CREATE A VIEW WITH QUALIFICATION authorization-ID-170 THE NUMBER OF ARGUMENTS SPECIFIED FOR function-name IS INVALID-171 THE DATA TYPE, LENGTH, OR VALUE OF ARGUMENT nn OF function-name IS INVALID-173 UR IS SPECIFIED ON THE WITH CLAUSE BUT THE CURSOR IS NOT READ-ONLY-180 THE DATE, TIME, OR TIMESTAMP VALUE value IS INVALID-181 THE STRING REPRESENTATION OF A DATETIME VALUE IS NOT A VALID DATETIME VALUE-182 AN ARITHMETIC EXPRESSION WITH A DATETIME VALUE IS INVALID-183 AN ARITHMETIC OPERATION ON A DATE OR TIMESTAMP HAS A RESULT THAT IS NOT WITHIN THE VALID RANGE OF DATES-184 AN ARITHMETIC EXPRESSION WITH A DATETIME VALUE CONTAINS A PARAMETER MARKER-185 THE LOCAL FORMAT OPTION HAS BEEN USED WITH A DATE OR TIME AND NO LOCAL EXIT HAS BEEN INSTALLED-186 THE LOCAL DATE LENGTH OR LOCAL TIME LENGTH HAS BEEN INCREASED AND EXECUTING PROGRAM RELIES ON THE OLD LENGTH-187 A REFERENCE TO A CURRENT DATE/TIME SPECIAL REGISTER IS INVALID BECAUSE THE MVS TOD CLOCK IS BAD OR THE MVS PARMTZ      IS OUT OF RANGE-188 THE STRING REPRESENTATION OF A NAME IS INVALID-189 CCSID ccsid IS UNKNOWN OR INVALID FOR THE DATA TYPE OR SUBTYPE-190 ATTRIBUTES OF COLUMN column-name IN TABLE table-name ARE NOT COMPATIBLE WITH THE EXISTING COLUMN-191 A STRING CANNOT BE USED BECAUSE IT IS INVALID MIXED DATA-197 QUALIFIED COLUMN NAMES IN ORDER BY CLAUSE NOT PERMITTED WHEN UNION OR UNION ALL SPECIFIED-198 THE OPERAND OF THE PREPARE OR EXECUTE IMMEDIATE STATEMENT IS BLANK OR EMPTY-199 Illegal use of the specified keyword.-203 A REFERENCE TO COLUMN column-name IS AMBIGUOUS-204 Object not defined to DB2.-205 Column name not in table.-206 Column does not exist in any table of the SELECT.-208 THE ORDER BY CLAUSE IS INVALID BECAUSE COLUMN name IS NOT PART OF THE RESULT TABLE-212 name IS SPECIFIED MORE THAN ONCE IN THE REFERENCING CLAUSE OF A TRIGGER DEFINITION-214 AN EXPRESSION IN THE FOLLOWING POSITION, OR STARTING WITH position-or-expression-start IN THE clause-type CLAUSE      IS NOT VALID. REASON CODE = reason-code-216 Not the same number of expressions on both sides of the comparison in a SELECT . -219 THE REQUIRED EXPLANATION TABLE table-name DOES NOT EXIST-220 THE COLUMN column-name IN EXPLANATION TABLE table-name IS NOT DEFINED PROPERLY-221 “SET OF OPTIONAL COLUMNS” IN EXPLANATION TABLE table-name IS INCOMPLETE. OPTIONAL COLUMN column-name IS MISSING-222 AN UPDATE OR DELETE OPERATION WAS ATTEMPTED AGAINST A HOLE USING cursor-name-223 AN UPDATE OR DELETE OPERATION WAS ATTEMPTED AGAINST AN UPDATE HOLE USING cursor-name-224 FETCH cannot make an INSENSITIVE cursor SENSITIVE.-225 FETCH STATEMENT FOR cursor-name IS NOT VALID BECAUSE THE CURSOR IS NOT DEFINED AS SCROLL-228 FOR UPDATE CLAUSE SPECIFIED FOR READ-ONLY CURSOR cursor-name-229 The locale specified in a SET LOCALE statement was not found.-240 THE PART CLAUSE OF A LOCK TABLE STATEMENT IS INVALID-243 SENSITIVE CURSOR cursor-name CANNOT BE DEFINED FOR THE SPECIFIED SELECT STATEMENT-244 SENSITIVITY sensitivity SPECIFIED ON THE FETCH IS NOT VALID FOR CURSOR cursor-name-245 THE INVOCATION OF FUNCTION ROUTINE-NAME IS AMBIGUOUS-250 THE LOCAL LOCATION NAME IS NOT DEFINED WHEN PROCESSING A THREE-PART OBJECT NAME-251 TOKEN name IS NOT VALID

"UNIX is simple. But it just needs a genius to understand its simplicity."
--Dennis Ritchie

"Before software can be reusable, it first has to be usable."
--Ralph Johnson

Good judgment comes from experience, and experience comes from bad judgment.
--Fred Brooks

Theory is when you know something, but it doesn't work. Practice is when something works, but you don't know why it works. Programmers combine theory and practice: Nothing works and they don't know why.
It's hard enough to find an error in your code when you're looking for it; it's even harder when you've assumed your code is error-free.
-Steve McConnell in Code Complete

If builders built buildings the way programmers wrote programs, then the first woodpecker that came along would destroy civilisation.
-Gerald Weinberg

The Six Phases of a Project:
Enthusiasm | Disillusionment | Panic | Search for the Guilty | Punishment of the Innocent | Praise for non-participants

Good code is its own best documentation. As you're about to add a comment, ask yourself, 'How can I improve the code so that this comment isn't needed?' Improve the code and then document it to make it even clearer.
--Steve McConnell in Code Complete

The trouble with the world is that the stupid are cocksure and the intelligent are full of doubt.
--Bertrand Russell

No matter how slick (efficient) the demo is in rehearsal, when you do it in front of a live audience the probability of a flawless presentation is inversely proportional to the number of people watching, raised to the power of the amount of money involved.
One of the main causes of the fall of the Roman Empire was that, lacking zero, they had no way to indicate successful termination of their C programs. JJ
--Robert Firth

Fifty years of programming language research and we end up with C++?
--Richard A. O'Keefe

C programmers never die. They are just cast into void.

If debugging is the process of removing bugs, then programming must be the process of putting them in.

--Edsger Dijkstra

You can either have software quality or you can have pointer arithmetic, but you cannot have both at the same time.
--(Bertrand Meyer) (Thoughtful...)

There are two ways to write error-free programs; only the third works.
--Alan J. Perlis

Measuring programming progress by lines of code is like measuring aircraft building progress by weight.
--Bill Gates

The first 90% of the code accounts for the first 90% of the development time. The remaining 10% of the code accounts for the other 90% of the development time.
--Tom Cargill

Programmers are in a race with the Universe to create bigger and better idiot-proof programs, while the Universe is trying to create bigger and better idiots. So far the Universe is winning.
--Anon

As soon as we started programming, we found to our surprise that it wasn't as easy to get programs right as we had thought. Debugging had to be discovered. I can remember the exact instant when I realized that a large part of my life from then on was going to be spent in finding mistakes in my own programs.
--Maurice Wilkes discovers debugging, 1949

I did say something along the lines of "C makes it easy to shoot yourself in the foot; C++ makes it harder, but when you do, it blows your whole leg off."
--Bjarne Stroustrup

It has been said that the great scientific disciplines are examples of giants standing on the shoulders of other giants. It has also been said that the software industry is an example of midgets standing on the toes of other midgets.
--Alan Cooper About Face

Computers are useless. They can only give you answers.
--Pablo Picasso

If the code and the comments disagree, then both are probably wrong.
--attributed to Norm Schryer

Even if you're on the right track, you'll get run over if you just sit there.
--Will Rogers

Einstein argued that there must be simplified explanations of nature, because God is not capricious or arbitrary. No such faith comforts the software engineer.
--Fred Brooks, Jr. in The Mythical Man Month

As we said in the preface to the first edition, C "wears well as one's experience with it grows." With a decade more experience, we still feel that way.
--Brian Kernighan and Dennis Ritchie

Simplicity is prerequisite for reliability.
--Edsger W.Dijkstra

I've finally learned what "upward compatible" means. It means we get to keep all our old mistakes.
--Dennie van Tassel

Rules of Optimization:
Rule 1: Don't do it.
Rule 2 (for experts only): Don't do it yet.
--M.A. Jackson

Most software today is very much like an Egyptian pyramid with millions of bricks piled on top of each other, with no structural integrity, but just done by brute force and thousands of slaves.
--Alan Kay

Every program has (at least) two purposes: the one for which it was written, and another for which it wasn't.
--Alan J. Perlis

Technology is dominated by two types of people: Those who understand what they do not manage. Those who manage what they do not understand.
--Putt's Law

Copy and paste is a design error
--David Parnas

Any code of your own that you haven't looked at for six or more months might as well have been written by someone else.
--Eagleson's law

The primary duty of an exception handler is to get the error out of the lap of the programmer and into the surprised face of the user. Provided you keep this cardinal rule in mind, you can't go far wrong.
--Verity Stob

<script language="JavaScript">
var time = null
function movetonew() {
window.location = 'http://www.example.com'
}
</script>

<body onload="timer=setTimeout('movetonew()',2000)">

1) What is Circularity? Is there any problem with Circularity?

2) What is the purpose Shared Subroutines?

3) How to use Data Area in Synon?

4) How to use Pre-Process Compiler in Synon function?

5) How to do it Impact Analysis?

6) What is referential Integrity?

7) What is Prototyping?  Does it involve Generation/Compilations?

8) Commitment Control v/s Journaling; How is Commit Control implemented in Synon?

9) How are the Sub files loaded in case of DSPFIL v/s DSPTRN Page by Page or all records at a time?

10) Define Assimilation.

Three most important skills are: 1) Lansa for the web, 2) Strong business knowledge, 3) Fast to pick up systems.

Developers will be taking part in a global project management initiative, developing web functions to the required specs as they roll in.

All candidates will initially be phone screened and based upon this step will be brought in for a face to face.

Thank you!