Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by TecZen
-
SQL0104N SQLSTATE=42601
Thanks for the additional comments. I am actually going to be writing two procedures with cursors, one to update records that have changed to "inactive" and the second to insert new records or new lines for records that have been updated, which will be active records - thus maintaining history... -
SQL0104N SQLSTATE=42601
I am experiencing one further error on this procedure. I've been researching, but haven't found anything specific as a solution. Most descriptions of the problem are too broad. Below is the sql: DECLARE IMC CURSOR FOR SELECT t1.ALIAS, t1.T_30, t1.T_14, t1.T_3, t2.ukey, t2.ALIAS, t2.T_30... -
SQL0104N SQLSTATE=42601
I removed underscores and found that I had the same error. It was worth a try. Still looking for a solution. Thanks! -
SQL0104N SQLSTATE=42601
I am new to DB2 and have been following directions from a book for creating a stored procedure. Things LOOK like they should work, but I am getting errors. What am I missing? I've worked with MS SQL, so the syntax on this is very different.. Any help would be appreciated! CREATE PROCEDURE...
