Hi !!!
I can't solve some problem .
My Table Name contain # and I dont succeed to read data
with SQL that Datastage creates .
It include " from two sides of table name
Does anybodu know how to deal with this problem ?
# Problem In Table Name
Moderators: chulett, rschirm, roy
Hi snassimr,
In DataStage if you use # DS interprets it as start of Job parameter.
When you have a query with job parameters bieng used you use where SCHEMA and TABLE_NAME are job parameters.
to parse # as literal use back slash as escape character and try.
Regards
In DataStage if you use # DS interprets it as start of Job parameter.
When you have a query with job parameters bieng used you use
Code: Select all
SELECT * FROM #SCHEMA#.#TABLE_NAME#
to parse # as literal use back slash as escape character and try.
Regards
Happy DataStaging
As noted, it would be nice to know what database and stage you are asking about. Oracle (and others for all I know) have the ability to handle pound and dollar signs in table names by using the following substitutes:
Note that there are two underscores on either side of the numbers. Check the documentation for the specific stage type you are using to see if this is the solution for you.
Code: Select all
# = __035__
$ = __036__
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom