You can find the codes in the DB2 Information Center. Here’s a definition of the -302 from the z/OS Information Center: THE VALUE OF INPUT VARIABLE OR PARAMETER NUMBER position-number IS INVALID OR TOO LARGE FOR THE TARGET COLUMN OR THE TARGET VALUE On Linux/Unix/Windows DB2, you’ll look under SQL Messages to find your error … Read more
You’re looking for is called an IDENTITY column: create table student ( sid integer not null GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1) ,sname varchar(30) ,PRIMARY KEY (sid) ); A sequence is another option for doing this, but you need to determine which one is proper for your particular situation. Read this … Read more
I got the answer from the sysibm.syscolumns Select distinct(name), ColType, Length from Sysibm.syscolumns where tbname=”employee”;
Using FETCH FIRST [n] ROWS ONLY: http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.perf/db2z_fetchfirstnrows.htm SELECT LASTNAME, FIRSTNAME, EMPNO, SALARY FROM EMP ORDER BY SALARY DESC FETCH FIRST 20 ROWS ONLY; To get ranges, you’d have to use ROW_NUMBER() (since v5r4) and use that within the WHERE clause: (stolen from here: http://www.justskins.com/forums/db2-select-how-to-123209.html) SELECT code, name, address FROM ( SELECT row_number() OVER ( ORDER … Read more