ILE

Open XL file from ILE program

We have a process that converts a spooled file into a .CSV file and stores it in a folder on the IFS. The user then opens Excel and locates and opens the file for editing etc. Is there a way to open up the file in Excel for them after its transferred to the IFS? Could you show me code examples...

ILE - module change

Hi, 1) How to find the list of programs using a module (other than find string or hawkeye) which needs to be modified? 2) If a module used by more than 15 program needs to be changed, what are the ways to update the impacted programs (apart from running UPDPGM command)?

ILE Call(e) error handling

I am calling a CMD from an ILE program (simulates WRKSPLF) that emails a spool file. In my program I use Call(e) and %error indicator is on when CMD is executed if an error occurs during execution however I cannot determine which error happens. I tried using psds sds msgid 40...

V5R3 to V5R4

Hi, I need to upgrade the system from V5R3 to V5R4. I need to know that are there any RPG , iLE, CL, Cobol commands that have changed. Which would require code change to incorporatte the upgraded version. Can someove help me out how to find such commands.

AS400 ILE program with Embedded SQL

I need to load a file based on several search criteria and then use the file to display in a subfile

ILE programming

Hi I am looking for implimentation of IMPORT & Export use in ile programming with code.

Subfile does not display values in the physical file on screen.

I have made a simple sub file program which uses REF key field to reference the physical file fields. The problem is that my ILE prog which calls the display file does not show the fld values on the screnn in the subfile. While debugging i can see the value in the fields. I am unable to understand...