User defined sql table definition

wdudek · Post by **wdudek** » Fri Aug 20, 2004 3:01 pm

I have a question regarding user defined sql, specifically in the oracle stage. A colleague says that he did not have to create the output columns when he used user defined sql, but instead that they were created for him. He has never been able to duplicate this, so is it possible to have the columns for user defined sql automatically created, or do you need to type them into the output link yourself? I'm talking about column definitions for output, not the sql itself.

Thanks,

Bill

ds_developer · Post by **ds_developer** » Fri Aug 20, 2004 3:09 pm

Within a transformer you can select the columns on the left and drop them on the Column Name portion of a link on the right. This will result in the output columns being populated.

Is this what you mean?

John

tonystark622 · Post by **tonystark622** » Fri Aug 20, 2004 3:10 pm

Not as far as I know, Bill.

Tony

ray.wurlod · Post by **ray.wurlod** » Fri Aug 20, 2004 6:17 pm

It's true in the ODBC stage, provided you load the column definitions with "generated SQL" selected then later switch to "user defined SQL"; maybe that's what he was using?

chulett · Post by **chulett** » Fri Aug 20, 2004 6:25 pm

The other option is "Fully Generated SQL", I believe. From what I recall, after you build the query you can click the 'Synchronize' button and it will create whatever columns are required to support the query. I think. I tend to avoid that particular way of doing things.

tonystark622 · Post by **tonystark622** » Fri Aug 20, 2004 7:54 pm

Oooh. I never thought of that. I don't think I've ever actually a used fully generated query. Hmmm...

Tony

wdudek · Post by **wdudek** » Mon Aug 23, 2004 12:43 pm

Thanks, he was using the ODBC stage while I was using the Oracle stage.