BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

valdation SQL Select Statement


 
Search this topic... | Search DI: Information Steward... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Information Steward  Previous TopicPrint TopicNext Topic
Author Message
vsu
Forum Member
Forum Member



Joined: 15 May 2012

Posts: 14



PostPosted: Mon Aug 20, 2012 3:26 am 
Post subject: valdation SQL Select Statement

Hi Guys,

I looking for the statement

Table : TIN_IRxxx_MXXXXX
Field Name : IRXX_TiXXXX


Rules : valid Rules= Mr,Mrs,Miss,Ms,Dr,Prof,Adv,Rev
when title : Mr,then Sex= male
when tiele: ;Mrs' or 'Ms',or 'MISS' then Sex =female

please give the Select statement for the above.

regards,
vsu
Back to top
Johannes Vink
Forum Enthusiast
Forum Enthusiast



Joined: 20 Mar 2012

Posts: 1138


flag
PostPosted: Mon Aug 20, 2012 5:54 am 
Post subject: Re: valdation SQL Select Statement

And what do you think that it should be?
Back to top
ganeshxp
Forum Addict
Forum Addict



Joined: 17 Jul 2008
ASUG Icon
Posts: 3699
Location: Chicago, Illinois, USA


flag
PostPosted: Mon Aug 20, 2012 8:29 am 
Post subject: Re: valdation SQL Select Statement

And are you doing this in the Information Steward?
_________________
Cheers
Ganesh
Back to top
vsu
Forum Member
Forum Member



Joined: 15 May 2012

Posts: 14



PostPosted: Mon Aug 20, 2012 9:04 am 
Post subject: Re: valdation SQL Select Statement

yes,

source system is Oracle . write the validation rules in IS.is it possible to write select statements in data insight. is there any answer to my query.

regards,
visu
Back to top
softsys
Senior Member
Senior Member



Joined: 13 May 2005

Posts: 55
Location: US


flag
PostPosted: Tue Aug 21, 2012 4:21 pm 
Post subject: Re: valdation SQL Select Statement

Hi Visu

What is the issue here ?

I think you do not need SQL here. All you need is to verify whether values are one of you mentioned or not, based on that rule (validation) would pass or fail.

As far as SQL is concern you can write SQL also using decode function but where are you going to put this SQL?

Thanks
Back to top
yoffeyluo
Forum Member
Forum Member



Joined: 08 Oct 2018

Posts: 1



PostPosted: Mon Oct 08, 2018 11:48 am 
Post subject: How do I write a SQL statement in Information Steward?

Hi everyone,
I'm with a table that contains 2 fields, field A and field B. Duplicate values over field A are ok and allowed while field B can only store one constant character X goes by field A. That's why I want to build a rule to check and the rule needs to be built in SAP information Steward. So I wonder if Information Steward can recognize and execute a SQL statement like this
SELECT TABLE NAME
SELECT FIELD A, FIELD B and FIELD C. (field C is used to store count value)
Count FIELD B by FIELD A and store the count in FIELD C
IF FIELD C <> 1, output records
otherwise end.

I am looking for a SQL syntax or clause to perform the check logic against the table said above. Any thoughts? I appreciate.

by the way, it is SAP Hana Data Base table. I heard SQL clause varies by DB.

Yaofei
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Information Steward  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0354 seconds using 17 queries. (SQL 0.0029 Parse 0.0010 Other 0.0315)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo