Re: AIX String Concatenation Problem

In article <6lpf41$h54$1@news.xmission.com>, Kate_Tomchik@homedepot.com writes >This code works on the HP machines but does not work on our AIX box. It >compiles OK, but the string p_select_for is corrupted: > >****** 'PART', sku_nbr, ord_qty, 0, 0, 0, sku_cost_amt FROM >str_po_sku W >HERE loc_nbr = 86 AND loc_typ_cd = 'STR ' AND acct_po_typ_cd = '0' AND >po_ct >rl_nbr = 63420 AND ord_seq_nbr = 1 AND ord_qty > 0 > >and therefore the SQL statement fails. > >We have been able to clean up the string by changing the code from one >concatenation of many substrings to many concatenations of a few >substrings: >These two code segments should be synonymous, but they are not on the AIX >box. We need to know if this is a known bug (that will be corrected on the >Y2K compliant version we are about to install) or if there is a compiler >option that can be changed to make the old code work, or if we have >overlook something obvious to you. This code style is prevalent in the >subsystems we are porting to the AIX box and changing every occurance would >be a substantial task. > I would log a call with Informix Technical Support...it sounds like a bug.. >Please call me with any questions at x18913, I can step you through this >or show you further examples if needed. > >Thanks, > >Charlie > > > > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care