Special characters in column name
Moderators: chulett, rschirm, roy
Special characters in column name
Hi All
I want to insert records into a db2 table which is having special character '@' in its name. The column names also contains the same special character in it. For example, table name is SS@CRM and columns in this table are Z@CTCD.
I need to insert into this table using db2 enterprise stage. Since the metadata can not have special characters in its name.
I am using DataStage 7x PX.
How can we handle this. Suggestions are most welcome on this.
Thanks,
I want to insert records into a db2 table which is having special character '@' in its name. The column names also contains the same special character in it. For example, table name is SS@CRM and columns in this table are Z@CTCD.
I need to insert into this table using db2 enterprise stage. Since the metadata can not have special characters in its name.
I am using DataStage 7x PX.
How can we handle this. Suggestions are most welcome on this.
Thanks,
Braj
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
We can't deal with "not working". It's inexact. Please post the exact error message that you get.
Meanwhile consider creating a synonym for this column, where the synonym does not have any special characters in its name. Use the synonym in your job design.
Meanwhile consider creating a synonym for this column, where the synonym does not have any special characters in its name. Use the synonym in your job design.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
[quote="ray.wurlod"]We can't deal with "not working". It's inexact. Please post the exact error message that you get.
Meanwhile consider creating a synonym for this column, where the synonym does not have any specia ...[/quote]
Hi
Please find below the error message I got when tried to enclose column name within duoble quotes.
Error: The name must begin with an alphabetic character and consist of alpha-numerics, underscores, and periods only.
Thanks,
Brajesh
Meanwhile consider creating a synonym for this column, where the synonym does not have any specia ...[/quote]
Hi
Please find below the error message I got when tried to enclose column name within duoble quotes.
Error: The name must begin with an alphabetic character and consist of alpha-numerics, underscores, and periods only.
Thanks,
Brajesh
Braj
Hibraj wrote:Hiray.wurlod wrote:We can't deal with "not working". It's inexact. Please post the exact error message that you get.
Meanwhile consider creating a synonym for this column, where the synonym does not have any specia ...
Please find below the error message I got when tried to enclose column name within duoble quotes.
Error: The name must begin with an alphabetic character and consist of alpha-numerics, underscores, and periods only.
Thanks,
Brajesh
Can anyone advise on this.
Regards
Brajesh
Braj
-
- Premium Member
- Posts: 99
- Joined: Mon Sep 03, 2007 7:49 am
- Location: Stockholm, Sweden
What read method and what write method are you using? have you imported the table definitions into datastage? And if so using what importer?
-------------------------------------
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: