++++++++++++++++++++++++++++++++++++++++++++++++++++++ Please Read The Disclaimer At The Bottom Of This Email ++++++++++++++++++++++++++++++++++++++++++++++++++++++
Frank, Definitely very useful info. Just out of curiosity, has anybody tried to import data into a currency field using AIE? I have tried, but the only way to get the data in with currency other than default (i.e. USD) was to import the data simply as number (in the default currency) and then update it through export/import. I would expect it to be possible to import in whatever currency one needs, but simply was not able to find the way or the right format (tried the format used by the import tool, but that only returned errors). Jiri Pospisil LCH.Clearnet -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frank Caruso Sent: 13 August 2009 07:11 To: [email protected] Subject: SQL and IF Statements in AIE 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" ************************************************************************************************* This email is intended for the named recipient(s) only. Its contents are confidential and may only be retained by the named recipient(s) and may only be copied or disclosed with the consent of LCH.Clearnet Limited. If you are not an intended recipient please delete this e-mail and notify [email protected]. The contents of this email are subject to contract in all cases, and LCH.Clearnet Limited makes no contractual commitment save where confirmed by hard copy. LCH.Clearnet Limited accepts no liability, including liability for negligence, in respect of any statement in this email. LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, London EC3N 1EA. Recognised as a Clearing House under the Financial Services & Markets Act 2000. Reg in England No.25932 Telephone: +44 20 7426 7000 Internet: http://www.lchclearnet.com ************************************************************************************************* _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
