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
User defined sql table definition
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 224
- Joined: Tue Sep 24, 2002 7:32 am
- Location: Denver, CO USA
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 483
- Joined: Thu Jun 12, 2003 4:47 pm
- Location: St. Louis, Missouri USA