I am using Oracle OCI stage input.
Under Input > Sql tab > userdefined ,generated ddl,usedefined ddl tabs got disabled . Please let me know how to enable this option. Which settings have to look into ?
Oracle oci stage options
Moderators: chulett, rschirm, roy
Oracle oci stage options
Thanks
MRVSR
MRVSR
Be more specific with regards to the tabs, exactly what do you mean by they 'got disabled'? You'll never be able to do anything other than look at the DML or DDL on any 'Generated' tab. Any 'user defined' tab will be disabled (as in 'grayed out' or unselectable) if the corresponding Update / Create table / Drop table actions are set to some sort of generated option.
If that's what you are seeing, that's all perfectly normal behaviour.
If that's what you are seeing, that's all perfectly normal behaviour.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Re: Oracle oci stage options
i think these tabs are always disabled.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
"Update existing rows only" is NOT "user-defined SQL". Examine the list of possibilities a little more closely.
However, the DDL tabs are only enabled when you check the "create table" check box on the General tab. I misread your original post.
However, the DDL tabs are only enabled when you check the "create table" check box on the General tab. I misread your original post.
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.
Re: Oracle oci stage options
thank you ray !!