• 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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