Compile 'hangs'
Posted: Mon Oct 02, 2006 6:28 pm
Hi,
This is SCD job, reading from Delta file, with a Join on TD base table and finally inserts / updates the same table. Issue I am facing is, when I compile it simply hangs. It was compiling OK before. I added some null handling statements. If isnull(Link1.col1) then Setnull() else Link1.col1, so that I won't get warnings which I was getting before. I tried to see if TYPOED wrong or kept an extra space. But seems OK. Why the 'Compile' is hanging? Server 7.52 on Sun OS, Client 752 / 751A. Any thoughts.
Thanks,
Rick
This is SCD job, reading from Delta file, with a Join on TD base table and finally inserts / updates the same table. Issue I am facing is, when I compile it simply hangs. It was compiling OK before. I added some null handling statements. If isnull(Link1.col1) then Setnull() else Link1.col1, so that I won't get warnings which I was getting before. I tried to see if TYPOED wrong or kept an extra space. But seems OK. Why the 'Compile' is hanging? Server 7.52 on Sun OS, Client 752 / 751A. Any thoughts.
Thanks,
Rick