# Problem In Table Name

snassimr · Post by **snassimr** » Tue May 31, 2005 4:33 am

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 ?

ArndW · Post by **ArndW** » Tue May 31, 2005 5:03 am

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?

dsxdev · Post by **dsxdev** » Tue May 31, 2005 5:37 am

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

Code: Select all

SELECT * FROM #SCHEMA#.#TABLE_NAME#

where SCHEMA and TABLE_NAME are job parameters.
to parse # as literal use back slash as escape character and try.

Regards

chulett · Post by **chulett** » Tue May 31, 2005 6:53 am

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:

Code: Select all

# = __035__
$ = __036__

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.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue May 31, 2005 8:53 am

Try making the tablename as a job parameter and include the '#' as part the of name there.

snassimr · Post by **snassimr** » Tue May 31, 2005 8:55 am

Accordin to datastage table name with # is included
with " " , "Ravle#p" but I want to know how the query should be to get results ob DB2 OS/400
Now the query is hung up with query generated by Datastage