Re: [sqr-users] WEIRD SQL STATEMENTS

[rwulfson@bost.com]

Jim - Thanks - I thought it might be platform specific.  I'll modify it for
my database.

Thanks,

Russ Wulfson



                                                                                
                           
                      Jim Wyant                                                 
                           
                      <wyantj@yahoo.com        To:       sqr-users@sqrug.org    
                           
                      >                        cc:                              
                           
                      Sent by:                 Subject:  Re: [sqr-users] WEIRD 
SQL STATEMENTS              
                      sqr-users-admin@s                                         
                           
                      qrug.org                                                  
                           
                                                                                
                           
                                                                                
                           
                      01/02/2003 03:35                                          
                           
                      PM                                                        
                           
                      Please respond to                                         
                           
                      sqr-users                                                 
                           
                                                                                
                           
                                                                                
                           




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




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