Recent content by SuzieW

Hi all - ignore the above - the data is all there, but you just need to either expand the cell or scroll down within the cell contents area along the top. Suzie

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...

Turns out that the access path had become damaged, which was the root of this particular problem and also caused the jobs to run deathly slowly as it was trying to rebuild itself every time it was accessed. By creating a new logical, the problem has been resolved. Thanks for your help Suzie

Hi Mercury Here's the OVRDBF: OVRDBF FILE(MHISRYL8) OVRSCOPE(*JOB) SHARE(*YES) OPNSCOPE(*JOB) Thanks for the "%VALUES" tip. Just for the record, this isn't my code. There's no way I would have hard-coded it like that! It has been working up to now, but my task is to work out why it's...

What it is referring to is a permanent logical file so it should exist. The save/backup jobs run several hours before this job - I don't know of any other jobs using the same object which run at the same time. Jobs are deliberately scheduled to run one after the other to avoid contention...

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...

arrow - the double quote " worked fine - nothing fell over. But I was left with a double quote in my destination data, when what I'd really like is an apostrophe :o) smurf - tried with four and five - both caused it to fall over with the "Matching apostrophe...". It builds the SBMJOB command...

Mercury - that's what I tried, but the call to QCMDEXC fell over with "A matching apostrophe not found..." (i.e. the same error as when there is just one apostrophe). arrow483 - thanks, I'll try that and see what happens

Hi Mercury2 Tried it with the three - back to square one (i.e. falling over on the SBMJOB with "Character 'B' not valid following string ''692601120', A matching apostrophe not found). When I use the "two apostrophe" method, there are definitely two apostrophes when the data is passed to the...

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...

Found it In order for the select conditions to be in an "and" relationship, I needed to get rid of the S in the second line. The default is obviously OR. (Shows how often I use DDS) Phew!

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

arrow483 - those sound like good ideas, thanks jmd0252 - we are deploying programs to production boxes which are on lower release levels. This is quite normal, I think. My old shop used to test out new releases on the dev box first so they would need to compile at a lower level for the...

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...

No worries, allisond :)