Databases
StackOverflow2013
Postsdbo
POJava: Convert String to packed decimal
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POJava: Convert String to packed decimal
    primarykey
    data
    text
    <p>new here!</p> <p>Situation: I'm working on a project which needs to communicate with an AS/400 server. My task is to basically handle the requests which will be sent to the AS/400 server. To do this, all the user input should be in EDCDIC bytes.</p> <p>Problem:<br> I have managed to convert packed decimals to String with the code below, found <a href="http://www.coderanch.com/t/411222/java/java/Packed-decimal-conversion-Java" rel="nofollow">on this forum</a>:</p> <pre><code>public class PackedDecimal { public static long parse(byte[] pdIn) throws Exception { // Convert packed decimal to long final int PlusSign = 0x0C; // Plus sign final int MinusSign = 0x0D; // Minus final int NoSign = 0x0F; // Unsigned final int DropHO = 0xFF; // AND mask to drop HO sign bits final int GetLO = 0x0F; // Get only LO digit long val = 0; // Value to return for (int i = 0; i &lt; pdIn.length; i++) { int aByte = pdIn[i] &amp; DropHO; // Get next 2 digits &amp; drop sign bits if (i == pdIn.length - 1) { // last digit? int digit = aByte &gt;&gt; 4; // First get digit val = val * 10 + digit; // System.out.println("digit=" + digit + ", val=" + val); int sign = aByte &amp; GetLO; // now get sign if (sign == MinusSign) val = -val; else { // Do we care if there is an invalid sign? if (sign != PlusSign &amp;&amp; sign != NoSign) throw new Exception("OC7"); } } else { int digit = aByte &gt;&gt; 4; // HO first val = val * 10 + digit; // System.out.println("digit=" + digit + ", val=" + val); digit = aByte &amp; GetLO; // now LO val = val * 10 + digit; // System.out.println("digit=" + digit + ", val=" + val); } } return val; } // end parse() // Test the above public static void main(String[] args) throws Exception { byte[] pd = new byte[] { 0x19, 0x2C }; // 192 System.out.println(PackedDecimal.parse(pd)); pd = new byte[] { (byte) 0x98, 0x44, 0x32, 0x3D }; // -9844323 System.out.println(PackedDecimal.parse(pd)); pd = new byte[] { (byte) 0x98, 0x44, 0x32 }; // invalid sign System.out.println(PackedDecimal.parse(pd)); } } </code></pre> <p>My problem now is I have to convert these String values again to EBCDIC bytes so that the AS/400 server would understand it. I'm planning to do something like constructing a request (raw bytes) using the format specified in the Silverlake documentation. Once the request is built, I plan to manually change values inside that request using a POJO which stores my request (with setters and getters) so I could just go like <code>request.setField1("Stuff".getBytes(Charset.forName("Cp1047")))</code>.</p> <p>I don't have that much experience with bits, bytes and nibbles. I hope someone could help me out.</p> <p>In our code, there's a packed decimal we found which consists of 5 bytes. It goes something like = {00 00 00 00 0F}. I convert this using the method I got from the code above and the value I got was 0. Now, I would like to convert this 0 back to its original form with its original byte size 5.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USjamesallman
    1. USmpmp
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POJava: Convert String to packed decimal
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POJava: Convert String to packed decimal
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POJava: Convert String to packed decimal
      1. USMordio
      1. VTFavorite
    1. CODo you want the packed decimal as a byte array, like your input, or do you want the actual n bytes as an actual packed decimal, which would be a String in Java?
      singulars
      1. POJava: Convert String to packed decimal
      1. USGilbert Le Blanc
    2. CO@GilbertLeBlanc: I would want the output to be a byte array as well since I would be passing this to the AS/400 server.
      singulars
      1. POJava: Convert String to packed decimal
      1. USmpmp
    3. COI don't really understand _how_ you are trying to communicate with the as/400. I'm not totally sure about packed decimals, but so far I could avoid doing bit/byte-stuff or even some codepage issues, when communicating between java or php and our as/400, by using stuff like ILE-calls or SQL. How do you put your information on the as/400?
      singulars
      1. POJava: Convert String to packed decimal
      1. USkratenko
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload