Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Whenever I run a script that has a join (I have mainly used left joins) the application crashes and shuts down. I have run the script on another machine and it works fine. I can run normal load stateemnts, but when I use joins the applications dies.
Is this a problem only for very large datasets? Or is it a problem all the time? If the latter, it's probably a syntax problem. If it's the former, can you try using "keep" instead of join? That's helped me before.
Thsi occurs with any dataset. I have even tried creating two small inline files and link them with a left join. One one machine the code works, while on anotehr it does not.