Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Reaper73

    Convert alpha field that contains a neg num to a neg num field

    Umm ok. Well the data looks like this: AP00002007101900000000123456700000001750w000000 AP00002007101900000000444444400000002340v000000
  2. Reaper73

    Convert alpha field that contains a neg num to a neg num field

    I'm on V5R4. In the attached file the position 31-40 contains dollar amounts and you can see some of them have a lower case letter in the last position. This is the negative sign with whatever number is supposed to be in that position. One other thing, this data is coming from a Unix system so...
  3. Reaper73

    Convert alpha field that contains a neg num to a neg num field

    I have a flat file that I am moving into a file with defined fields(contains both alpha and numeric). Everything is working great until I hit a record that has a negative value in a position that contains only numbers that I'm moving into a numeric field. In that position the value looks like...
  4. Reaper73

    FTP DB2 file from Iseries to our FTP server and converting to Excel

    I need to FTP a file from our Iseries to our FTP server as an Excel file .xml so we can then FTP this file to an outside company. When I do this and bring the file up in Excel the data is readable(except for one numeric field) but doesn't line up in columns. When I use client access it is...
  5. Reaper73

    Date passing validation but bombing when moved into a date field

    No you miss understood me. The date in the field is '2061031 ' and it passes the test date op code for ISO. Anyway I found the answer to the problem. The test op code tested the date as 2061-03-01(don't ask me where the 0 between the 3 and 1 came from) which is a valid date. However when...
  6. Reaper73

    Date passing validation but bombing when moved into a date field

    I have an 8 char field with iso dates in it(20061030). My problem is this. The following date was in the field and passed validation but the program bombed when it tried to move the date into a date field. Example: 8 char field (ISODATE): '2061031 ' rpg date field (RPGDATE) in *MDY format...
  7. Reaper73

    AS/400(Iseries or I5) Question about CL command CLRPFM

    I'm sorry, I meant delete the records in the file not delete the files.
  8. Reaper73

    AS/400(Iseries or I5) Question about CL command CLRPFM

    I'm using the CLRPFM command in a CL program on some files and was wondering if I needed to do a reorg on each file since the CLRPFM command removes deleted files.
  9. Reaper73

    Half adjust in free format

    Can you half adjust in free format without using the EVAL statement?
  10. Reaper73

    Restore RPG program member from the Object

    Thanks MdnghtPgmr. I was hoping there was a quick solution to this instead of going to a backup. Oh Well.
  11. Reaper73

    Restore RPG program member from the Object

    I've accidently moved a RPGLE program member from our live enviroment library to our developement library and blew away the member that was already in there. The member that was there had new changes in it. What I'm wondering is can the source be retrieved from the object in the development...

Part and Inventory Search

Back
Top