Re: [sqr-users] WEIRD SQL STATEMENTS

[Jim Wyant <wyantj@yahoo.com>]

I believe the slashes are for DB2 specific dynamic SQL and the "with"
references an index.
Jim

--- rwulfson@bost.com wrote:
> I have an sqr that was provided to me from another company - via a
> new
> employee, who is now on vacation. So I can't ask him about it.  It
> contains
> some syntax that I've never seen.  I was wondering if anyone knows
> what
> this refers to:
> It looks like a form of dynamic sql, but I've never seen the slashes
> used
> this way or the "with" clause????
> 
> FROM \$recname\
> WHERE \$fieldname\ IN (\$Search_String\)
> WITH UR
> 
> Thanks,
> 
> Russ Wulfson
> 
> 
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users