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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jtidge

    ibm db2 if statement

    Great suggestion, tzamora! I'll give it a try. -john
  2. jtidge

    ibm db2 if statement

    Thanks for the reply, Arun. That doesn't seem to fix it. Perhaps my syntax is wrong. Here's what I have : P1: BEGIN DECLARE cursor1 CURSOR WITH RETURN FOR IF pSTREET_TYPE = '' THEN Select * from SW.ADDR_VERIFICATION where QUADRANT = pQUAD and STREET = pSTREET...
  3. jtidge

    ibm db2 if statement

    Thanks for the reply Marc. oops. I forgot to put the begin and end back in. When the BEGIN and END are around the outside of the if statement, I get an error on the second cursor delcaration "Unexpected Cursor Declaration" I have also tried putting a BEGIN and END around the SQL...
  4. jtidge

    ibm db2 if statement

    I'm looking over something stupid here. Can someone tell me how to do an if statement that will do the following. I think this is close, but it's not working. Both sql statements work independently. Something crazy that I'm doing with the IF and definition of cursors I think: CREATE...

Part and Inventory Search

Back
Top