Sitemap

Amicuk Programming Answers

Not Equal to Clause in BODS

2015-10-11   Views:3

Advertisement

Hello Experts - I need to put this condition in transformation  in BODS  table1.col 1 Not Equal to table2.col2 . I am not able to find NOT EQUAL TO clause in BODS. I have used  !=  , But  not working. However equal to (=) is working fine. Any suggest

Hello Experts -
I need to put this condition in transformation  in BODS  table1.col 1 Not Equal to table2.col2 .
I am not able to find NOT EQUAL TO clause in BODS. I have used  !=  , But  not working.
However equal to (=) is working fine.
Any suggestion how I can use not equal to ? (I want it in Where Tab)
Thanks
R

The replay answer
Advertisement
Rohan, please pull/drag your columns into where clause. do not simply write them. and for your condition chk it with " <> " .
hth
thx
deep

Go to See the other 4 answers

Not Equal to Clause in BODS

Category:DefaultRelease time:2015-10-11Views:130

Hello Experts - I need to put this condition in transformation  in BODS  table1.col 1 Not Equal to table2.col2 . I am not able to find NOT EQUAL TO clause in BODS. I have used  !=  , But  not working. However equal to (=) is working fine. Any suggest[More]

Using Filter and where clause in GoldenGate

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I need to use where clause in extract process. The condition i need to use is :- where (CODE LIKE '10%' OR CODE LIKE '0%') how to use LIKE operation along with OR in extract. I have multiple where conditions these are straight i.e = and <> which[More]

Using Lookup

Category:DefaultRelease time:-0001-11-30Views:130

Post Author: jeff.p18 CA Forum: Data Integration Hello (mother-tongue = french) I'm a BODI beginner and I often have things lije this to code :             SELECT gd.num_ecrou_ini, ae.dat_epreuve, ae.cod_diplome, u2018Ru2019, 2             FROM gdet_[More]

EQUAL condition on WHERE clause not working

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Can someone please tell me why the following WHERE clause  (marked with ***** below) is not finding any EQUAL conditions? I know that table i_cust_mast is populated with several thousand rows and that there ARE matching rows in KNVP. Here is the[More]

How to canel where clause equal effect

Category:DefaultRelease time:-0001-11-30Views:130

hi all in JPAQL i wanna cancel the where clause effect in order to use the following example query select u from user u where u.name= :name the question is what to put for the value of the parameter:name to make the query get all the objects ,ie. mak[More]

Query performance decreases dramatically after replacing equal clause

Category:DefaultRelease time:-0001-11-30Views:130

I have a Select statement that performs well as long as I join the project code to a fixed value in the WHERE clause. But when this fixed value is replaced by a sub SELECT (which in fact retrieves that same fixed value) the result of the query takes[More]

Left join and where clause with not equal ( ) returns too many rows

Category:DefaultRelease time:-0001-11-30Views:130

Say I have something like this Table A ========= Id OrderNum Date StoreName AddressKey Table B ======== Id StreetNumber City State select a.* from [Table A] a left join [Table B] b on a.AddressKey = b.Id where a.StoreName <> 'Burger place' The troub[More]

Case in where clause

Category:DefaultRelease time:2015-10-11Views:130

Hello to everyone I have a select like as select           where   (KPMERCE IS NULL AND KSMERCE IS NULL)      UNION           where   (KPMERCE IS NOT NULL AND KSMERCE IS NULL AND K_PMERCE = KPMERCE)      UNION           where   (KSMERCE IS NOT NULL A[More]

Re: [iPlanet-JATO] How to make an OR in the WHERE clause of a SELECT

Category:DefaultRelease time:2015-10-11Views:130

Harry, If you get a reference to your model, you can set the whereClauseOverride with exactly the string you want to use. Keep in mind that you are dealing with a the raw SQL where clause, therefore, you must use the actual table column names and not[More]

How do you use 3 Where Clauses in a query

Category:DefaultRelease time:2015-10-11Views:130

Hi, i am trying to figure out how to use 3 Where Clauses in a Query where 2 of the Where Clauses uses a Sub query. Display the OrderID of all orders that where placed after all orders placed by "Bottom-Dollar Markets". Order the result by OrderI[More]

OA Framework LOV – How to add where clause dynamically at runtime

Category:DefaultRelease time:2015-10-11Views:130

Hi All, Following is my page design: MainAM (This is root Application module) Package is: mycompany.oracle.apps.<product>.<project>.server MainPageVO (This is the View Object associated to Main AM) LovAM (This Application module is for LOVs) P[More]

Hot
I have a collection of .mp3 files loaded into iTunes as mediaKind: audiobook. They play just fine with my iPod Touch. They hang (with black screen) my iPad (played via the iPod app). Why???? Any fix known for this? P.S. I converted one track from mp3 [More]
What I think has happened in the past 5years I've been using iTunes, I've cleaned off my hard drive 5times and saving all my music in the process. Each time I start over iTunes asks me to autherize that particular computer, but that computer/OS doesn [More]
I have an onkyo 5. dts / dolby digital receiver, and an audigy 2 zs platinum. i am using an optical cable from the front panel on the audigy to the optical in on my receiver. My receiver manual says it is a 96 khz receiver. I am using a 2 pin cable f [More]
Hi everyone, I work in an industry where soon our Photoshop TIF files will require super high resolution for our pixel mapping. Though our files are not that big size wise (2x2 inches max), they tend to be between 10,160 and 50,000 DPI, depending on [More]
how do I get full display on sony tv w/macbook pro? I am using mini dv adapter to pc input cable.(I believe hd15) not HDMI adapter.How is the image you get now deficient? Are you mirroring or using extended desktop mode? What resolution(s) are you us [More]
We are running our application with OC4J server, JDK 1.4.2_07 in a HP UX 11i. The application runs perfectly fine all through the day till 3:30 PM. Around 3:30 PM, the application crashes with the following error in the log. An unexpected exception h [More]
Hello all , I have implemented a web dynpro that retrieves data from the R/3 through an RFC , using the documentation and examples . At the beginning, there is an iView with a List, the user selects a line and then a second iView shows the line he ch [More]
Hi! We are having problems posting a invoice in MIRO. When entering the PO number we receive the error message "The document contains no posting lines with value other than zero". What could be the problem? /AndersHi! The GR_BASEDIV is set in th [More]
IS THERE A WAY TO CONDUCT A MAIL MERGE FUNCTION WITH ADDRESS BOOK? IF NOT!.......how can I export (only) a Smart Group to excel or Numbers to do so????Ran test. It does delete a given address book from the phone if deselected. Thanks. >>> [email  [More]
Hi, I'm using forms 10g (904) and I need to pass in a paramter when the form starts. I have created a parameter and it works when I debug. But when I run it on Oracle Application Server, how do I pass the parameter in the URL? I have tried &parameter [More]