On my AS400, I need to select the first 90 records from one file and insert them into another file, but all the time i got all records in my result file. Is there any way to use the parameter LIMIT with my SQL SELECT
INSERT INTO LIB1/FILE1 (FILE1) SELECT DISTINCT (substring(FILE1, 1, 100)) FROM FILE1 WHERE FILE1 like '%xxxx%'
June 13, 2011 6:40 PM
June 14, 2011 4:19 PM