Answer / guest

Consistency token is a timestamp generated by the
precompiler and passed on to the DBRM and the load module
for synchronization purposes. The program will execute only
when the DBRM and load module contoken matches.

Answer / harsh

Consistency Token is a time stamp.
One can see the token using the following query:
select * from sysibm.syspackage;

The CONTOKEN column gives the consistency token

Answer / vj

The program and its associated SQL package contain a consistency token that is checked when a call is made to the SQL package. The consistency tokens must match or the package cannot be used. It is possible for the program and SQL package to appear to be uncoordinated. Assume the program is on the iSeries system and the application server is another iSeries system. The program is running in session A and it is recreated in session B (where the SQL package is also recreated). The next call to the program in session A might result in a consistency token error. To avoid locating the SQL package on each call, SQL maintains a list of addresses for SQL packages that are used by each session. When session B re-creates the SQL package, the old SQL package is moved to the QRPLOBJ library. The address to the SQL package in session A is still valid. (This situation can be avoided by creating the program and SQL package from the session that is running the program, or by submitting a remote command to delete the old SQL package before creating the program.)

To use the new SQL package, you should end the connection with the remote system. You can either sign off the session and then sign on again, or you can use the interactive SQL (STRSQL) command to issue a DISCONNECT for unprotected network connections or a RELEASE followed by a COMMIT for protected connections. RCLDDMCNV should then be used to end the network connections. Call the program again.

what is the use of cursors?

3 Answers   iGate,

---

Are view updateable?

0 Answers  

---

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,

---

What is a host variable?

3 Answers  

---

How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,

---

SET is the ANSI standard for variable assignment, SELECT is not. SET can only assign one variable at a time, SELECT can make multiple assignments at once. If assigning from a query, SET can only assign a scalar value. If the query returns multiple values/rows then SET will raise an error. SELECT will assign one of the values to the variable and hide the fact that multiple values were returned (so you'd likely never know why something was going wrong elsewhere - have fun troubleshooting that one) When assigning from a query if there is no value returned then SET will assign NULL, where SELECT will not make the assignment at all (so the variable will not be changed from it's previous value) As far as speed differences - there are no direct differences between SET and SELECT. However SELECT's ability to make multiple assignments in one shot does give it a slight speed advantage over SET.

0 Answers  

---

What is an alias and how does it differ from a synonym?

3 Answers  

---

List some fields from sqlca?

0 Answers  

---

How does one remove entries from the SCT02 table?

1 Answers  

---

Where is the access path logic created by the DB2 Optimizer stored?

1 Answers  

---

What is a page?

2 Answers  

---

What is the meaning of -805 SQL return code?

3 Answers  

---