Can someone see why this is happening...
the trailing blanks of the TRTP field became ÿ

Here is the synonym:

FILENAME=LITDES, SUFFIX=DB2     ,
 REMARKS='ledger interface transaction description', $
  SEGMENT=LITDES, SEGTYPE=S0,
    DESCRIPTION='ledger interface transaction description', $
    FIELDNAME=TRTP, ALIAS=TRTP, USAGE=A4, ACTUAL=A4,
      TITLE='Trans,Type', DESCRIPTION='Transaction type', $
    FIELDNAME=APID, ALIAS=APID, USAGE=A1, ACTUAL=A1,
      TITLE='App,Ind', DESCRIPTION='Application indicator', $
    FIELDNAME=TDES, ALIAS=TDES, USAGE=A40, ACTUAL=A40,
      TITLE='Transaction,Description', DESCRIPTION='Transaction description', $
    FIELDNAME=INFC, ALIAS=INFC, USAGE=A1, ACTUAL=A1,
      TITLE='Interface,Code', DESCRIPTION='Interface code', $
  

and here is the fex:

-* File com_rule_lookup.fex
SET HOLDLIST = PRINTONLY
DEFINE FILE LITDES
DSPTEXT/A50=TRTP ||'-' || TDES;
END
TABLE FILE LITDES
PRINT
     DSPTEXT
BY TRTP
WHERE APID EQ 'B';
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XML
END
  

the result(one of)...

<tr linetype="data" linenum="5">
  <td colnum="c0">CIÿÿ</td> 
  <td colnum="c1">CIÿÿ -Cost invoices - all items</td> 
  </tr>
  

The result of DB2 field TRTP should be "CI" or "CI ", not "CIÿÿ"

Hua

This message has been edited. Last edited by: Hua,

Hua,

I'm not sure why this is happening, have you tried to comment out the PCHOLD to see if the data is retrieved correctly?

Also, you could code the request like this, no define:

SET HOLDLIST = PRINTONLY
TABLE FILE LITDES
PRINT
COMPUTE DSPTEXT/A50=TRTP ||'-' || TDES;
BY TRTP
WHERE APID EQ 'B';
ON TABLE PCHOLD FORMAT XML
END

By the way, should it be PCHOLD or HOLD?

Francesco, the PC hold makes this a dropdown list for a launch page.
Hua, rather than go stright to xml, just do a straight dump of the data to see whats up.
maybe your master doesn't match your file
TABLE FILE LITDES
PRINT TRTP
END

I ahve seen this happen before, but then with an MS SQL database.
There it was caused by the database being set up to allow for multiple languages and unicode. We did solve this, but I really can't remember how we did it.
Don't know if this could also be the case in your setup.

Thank you for responding.

I did a simple print, or COMPUTE, the result is the same.

It was fine if I pull the sample data directly in the synonym editor. I also tried use the ODBC driver to dump the data onto excel and it looked fine too.

GamP, LITDES is a physical file DB and no different than other files I have been working on.

Hua

This message has been edited. Last edited by: Hua,

I just found out that it is data problem. The weird values are actually the *HIVALs in AS400/RPGLE.

I will do a string replace to get rid of them since I know what they look like in WF.

Thanks.

Hua

golden rule: always always always check your source data.

we all do it but seriously make it the first thing you do next time; will save you a lot of time...

This message has been edited. Last edited by: nubi,

nubi, I am slapping my face now


Hua

This message has been edited. Last edited by: Hua,

well don't slap too hard! we've all done it and its the only way to learn, so the next time you get a problem like this you'll think 'wait a minute, lets check the data first!'

keep going!