--
Hi,
Perhaps someone has already had this kind of problem.
We are working on a table ##T.BSLPRD.
But the ## is elliminated before executing the query in the database
system.
Surrounding the ##t with single or double quotes have not resolved the
problem.
regards
Johan
***********************************************************************************
This message should only be read by those persons to whom it is
addressed, and may contain confidential information, the disclosure
of which is prohibited. This message is not intended to create rights
or obligations without subsequent written confirmation of its contents.
If you have received this message in error, please notify us immediately
***********************************************************************************
--=_alternative 00457BB8C1256DCF_=--
## tablename not possible
## tablename not possible
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
## tablename not possible
## indicates start end end of a job parameter, so you can't do it like that.
Perhaps you can make a job parameter with the value ##
Call it Table_Name_Parm = '##'
and reference it in your DB stage as #Table_Name_Parm#T.BSLPRD
br
Tom
Tom Peter Nielsen
Project Masterdata & Transformation
Reg.nr. 5486 / CB T400
Nordea Bank Denmark
Phone: +45 33335223
-----Original Message-----
From: johan.stie@sidmar.arcelor.com
[mailto:johan.stie@sidmar.arcelor.com]
Sent: 30. oktober 2003 13:39
To: datastage-users@oliver.com
Subject: ## tablename not possible
--
Hi,
Perhaps someone has already had this kind of problem.
We are working on a table ##T.BSLPRD.
But the ## is elliminated before executing the query in the database
system.
Surrounding the ##t with single or double quotes have not resolved the
problem.
regards
Johan
***********************************************************************************
This message should only be read by those persons to whom it is
addressed, and may contain confidential information, the disclosure
of which is prohibited. This message is not intended to create rights
or obligations without subsequent written confirmation of its contents.
If you have received this message in error, please notify us immediately
***********************************************************************************
Perhaps you can make a job parameter with the value ##
Call it Table_Name_Parm = '##'
and reference it in your DB stage as #Table_Name_Parm#T.BSLPRD
br
Tom
Tom Peter Nielsen
Project Masterdata & Transformation
Reg.nr. 5486 / CB T400
Nordea Bank Denmark
Phone: +45 33335223
-----Original Message-----
From: johan.stie@sidmar.arcelor.com
[mailto:johan.stie@sidmar.arcelor.com]
Sent: 30. oktober 2003 13:39
To: datastage-users@oliver.com
Subject: ## tablename not possible
--
Hi,
Perhaps someone has already had this kind of problem.
We are working on a table ##T.BSLPRD.
But the ## is elliminated before executing the query in the database
system.
Surrounding the ##t with single or double quotes have not resolved the
problem.
regards
Johan
***********************************************************************************
This message should only be read by those persons to whom it is
addressed, and may contain confidential information, the disclosure
of which is prohibited. This message is not intended to create rights
or obligations without subsequent written confirmation of its contents.
If you have received this message in error, please notify us immediately
***********************************************************************************
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
## tablename not possible
Thanks,
But it seems that datastage does the translation of the parameter into ##
and eliminates the ## ...strange.
Johan
tom.peter.nielsen@nordea.com
30/10/2003 13:49
Please respond to datastage-users
To: datastage-users@oliver.com
cc:
Subject: RE: ## tablename not possible
## indicates start end end of a job parameter, so you can't do it like
that.
Perhaps you can make a job parameter with the value ##
Call it Table_Name_Parm = '##'
and reference it in your DB stage as #Table_Name_Parm#T.BSLPRD
br
Tom
Tom Peter Nielsen
Project Masterdata & Transformation
Reg.nr. 5486 / CB T400
Nordea Bank Denmark
Phone: +45 33335223
-----Original Message-----
From: johan.stie@sidmar.arcelor.com
[mailto:johan.stie@sidmar.arcelor.com]
Sent: 30. oktober 2003 13:39
To: datastage-users@oliver.com
Subject: ## tablename not possible
--
Hi,
Perhaps someone has already had this kind of problem.
We are working on a table ##T.BSLPRD.
But the ## is elliminated before executing the query in the database
system.
Surrounding the ##t with single or double quotes have not resolved the
problem.
regards
Johan
***********************************************************************************
This message should only be read by those persons to whom it is
addressed, and may contain confidential information, the disclosure
of which is prohibited. This message is not intended to create rights
or obligations without subsequent written confirmation of its contents.
If you have received this message in error, please notify us immediately
***********************************************************************************
--=_alternative 004F2E71C1256DCF_=--
But it seems that datastage does the translation of the parameter into ##
and eliminates the ## ...strange.
Johan
tom.peter.nielsen@nordea.com
30/10/2003 13:49
Please respond to datastage-users
To: datastage-users@oliver.com
cc:
Subject: RE: ## tablename not possible
## indicates start end end of a job parameter, so you can't do it like
that.
Perhaps you can make a job parameter with the value ##
Call it Table_Name_Parm = '##'
and reference it in your DB stage as #Table_Name_Parm#T.BSLPRD
br
Tom
Tom Peter Nielsen
Project Masterdata & Transformation
Reg.nr. 5486 / CB T400
Nordea Bank Denmark
Phone: +45 33335223
-----Original Message-----
From: johan.stie@sidmar.arcelor.com
[mailto:johan.stie@sidmar.arcelor.com]
Sent: 30. oktober 2003 13:39
To: datastage-users@oliver.com
Subject: ## tablename not possible
--
Hi,
Perhaps someone has already had this kind of problem.
We are working on a table ##T.BSLPRD.
But the ## is elliminated before executing the query in the database
system.
Surrounding the ##t with single or double quotes have not resolved the
problem.
regards
Johan
***********************************************************************************
This message should only be read by those persons to whom it is
addressed, and may contain confidential information, the disclosure
of which is prohibited. This message is not intended to create rights
or obligations without subsequent written confirmation of its contents.
If you have received this message in error, please notify us immediately
***********************************************************************************
--=_alternative 004F2E71C1256DCF_=--
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
## tablename not possible
Johan
Create a parameter like PP and default it ##. Change your tablename to
#PP#.
Thanks Kim.
Kim Duke
DsWebMon - Safely Monitor DataStage from the Web
www.Duke-Consulting.com
-----Original Message-----
From: johan.stie@sidmar.arcelor.com
[mailto:johan.stie@sidmar.arcelor.com]
Sent: Thursday, October 30, 2003 8:25 AM
To: datastage-users@oliver.com
Subject: RE: ## tablename not possible
Thanks,
But it seems that datastage does the translation of the parameter into
##
and eliminates the ## ...strange.
Johan
tom.peter.nielsen@nordea.com
30/10/2003 13:49
Please respond to datastage-users
To: datastage-users@oliver.com
cc:
Subject: RE: ## tablename not possible
## indicates start end end of a job parameter, so you can't do it like
that.
Perhaps you can make a job parameter with the value ##
Call it Table_Name_Parm = '##'
and reference it in your DB stage as #Table_Name_Parm#T.BSLPRD
br
Tom
Tom Peter Nielsen
Project Masterdata & Transformation
Reg.nr. 5486 / CB T400
Nordea Bank Denmark
Phone: +45 33335223
-----Original Message-----
From: johan.stie@sidmar.arcelor.com
[mailto:johan.stie@sidmar.arcelor.com]
Sent: 30. oktober 2003 13:39
To: datastage-users@oliver.com
Subject: ## tablename not possible
--
Hi,
Perhaps someone has already had this kind of problem.
We are working on a table ##T.BSLPRD.
But the ## is elliminated before executing the query in the database
system.
Surrounding the ##t with single or double quotes have not resolved the
problem.
regards
Johan
************************************************************************
***********
This message should only be read by those persons to whom it is
addressed, and may contain confidential information, the disclosure
of which is prohibited. This message is not intended to create rights
or obligations without subsequent written confirmation of its contents.
If you have received this message in error, please notify us immediately
************************************************************************
***********
Create a parameter like PP and default it ##. Change your tablename to
#PP#.
Thanks Kim.
Kim Duke
DsWebMon - Safely Monitor DataStage from the Web
www.Duke-Consulting.com
-----Original Message-----
From: johan.stie@sidmar.arcelor.com
[mailto:johan.stie@sidmar.arcelor.com]
Sent: Thursday, October 30, 2003 8:25 AM
To: datastage-users@oliver.com
Subject: RE: ## tablename not possible
Thanks,
But it seems that datastage does the translation of the parameter into
##
and eliminates the ## ...strange.
Johan
tom.peter.nielsen@nordea.com
30/10/2003 13:49
Please respond to datastage-users
To: datastage-users@oliver.com
cc:
Subject: RE: ## tablename not possible
## indicates start end end of a job parameter, so you can't do it like
that.
Perhaps you can make a job parameter with the value ##
Call it Table_Name_Parm = '##'
and reference it in your DB stage as #Table_Name_Parm#T.BSLPRD
br
Tom
Tom Peter Nielsen
Project Masterdata & Transformation
Reg.nr. 5486 / CB T400
Nordea Bank Denmark
Phone: +45 33335223
-----Original Message-----
From: johan.stie@sidmar.arcelor.com
[mailto:johan.stie@sidmar.arcelor.com]
Sent: 30. oktober 2003 13:39
To: datastage-users@oliver.com
Subject: ## tablename not possible
--
Hi,
Perhaps someone has already had this kind of problem.
We are working on a table ##T.BSLPRD.
But the ## is elliminated before executing the query in the database
system.
Surrounding the ##t with single or double quotes have not resolved the
problem.
regards
Johan
************************************************************************
***********
This message should only be read by those persons to whom it is
addressed, and may contain confidential information, the disclosure
of which is prohibited. This message is not intended to create rights
or obligations without subsequent written confirmation of its contents.
If you have received this message in error, please notify us immediately
************************************************************************
***********
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
## tablename not possible
I once had this problem.
You can reference a table with ## in by executing "User defined SQL file",
an option in the stage.
"User defined SQL" may also work.
Make the SQL file name a parameter so you can change SQL fairly dynamically.
-Craig
-----Original Message-----
From: johan.stie@sidmar.arcelor.com [mailto:johan.stie@sidmar.arcelor.com]
Sent: Thursday, October 30, 2003 5:39 AM
To: datastage-users@oliver.com
Subject: ## tablename not possible
--
Hi,
Perhaps someone has already had this kind of problem.
We are working on a table ##T.BSLPRD.
But the ## is elliminated before executing the query in the database
system.
Surrounding the ##t with single or double quotes have not resolved the
problem.
regards
Johan
****************************************************************************
*******
This message should only be read by those persons to whom it is
addressed, and may contain confidential information, the disclosure
of which is prohibited. This message is not intended to create rights
or obligations without subsequent written confirmation of its contents.
If you have received this message in error, please notify us immediately
****************************************************************************
*******
You can reference a table with ## in by executing "User defined SQL file",
an option in the stage.
"User defined SQL" may also work.
Make the SQL file name a parameter so you can change SQL fairly dynamically.
-Craig
-----Original Message-----
From: johan.stie@sidmar.arcelor.com [mailto:johan.stie@sidmar.arcelor.com]
Sent: Thursday, October 30, 2003 5:39 AM
To: datastage-users@oliver.com
Subject: ## tablename not possible
--
Hi,
Perhaps someone has already had this kind of problem.
We are working on a table ##T.BSLPRD.
But the ## is elliminated before executing the query in the database
system.
Surrounding the ##t with single or double quotes have not resolved the
problem.
regards
Johan
****************************************************************************
*******
This message should only be read by those persons to whom it is
addressed, and may contain confidential information, the disclosure
of which is prohibited. This message is not intended to create rights
or obligations without subsequent written confirmation of its contents.
If you have received this message in error, please notify us immediately
****************************************************************************
*******
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.