I m a vb6 programmer. I have started a new job where they have main software running on AS400 and I have no previous knowledge of AS400. After trying I have been able to access the AS400 database using IBMDA400 through vb. The requirement is 1) I want to sort my MPRINT and the PRT03 outqueue. I donot know RPF or CL. 2) I want to be able to access these output queues and pickup the spoolfiles and store into sql server database for future reference and also to be able to print the reports using Sql server database. I have already tried using the Copy spool files command to physical file and then from physical file to pc document in QDLS folder. But i want to automate all this from say MPRINT output queue. So that what ever is there in MPRINT outqueue it should get transfered to the PC directory specified. I want to do it in vb6 but if it is better and easier to do in rpg or cl whatever then i would need the full steps as i donot know rpg or cl programming. We have V5R2 and I have iseries navigator installed on my pc.
will appreciate any help