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
snassimr,
the parsing mechansim in DS will attempt to use the # character as a delimiter, so you would have to quote it. How you go about it depends upon which stage you are using - which is it?
the parsing mechansim in DS will attempt to use the # character as a delimiter, so you would have to quote it. How you go about it depends upon which stage you are using - which is it?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
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