In your 'sqllib/bnd' directory there is a file called 'ddcsmvs.lst'. It contains names of bind files you must bind on the server:
db2 bind @ddcsmvs.lst sqlerror continue grant public
Chrisk
Last Activity: Jul 31 '07, 09:17 AM
Joined: Jul 31 '07
Location:
-
A package is an object created by binding a DBRM (or a '.bnd' file in Linux,Unix,Wind ows). Many packages with identical names can exist in the same system, using the VERSION pre-processor parameter.
A plan is an object created by binding a set of DBRM's and/or a list of package names.
Distributed applications always use packages.Leave a comment:
-
First of all, if the 15 characters must be digits, shouldn't you use a DECIMAL(15) data type instead?
However...
Add a CHECK condition to the table which converts the digits to a DECIMAL(15) and back to a CHAR(15). Then compare the resulting string to the original. You will get a conversion SQL error if they are not digits.
It is not trivial (I think):
...Code:alter table sample add check(substr(char(decimal(substr(col1,1,15),15,0)),1,15)
Leave a comment:
-
Use a UNION ALL where you select constants (the header) from SYSIBM.SYSDUMMY 1 in front of the actual table SELECT.Leave a comment:
-
IBM supplies a stored procedure DSNUTILS you can use to invoke REORG and other utilities. Perhaps it is already in your system.
There should be something to read in your 'Utility Guide and Reference' manual.Leave a comment:
No activity results to display
Leave a comment: