|
I would suggest to check structure of those files once again if You're getting this message "Data Mapping error on member..." Thank You. "Dave Odom" <Dave.Odom@tucsonaz .gov> To Sent by: <midrange-l@xxxxxxxxxxxx> midrange-l-bounces+ cc eugen.baum=xtl.com@ midrange.com Subject Re: FTP unable to open or create target file with some files 01/10/06 03:52 PM Please respond to Midrange Systems Technical Discussion <midrange-l@midrang e.com> Michael and Rob, On your questions: Common thread - Just about everything. That is to say, I created all the tables using the same SQL via Ops Navigator. Dropping and recreating the tables doesn't help. No messages in QSYSOPR msg queue but I did find some more in my joblog (I'm running this from my userid): Data Mapping error on member BFUT145AP This seems crazy since, as I said before, I created the source and target tables from the same SQL. But at least this "deeper" error explains the top level error of "Unable to open or create target ..." QTFTP* jobs in QSYSWRK don't show any problems there are no exit points the libraries involved are MY libraries and my storage is *NOMAX All scripts are built similar. I can follow the run of the failing scripts with a rerun of those that FTP against the other files that never had a problem and they will rerun perfectly. Doesn't matter if I CD to my library or not; same problem. I'd tried CLRPF as well as DROPPING and re-CREATING the tables; no luck when FTPing. What's even more weird is I can run some SQL that does an INSERT from a SELECT of data from a copy of the master table on the same LPAR (my tables are a subset of the columns of the original table and a copy of the original is found in both LPARs) and the INSERT works perfectly. I'm stumped. Any more ideas? Thanks for helping. Dave I've experimented and find a couple of things -- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
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.