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"
