here is what i got...my takeaways are that the blanks coming across the network are a factor (at least for our driver) and like the community suggested , waiting to...

• This reply was modified 1 month, 1 week ago by  stan.

thx frederico, i might be  misunderstanding.

that view is doing the trimming over on the linked server (sql server) side, not db2.   are you saying it might help to put all...

• This reply was modified 1 month, 1 week ago by  stan.

thx jeffrey.  there is no join and we want the whole table.  i was a little confused by these 2 statements   which seem to contradict each other...

or add a where...

thx ken, what are the decent odbc drivers for db2?

and at a high level will i be running wireshark while this issue is occurring and show some sort of output...

• This reply was modified 1 month, 1 week ago by  stan.

thx, it is not on this site.   it is a site dedicated to netsuite.   the link i use there is https://community.oracle.com/netsuite/english/post/question/ask-a-guru    .

they have ok'd posting the same...

• This reply was modified 1 month, 1 week ago by  stan.
• This reply was modified 1 month, 1 week ago by  stan.

thx kaj , he cant throw or raise what he cant intercept.  and he would try to do that or handle it in sp1 if he first gets convinced he...

• This reply was modified 1 month, 2 weeks ago by  stan.

my peer believes this scenario has reared its ugly head again.   Something tells me we addressed this once  before by checking a 2nd sql built in count or flag along...

thx Jeff.  He doesnt do any THROWS.

In this case he doesnt have that opportunity in sp2 before control bubbles back up to sp1.

yes he uses xaxt_abort but still at least...

thx jeff.   i believe what we used to solve this went as follows.   i was talking our dba thru this because he has permissions where we wanted it done.  i...

• This reply was modified 1 month, 3 weeks ago by  stan.
• This reply was modified 1 month, 3 weeks ago by  stan.

thx frederico.   we understand.

i thought i responded to this already.  jeff i dont get what you are saying but a peer claims a synonym for the linked server name itself is forbidden.  i'll...

not sure what you are asking Jeff.   I'm going on the word of someone here who said he tried it and got an error that specifically forbids syns on linked...

thx Brian.   This is really interesting.  In the meantime we have proven that creating a linked server whose name is db1 but plumbing is server1.db1 does work with 0 code...

• This reply was modified 1 month, 3 weeks ago by  stan.

thx Brian, Jeff, Ken.   I'm reading the polybase thing now.

I didnt think it mattered but now i should mention that server2 is destined for 2022.  Server1 is stuck on 2019...

• This reply was modified 1 month, 3 weeks ago by  stan.
• This reply was modified 1 month, 3 weeks ago by  stan.
• This reply was modified 1 month, 3 weeks ago by  stan.

thx jeff.  we just learned synonyms dont work with (arent allowed on) linked servers.   But something was bothering us and it goes like this...

our theory (from other experiences) is that...