Requesting help with speed in reading DB2 tables?

[novinosrin]

Sir @Patrick   Unfortunately yes. The fact of the matter is the admins(while kind and nice guys) just seem not to know how to get the SQL pass through to work. What they said is, if I can figure it out they are more than happy to endorse it. Also, my team(credit risk) and admins et al(sas others here seem puzzled with all the suggestions I could give, be it code logic approaches/other stuff in SAS. On the one side, I kinda lost my excitement, but the moolah is good. It has given me the impression, as long as the economy is good, one/I can make moolah doing very little aka a day's job like during my parent's times, you remain in one place, do the job and go home to family. So in that regard, nothing to complain. You get my feeling. 🙂

Thank you/all in this thread again for everything for your patience and time. 

[SASKiwi]

@novinosrin - Have you tried working with SAS Tech Support on this? In my experience they are very helpful, even to the extent of remoteing into your computer for tricky issues so they see exactly how your environment works. Your call at the end of the day though.

[novinosrin]

Good morning/evening Sir @SASKiwi  No, I haven't. I did contemplate on doing that though. But the problem is the compliance works in this fashion-

1. Justify to your team this is a good idea

2. Then justify to SAS admins/DB2 admins that this is a good idea

3. Send an email along with a ticket with complete reasoning

4. The manager will have to look and take the decision

5. And then you can contact SAS tech support

Sounds simple? Well, I noticed in some to many to be very unwilling to improvise things in all spheres. The tendency is keep this as-is, so that our grand kids and great grand kids can also run the same. Oh well, I give in to it and will have to care less.

PS I said this to my uncle last night, and my uncle opined "hey, you do not have any commitments, responsibilities whatsoever, also being the only child to your parents who have made sure you have all the necessary comfort and security without you doing anything, you may want to implement all sorts of ideas, however think about the rest, survival is the key". So he basically asked me  to shut up! 🙂 

[Kurt_Bremser]

Well, if you have to deal with such business process, then I'd say you wait until someone who's "important" complains about the low performance.

Sometimes you have to let bad practices choke on themselves. I call it "Sabotage by Following the Rules" 😉

[novinosrin]

So true. I think I am learning Life-lessons in general. Hmm, should say particularly in place of work considering the specifics, namely people's dynamic such as insecure feelings, getting distressed and panicky over nothing yet being able to convince the upper management and beyond that these are the best processes on planet earth. Finding ways for safe and comfortable survival so that it's easy to make ends-meet and live a comfortable life and so on and so forth. 

So it seems the obvious to expect which a person like me has not been through exact experiences considering my very short career life so far.

On the other hand in life,, reminiscing the thoughts of my past that somebody born with childhood-dyslexia, then bullied in primary and high school/relatives, and going through many many more events/episodes of extreme depression to the extent contemplating to call it a day in life and beyond,and still trying to put up a fight with my own self to stay afloat . Oh well, all the above drama seems to pale so much in comparison only to feel funny to show a faint smile 

PS my sincere apologies to have slightly deviated from main topic. Thank you listening to my emotional rant 🙂

[SASKiwi]

Of course the other option is to go and work at a more intelligent organisation where worker satisfaction and happiness is likely to be much higher...

[novinosrin]

True. Funnily enough, I learned there are some teams who sit in Johnston, RI office in our company who tend to be more competitive. I might request an internal move if possible. What do you think ?:) 1000 CASE WHEN's to one PROC format CNTNLIN in itself would give me a reason to breathe. lol hahaa

[SASKiwi]

IMHO -  If you find it impossible to promote sensible improvements in your workplace, and the prevailing attitude is let's keep doing things the way we always have, then moving on sounds pretty sensible to me.

[Patrick]

@novinosrin 

Just as a last try to make things work. 

I get it that you didn't manage to formulate an explicit connection string in the Connect statement. But you still have a working library definition and I still don't understand why that should not be working for you.

Can you please execute below code "as is" and post the error log if any?

/* 
  assign library defined in metadata that is not pre-assigned 
  */
%let lref=potbnd;
libname &lref meta liburi="SASLibrary?@Libref='&lref'" metaout=data;

/* explicit pass-through SQL using a library definition to connect to a database */
proc sql;
  connect using &lref as mycon;
  select * from mycon as
  (
    select src_stm_id
    from OTBND.ar
    where src_stm_id in (1,30,42,48,49)
    with UR
  )
  ;
  disconnect from mycon;
quit;

[novinosrin]

Sir @Patrick  First off, You and all in this thread are going out of your way to help me. I have booked some time with the SAS Admin here and he/them will work with me seriously to see if something can be worked out. That "something" is solely refering to this thread and your advice. I request you to bear with me until Wed/Thu and not doubt my courtesy coz I could only get their time on Wed.

PS we are busier than G7 world leaders 🙂 You know what I mean.