P.S.: Re: Binary fields -- RPG400-L

Subject: P.S.: Re: Binary fields
From: Daniel Gross <daniel@xxxxxxxx>
Date: Thu, 2 Jan 2025 23:08:14 +0100
List-archive: <https://archive.midrange.com/rpg400-l/>
List-post: <mailto:rpg400-l@lists.midrange.com>
List-subscribe: <https://lists.midrange.com/mailman/listinfo/rpg400-l>, <mailto:rpg400-l-request@lists.midrange.com?subject=subscribe>
List-unsubscribe: <https://lists.midrange.com/mailman/options/rpg400-l>, <mailto:rpg400-l-request@lists.midrange.com?subject=unsubscribe>

To answer the last question myself:

Am 02.01.2025 um 22:52 schrieb Daniel Gross:
I honestly don't know, if you can create a LF over the table that converts the value from SQL data type [probably numeric(9, 2)] back to 4B2 format - but you can try that.

The conversion table here:

https://www.ibm.com/docs/en/i/7.5?topic=44-data-type-physical-logical-files-position-35

Clearly states, than a conversion to B is only possible with 0 decimal places.

Regards,
Daniel

As an Amazon Associate we earn from qualifying purchases.

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.