I have a $ char in my Oracle user id/schema, DS$DJONI, and have not been able to connect to my Oracle database. I have no problem using any of other user id/schema's that do not have $ char.
How can I resolve (I have to use the DS$DJONI) ?
djoni
$ char in my oracle user id/schema
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I recall reading something about this in the manual. Don't have access to DataStage this week, but I'd hazard the guess that it's the Parallel Job Developer's Guide, and the chapter on the Oracle Enterprise stage. The same problem can arise with DB2. Both "#" and "$" can be troublesome to DataStage; there are substitutions of the form __34__ that you can use in their place.
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.
I tried as per manual, set the DS_ENABLE_RESERVED_CHAR_CONVERT to true. Still the same problem. As the manual says, this parameter is for handling $ char in column name, not in schema/user id.ray.wurlod wrote:I recall reading something about this in the manual. Don't have access to DataStage this week, but I'd hazard the guess that it's the Parallel Job Developer's Guide, and the chapter on the Oracle Enterprise stage. The same problem can arise with DB2. Both "#" and "$" can be troublesome to DataStage; there are substitutions of the form __34__ that you can use in their place.
Any other idea?
djoni
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: $ char in my oracle user id/schema
I got the answer from IBM support: enclosed this kind of Oracle user id with single quotes.
They said it would be fixed in the next release.
djoni
They said it would be fixed in the next release.
djoni
djoni wrote:I have a $ char in my Oracle user id/schema, DS$DJONI, and have not been able to connect to my Oracle database. I have no problem using any of other user id/schema's that do not have $ char.
How can I resolve (I have to use the DS$DJONI) ?
djoni