Post reply

Table Locks Problem

  • March 15, 2010 at 1:55 am

    #1133549

    The last of the three I got now. Please let me know if you need more info

    Blocked stmt

    (@P1 nchar(12),@P2 float,@P3 float)

    SELECT * FROM JDE_PRODUCTION.PRODDTA.F4941

    WHERE ( RSVMCU = @P1 AND RSLDNM = @P2 AND RSTRPL = @P3 ) ORDER BY RSVMCU ASC,RSLDNM ASC,RSSTSQ ASC

    BLOCKING STMT

    (@P1 float)SELECT * FROM JDE_PRODUCTION.PRODDTA.F4215 WHERE ( XHSHPN = @P1 )

    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    Do not reinvent the wheel.
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply