How can I concatenate files for transfer from the iseries
I have 3 files with a common layout in a common library on the i5.
The source files (query results) have different definitions so I am unable to append the result of query2 to query1.
So what I want is to perform a UNION or concatenate them into a single download file.
I have tried a UNION but keep gettting syntax errors.
Software/Hardware used:
excel,i5series
The source files (query results) have different definitions so I am unable to append the result of query2 to query1.
So what I want is to perform a UNION or concatenate them into a single download file.
I have tried a UNION but keep gettting syntax errors.
Software/Hardware used:
excel,i5series
ASKED:
February 17, 2011 3:12 PM
UPDATED:
February 28, 2011 4:11 PM
RELATED QUESTIONS
- MySql Select multiple columnsfrom distinct rows based on one column
- T-SQL with Recursion - Display top ID on all levels below (To: Kent Milligan)
- Data selection criteria to pull last months information
- iSeries Access Macro to run from a program.
- Query 400 - Problem appending data from 1 file to another.
Answer Wiki:
As long as the common layout is IDENTICAL, you can use the CPYF command to copy all data into a single file.
CPYF from the 1st into a new file CRTFILE(*YES)
CPYF the 2nd and 3rd into that same new file MBROPT(*ADD) - and you probably need *NOCHK (use F10 and page down to "Record format field mapping")
Mike
To see all answers submitted to the Answer Wiki: View Answer History.
I’d say a UNION view is a reasonable way to go as long as they have a “common layout”. I don’t know why you’re getting a syntax error. Show us your statement so we can look it over.
It’s probably related to “different definitions”.
Tom
If the three resultsets are identical in layout, you may let query 1 output (create) a file, and query2 and query3 output (with ‘add’) directly to the file created in query1.
DanF