When we run SQL queries from any sql editor against our mainframe db2 tables, we are asked to use the with UR.  Note: We only are allowed 'read-only' access to this database.    Q. I'm not totally familiar with the isolation methods, but wondering if 'with UR' can be used in Proc SQL.   Q. If syntax not allowed, how does SAS handle that method? ... View more

Others have posted here about why certain function names don't work.  It is suggested you can't use a reserved name. The solution to one problem was posted as 'Well I don't know why' - just use a different function name. I get that.  Like the sample below, 'convert' does not work but _convert would.  But I would like some reference to know what the naming rules are.  I've searched for days - any help appreciated.   Example: %let outlib = work; * Example 2: Return a Character Value; proc fcmp outlib=&outlib..functions.conversions; *function lb2kgC(lb) $;   *--this works; function convert(lb) $;  *-- this does NOT work; length kg $10; kg = catt(put((lb/2.2),6.2),'Kg'); return (kg); endsub; run; ... View more