"Load SQL from file" option for Before/After stage

shankar_ramanath · Post by **shankar_ramanath** » Wed Mar 24, 2010 12:12 pm

Hi,

I am trying to use "Load SQL from file" option in the Before/After tabs in the DB2 UDB stage in a Parallel job. The job hangs, but works fine if I use the same option in the "Main Query" tab.

I am wondering if anyone has used this option with Before/After tabs.

Thanks,

chulett · Post by **chulett** » Wed Mar 24, 2010 2:49 pm

No can do, from everything I've seen that's "Main Query Tab" functionality only.

shankar_ramanath · Post by **shankar_ramanath** » Wed May 26, 2010 12:51 pm

Using the {FILE}/pathname.sql works for Before/After tab as well.

I am not sure if this has anything to do with Fix Patch 1 for Version 8.1 that we applied recently.

But it works!!!

chulett · Post by **chulett** » Wed May 26, 2010 5:49 pm

Hmmm... very interesting. Anyone know for certain?

shankar_ramanath · Post by **shankar_ramanath** » Fri Jun 11, 2010 7:23 pm

chulett wrote:Hmmm... very interesting. Anyone know for certain?

Not to sound too complacent, but more to be of help to other visiting this post.

This stuff really works and the code is in Production :D

chulett · Post by **chulett** » Fri Jun 11, 2010 9:29 pm

shankar_ramanath wrote:I am not sure if this has anything to do with Fix Patch 1 for Version 8.1 that we applied recently.

chulett in reply wrote:Hmmm... very interesting. Anyone know for certain?

shankar_ramanath then wrote:Not to sound too complacent, but more to be of help to other visiting this post. This stuff really works and the code is in Production

Complacent?

Hopefully this quoting makes the meaning of my comment more apparent. I wasn't questioning whether it "really worked" or not but was asking re: your doubts with recently applied Fix Pack 1.

shankar_ramanath · Post by **shankar_ramanath** » Sun Jun 13, 2010 8:41 am

OK. I did not realize that the comment was specific to FP 8.1 as I took it as a general response to my posting. Sorry.