Make sure there are no spaces between the assignemts: STMT|IF $Region$="NORTH AMERICA" THEN VALUE=$State_Name$ ELSE VALUE=$Region_Name$ ENDIF
On Wed, Aug 26, 2009 at 7:32 PM, tina flores<[email protected]> wrote: > Hi Frank, > > I have this statement: > > STMT| IF $Region$ = "NORTH AMERICA" THEN VALUE = $State_Name$ ELSE VALUE = > $Region_Name$ ENDIF > > But I'm having trouble verifying this exchange. I got this error: > Verify DataExchange: 'Facilities Integration' > Error on tab: '' (ARNOTE 10000) > > I know it refers to the particular statement because when I disable it, > verification is fine. > > Am I missing something? I have spaces between the fields and the variables. > > Thanks in advance for your help. > > Tina > > Frank Caruso-2 wrote: >> >> I made a few postings about having issues using the IF and SQL >> statements in field mappings within AIE. Although I appeared to be >> using valid syntax in my class mappings, AIE would not process those >> statements. No errors were shown in the logs. After a bunch of emails >> back and forth with BMC I was able to figure out the issue and felt it >> was worth posting to the list. >> >> These type of statements must contain spaces between all >> fields\variables. A statement such as: >> >> STMT|IF $Index0$="0" THEN VALUE="1000" ELSE VALUE="5000" ENDIF >> >> will not work but the following will: >> >> STMT|IF $Index0$ = "0" THEN VALUE = "1000" ELSE VALUE = "5000" ENDIF >> >> The same with an SQL statement: >> >> sql|select <column> from <table> where <column>=$column$ >> >> will not work but: >> >> sql|select <column> from <table> where <column> = $column$ >> >> does work. >> >> >> Frank >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" >> >> > > -- > View this message in context: > http://www.nabble.com/SQL-and-IF-Statements-in-AIE-tp24949420p25151446.html > Sent from the ARS (Action Request System) mailing list archive at Nabble.com. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
