• Check IF Field is Numeric in AS/400 SQL

    is there a function to check if field is numeric (like ISNUMERIC in standard SQL)?

    Jaggerdude60 pointsBadges:
  • Numeric to character conversion in AS/400

    Probably a simple question: I have a numeric field, 14 decimal positions, and i want to copy this value to a character field of 14 positions, and keep the leading (left) zeroes in place. How do I do so in free-form coding?

    TommyHall5 pointsBadges:
  • How to use “Program-Described-File” for converting an AS/400 numeric field into Char-field

    My situation is..... I have a file which is old & got 18,000 records in it. It has a numeric-field(Amount, Len 9,2). Now the 'Amount'Field in the file is changed to 12-char, in the new library. only this field's name is changed in order to avoid ambiguity. Otherwise the file-name & other fields...

    svankipu625 pointsBadges:
  • Need help in moving Character field to numeric field in RPG.

    Need help in moving Character field to numeric field in RPG. I have a character field of lenght 10 in the file and its was left aligned. Now I'm reading the file and get this value and moving to a numeric field of 20 length. I'm facing a problem while moving since its was a left aligned i'm not...

    Kvrs8070 pointsBadges:
  • Converting AS/400 negative numeric to character with leading zeros

    I need to convert numeric values to character keeping the leading zeros and when the value is a negative, I need to prepend the negative sign in rpgle. Example: Positive Amount : 00005679.05 = 5,769.05               Negative Amount: 00000-500.25 = -500.25    I've tried the editc...

    Demlerd5 pointsBadges:
  • Numeric fields in AS/400

    I have a numeric field 5,2 in a display file. when i am entering values i have blanks in between two numeric digits. the program is considering these blanks as zero. I hvae to avoid this, please let me know the way.

    frmdeva365 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.