I have a DDS file I am converting to Excel on a PC. I FTP the file to my FTP server, then open the file in Excel and import the data, specifing the field positions. The problem I am having is with negative numbers. Instead of being saved as -12300 it is being saved as 1230} Then I have to do all kinds of manipulation in Excel to replace the } with a 0 and make it a negative number. How do I get the AS400 to convert it to a negative number? Regards, Jim Langston
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
FTP negative numbers
Collapse
X
-
FTP negative numbers
How is the offending field described in your DDS? I had the opposite problem a while back - I had a flat file that was loaded with {'s and }'s. After my program finished massaging the numbers they wound up losing the }'s and {'s. Barbara Morris supplied me with the answer (thanks again!) that involved using MLLZO. In her post dated 04/06/99 (are these still out there?) Barbara said "The AS/400 resognizes your x'c' as a positive sign, but changes it to the preferred sign of x'f' after processing (or when writing it out as zoned numeric)." HTH, Joe
-
FTP negative numbers
Unfortunately, I don't think so. We have client access on this box, and supposedly have 10 licenses. but, the licenses are not entered, and I called the people who sold us the box for the licensing information, and they never got back to me. The net effect being, we have Client Access with 0 licenses. I had tried to set up ODBC to the AS/400 from WinNT but kept getting errors, my assumption being because of the lack of licenses. I am somewhat familiar with the IFS and how it works, but it is not something we really need nor want at this point. It would be more of a headache to administer it and ensure security, etc... and since I am it at this shop, I don't want to have to go that route right now. I guess I have a few solutions, none of which I am happy with. 1. Create an intermideary file on the AS/400 and write an RPG to convert the number to a string, and send that new file. 2. Send the file as I am and write something in Excell to convert it. I will probably do 2. But, what a pain. Regards, Jim Langston
Comment
-
FTP negative numbers
I may be dead wrong, but I do not think CA plays a part in CPYTOIMPF. I created a file w/o DDS that was somewhat longer than the file I needed the info from. I then ran the CPYTOIMPF command and it built a delimitted file (the file I created w/o DDS). I then FTP'd that file to the PC and imported it to EXCEL.
Comment
-
FTP negative numbers
Well, I'm on V3R7M0, I do CPYTOIMPF and get Procedure or Command not found. I guess that is one of those new fangled V4RxMx commands. I coulda talked my boss into upgrading to V4RxMx, but with IBM saying once you go to V4 you're going to have to PREPAY for upgrades, it's not financially viable. Regards, Jim Langston
Comment
Comment