Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
bayne1j
Participant
Posts: 5 Joined: Mon Apr 03, 2006 4:02 am
Post
by bayne1j » Mon Oct 09, 2006 6:28 am
I have to load a table into an oracle database where the schema owner ID contains a $. As the Oracle userID that I am using does not own the table, I have to prefix the table name with the schema owner name in the Oracle Enterprise stage.
When I run the job it fails with the following error:
main_program: Fatal Error: Invalid character $ encountered in table OPS$OWNER.TABLENAME
I have tried adding the environment variable DS_ENABLE_RESERVED_CHAR_CONVERT and setting this to true but this does not seem to work for special characters in the table owner name.
Any ideas?
J
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon Oct 09, 2006 3:51 pm
Welcome aboard. :D
Try surrounding the owner name in double quotes. For example "OPS$OWNER".TABLENAME
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
bayne1j
Participant
Posts: 5 Joined: Mon Apr 03, 2006 4:02 am
Post
by bayne1j » Tue Oct 10, 2006 1:48 am
Thanks for the reply.
I have tried surrounding in quotes but still get the same error
thumsup9
Charter Member
Posts: 168 Joined: Fri Feb 18, 2005 11:29 am
Post
by thumsup9 » Tue Oct 10, 2006 7:59 am
ray.wurlod wrote: Welcome aboard. :D
Try surrounding the owner name in double quotes. For example "OPS$OWNER".TABLENAME
what happens when you SET QUOTED_IDENTIFER ON and then use the above example suggested by Ray
thumsup9
Charter Member
Posts: 168 Joined: Fri Feb 18, 2005 11:29 am
Post
by thumsup9 » Tue Oct 10, 2006 8:12 am
ray.wurlod wrote: Welcome aboard. :D
Try surrounding the owner name in double quotes. For example "OPS$OWNER".TABLENAME
what happens when you SET QUOTED_IDENTIFER ON and then use the above example suggested by Ray
bayne1j
Participant
Posts: 5 Joined: Mon Apr 03, 2006 4:02 am
Post
by bayne1j » Tue Oct 10, 2006 9:38 am
Is QUOTED_IDENTIFIER an environment variable? I can't seem to find it....