Re: Accessing Spool File from AS/400 and then storing it in a TXT format file. -- JAVA400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

You can export the spoolfile in DB2: CPYSPLF FILE({spool_file_name}) TOFILE({my_lib/my_database_file}) JOB({job_number}/{job_user}) SPLNBR({spool_number})

and then access it directly, line by line with your favorite jdbc connector.
Note that this command can be run with java toolbox:
        CommandCall cmd = new CommandCall(new AS400());
        cmd.run({the command line above});

Note that you can have some trouble with "highlight" and especially "underline" key word: you will have underscore instead of the characters data. This is because AS400 spool file is a pure printing format. By adding the parameter CTLCHAR(*PRTCTL) to the command line, you can get every line processed by the printer and try to recontruct the initial format. It is a bit tricky, but it works.

Hope this help!

If someone know a way to get directly the spool with xml tag to indicate the attributes (mainly underline), I am very curious about the solution.

--------------------------------------------------------------
Gilles Kuhn, ingenieur développement
KUHN ORGANISATION
4, rue Hannong 67380 Lingolsheim
tél: +33 3 88 76 54 44
fax: +33 3 88 76 90 07
http://www.kuhnorga.com
--------------------------------------------------------------

This mailing list archive is Copyright 1997-2024 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.