Différence entre versions

Version du 27 mai 2019 à 11:22

This command allows you to copy the data of a spooled file onto the pages of another spooled file. It can be used starting with two spooled files coming from queries: one spooled file for the invoice header and another one with the items listed. MAPMOVDATA should be used after MAPSORTSPL. You will need to add the two spooled files to the same database, MAPMOVDATA will then change this database and add data from the first spooled file at the end of every page of the second spooled file whenever they have the same sorting criteria.

Example:

- the first spooled file compiles different invoices and the purchased items

- the second spooled file contains invoice headers

- both spooled files are sorted by invoice number using MAPSORTSPL

- MAPMOVDATA will add the purchased items underneath the corresponding headers.

- To start printing the spooled files, use command MAPSORTSPL with parameter MBROPT set to *NONE

Line Number: line number from which we start copying
Name of DataBase for sort: name of the database (same one as for MAPSORTSPL)
Spool file number to copy: number of the spooled file that will be copied at the end of the other one (matches the number of command MAPSORTSPL)
Spool file number to update: number of the spooled file that will be changed
Length of the input spoolfile: PRTF length
Delete copy spool file: the copied spooled file pages will be deleted

@@ Ligne 12 : / Ligne 12 : @@
 - '''MAPMOVDATA''' will add the purchased items underneath the corresponding headers.
-- To start printing the spooled files, use command '''MAPSORTSPL''' with parameter '''MBROPT''' in the '''*NONE''' section
+- To start printing the spooled files, use command '''MAPSORTSPL''' with parameter '''MBROPT''' set to '''*NONE'''
 * Line Number: line number from which we start copying