trying to setup the Oracle EE stage.
I can view data from ORCL stage with out ENV parameter or password that contains $.
i have also changed the ENV parameter DS_ENABLE_RESERVED_CHAR_CONVERT to true also.do i need to stop the DataStage after this parameter is set it true ? .anything else i need to do ?
here is the error message when my db password contains.
Incorrect dboption list; it failed on Expected "," or "}", got: "$", line 1.
Thanks for your time in Advance.
Can n't Read data from ORCL EE Stage with ENV parms or
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Thu Jul 26, 2007 6:11 am
Can n't Read data from ORCL EE Stage with ENV parms or
Last edited by pimmit22043 on Fri Feb 29, 2008 8:49 am, edited 1 time in total.
-
- Participant
- Posts: 38
- Joined: Thu Jul 26, 2007 6:11 am
-
- Participant
- Posts: 38
- Joined: Thu Jul 26, 2007 6:11 am
I can view data from ORCL stage with out ENV parameter or password that contains $.
i have also changed the ENV parameter DS_ENABLE_RESERVED_CHAR_CONVERT to true also.do i need to stop the DataStage after this parameter is set it true ? .anything else i need to do ?
here is the error message when my db password contains.
Incorrect dboption list; it failed on Expected "," or "}", got: "$", line 1.
Thanks for your time in Advance.
i have also changed the ENV parameter DS_ENABLE_RESERVED_CHAR_CONVERT to true also.do i need to stop the DataStage after this parameter is set it true ? .anything else i need to do ?
here is the error message when my db password contains.
Incorrect dboption list; it failed on Expected "," or "}", got: "$", line 1.
Thanks for your time in Advance.
-RK
How does it help to simply repeat your original post?
viewtopic.php?t=100596
All of which you could have found by seaching. (hint,hint)
![Confused :?](./images/smilies/icon_confused.gif)
If you found that environment variable in the docs, then you should have also seen that it only applies to # and $ characters in column names so it won't help you here.pimmit22043 wrote:i have also changed the ENV parameter DS_ENABLE_RESERVED_CHAR_CONVERT to true also.do i need to stop the DataStage after this parameter is set it true ? .anything else i need to do ?
Known issue. Searching the forums for your error message would have revealed that. Here is the post that has the eCase number you'll need to request the patch that fixes this problem. That and you'll need to put the password in single quotes.pimmit22043 also wrote:here is the error message when my db password contains.
Incorrect dboption list; it failed on Expected "," or "}", got: "$", line 1.
viewtopic.php?t=100596
All of which you could have found by seaching. (hint,hint)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers