Search results for query: *

Hi I have an RPG program that builds a complicated csv file. One of the "columns" in the csv file needs to contain line breaks within the cell, so in my RPG, I use x'25' to create the breaks within the cell. Now that I have Excel 2007, I have noticed that when I open the csv file in Excel and...

Hi We have a job that runs every night and recently, it has been failing about once a week with MCH3402 on the OPNQRYF. Here's an extract from the job log when it completes normally: OPNQRYF FILE((MHISRYL8)) OPTION(*ALL)QRYSLT('MHAGNT *EQ "39001N" *OR MHAGNT *EQ "37355N" *OR MHAGNT *EQ...

Hi all I have a problem with apostrophes! I have a S36 file (don't ask!) with a native AS400 RPG trigger program attached to it which fires after an insert or update. The trigger program then submits a job (using QCMDEXC), calling another RPG program and passing it the trigger buffer as a...

Hi all I have specified a logical file using DDS. The source for the file is: A R RPRMPFP PFILE(PRMPFP) * A K MPPACKNO *...

Hi all Our development box always used to be at the lowest OS release level of all our boxes (v4r5), however, when it died (!) we went onto a new (new to us) box which was on v5r1. So now this means that when we compile, we have to change the target release level. However, I was wondering if...

Hello I've been searching on the web all morning and can't find a solution to my problem. I've got an Excel spreadsheet which imports external data from the iSeries via ODBC. I have specified some calculated fields in my query to which I'm trying to assign meaningful column headings. If I...

Hi all Not sure if this is the right forum! I've set up an iSeries outq which writes to a dot matrix via IP (jet direct). The printer is an Epson FX1180+ - this was not available to me on configuring the outq, so I used a FX1170. It prints okay, but each line is preceded by >>>>>>. I've...

I'm trying to read a System/36 file from an RPGLE program (don't ask me why they've still got S36 files). I cribbed from another program and just changed the file name. But when I run the program it falls over with a CPF4101 (file not found) even though I've checked and the file is in the...

I'm sure I read an article once in News/400 (or something) which explained how to get meaningful column headings when importing AS400 files into Excel. Something to do with ODBC I think. As far as I remember, you could actually replace the "A", "B", "C" column buttons in Excel with the field...

Hi all I have a long running job (only stopped and restarted every few months) which calls a number of RPGs, including some ILE programs which have an RPG module bound to some IBM service programs (QZRDSAPI) for transmitting stuff via TCP/IP. We had a problem where the ILE programs were...

Hi all I've got a continuous job running in a 24*7 factory environment. We get buildups of spooled files at status FIN and from time to time we'll get an escape message saying that we've reached the max no of spooled files, so we have to end and restart the job. We've increased the max "to the...