ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » Problem in Generating BO

Post new topic  Reply to topic
 Problem in Generating BO « View previous topic :: View next topic » 
Author Message
pgd
PostPosted: Tue Apr 25, 2006 4:58 am    Post subject: Problem in Generating BO Reply with quote

Newbie

Joined: 06 Apr 2006
Posts: 3

Hi ,

I have tables in database which contains columns seperated by " _"like EMP_NUMBER, but when I am running ODA to generate BO's that "_" is not coming in attribute name, its coming like EMPNUMBER, so pls suggest me what to do. Its urgent pls reply asap.

Thanks in Advance.
Back to top
View user's profile Send private message
Kram
PostPosted: Tue Apr 25, 2006 5:11 am    Post subject: Reply with quote

Voyager

Joined: 02 Mar 2006
Posts: 87

Can you tell whats the ASI information in the ASBO....
_________________
Regards,
Ram
Back to top
View user's profile Send private message
pgd
PostPosted: Tue Apr 25, 2006 5:21 am    Post subject: Problem in Generating BO Reply with quote

Newbie

Joined: 06 Apr 2006
Posts: 3

Hi
In ASI I am getting EMP_NUMBER.

So pls let me know do I nedd to change attribute name manually or it has any alternative method or can I leave that like only.

Bye.
Back to top
View user's profile Send private message
Kram
PostPosted: Tue Apr 25, 2006 5:24 am    Post subject: Reply with quote

Voyager

Joined: 02 Mar 2006
Posts: 87

If the ASI information is having EMP_NUMBER when the sql is generated you will have the column name as EMP_NUMBER. I dont think you need to worry reg the attribute since its just a name..

you can even have temp in attribute , but if the ASI information is what is important. based on what you said i think ASI is having the correct information... do a test run and pull the connector trace file(increase the trace level and log level to 5) and check the sql generated ....
_________________
Regards,
Ram
Back to top
View user's profile Send private message
RocknRambo
PostPosted: Tue Apr 25, 2006 6:57 am    Post subject: Reply with quote

Partisan

Joined: 24 Sep 2003
Posts: 355

If ur using WBIA framework 2.6, the ODA removes the underscores in the Attribute names .. but you do see correct column name in the ASI ,.. 'CN = '



-RR
Back to top
View user's profile Send private message
pgd
PostPosted: Tue Apr 25, 2006 7:41 pm    Post subject: Problem in Generating BO Reply with quote

Newbie

Joined: 06 Apr 2006
Posts: 3

Hi,
Thanks for the reply. As RocknRambo said if we use WBIA 2.6 frame work we won't get "_" but in my case I need that "_" in my attributes name. What I need to do. And I am using 2.6 Framework only.

Thanks in Advance.
Back to top
View user's profile Send private message
vk
PostPosted: Tue Apr 25, 2006 8:52 pm    Post subject: Reply with quote

Partisan

Joined: 20 Sep 2005
Posts: 302
Location: Houston

Once the ODA creates the BO, you can modify the names however you want. Only the CN value in Application Specific Information should match the actual column name.

You can open the BO anytime in BO Designer and make the necessary changes to the attribute names.

Regards,
VK.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Interchange Server + Adapters » Problem in Generating BO
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.