Any limitation in the Userdefined query tab in Oracle/DRS St

Anishn · Post by **Anishn** » Sat Feb 12, 2011 8:35 pm

Hi,
I have create one job which has about 150 lines of sql. So i tried using the Oracle Enterprise Stage and DRS Stage in 8.0.1 Version. It was not allowin after some line of sql. Can any one help me to solve this.Thank you.

chulett · Post by **chulett** » Sat Feb 12, 2011 10:15 pm

One answer would be to create a view from the overly large SQL and then source from the view.

Anishn · Post by **Anishn** » Sat Feb 12, 2011 11:06 pm

Yes Chulett. Thank you for the reply.

I did the same, but i thought there might be the limitation in the Datastage,may be someone knows...how many lines it will allows normally do you have any idea...i am just curious to know..

chulett · Post by **chulett** » Sat Feb 12, 2011 11:35 pm

You did ask how to solve it, hence my response. Last time I had the same question, I asked IBM. Some details could have changed in the last couple of years but should be close.

Anishn · Post by **Anishn** » Sat Feb 12, 2011 11:47 pm

Sorry for misleading Chulette. Thank you for the information.