Error during lookup

chulett · Post by **chulett** » Mon Jul 24, 2006 10:46 pm

Handle what by itself? Using a job parameter for the schema name? Both of these suggestions just go in the 'Table Name' box, no need for user defined sql just for that.

dsdoubt · Post by **dsdoubt** » Tue Jul 25, 2006 6:40 pm

Now I got what you mean, while 'Build'ing the sql, in the 'Table Name' option we can give the parameter.
Thanks for this.

chulett · Post by **chulett** » Tue Jul 25, 2006 8:46 pm

Yup, exactly.

And rather than use the 'SQL Builder tool' to create your source queries, I much prefer the 'Generate SELECT clause from column list; enter other clauses' way of doing things. I wouldn't touch the Builder with a thirty-nine and a half foot pole. That long 'Generate' option is what used to be called simply 'Column Generated' in the earlier versions.

Save the user-defined or custom sql for those times when you have absolutely no other choice.