I found an answer to the problem here.  It turns out you have to change the size limit for shadow copies.  I lowered mine as in the article to 300 and the backup started immediately.

I’d be surprised if it made any significant difference for video-conferencing. Maybe for football or basketball. But you probably should be asking that kind of question in a TV electronics discussion forum. — Tom

I was hoping that I was having a senior moment (like usual).

Of course, no one uses the arrow down key or the mouse.
It’s tab or enter and ‘X’ to select. Page Down to get to the next page.

Great .. alternating record sequence.

Load the array .. then load the page(s) from the array..great plan.

That will be fun.

It’s a small set .. just a few pages.

Thanks..Tom

I don’t think there’s a solution. I might assume it’s because the arrow-down key already gives a line-by-line movement down the screen and because the DSPF logic would be little more complex to keep track of skipping record numbers, then wrapping back to the top, in alternating record sequence.
.
Only thing I know of is to build the screen essentially as an array and map your “subfile” records to it.
.
Tom

What does a router and internet have to do with your question? Are you trying to access the system across the internet?
.
And there is no iSeries Access version 5.9, so you’re probably referring to the Personal Communications emulator. (the iSeries Access version would be 6.1 in that case.) If so, it’ll be harder to connect across the internet.
.
You should use a simpler emulator such as Mochasoft, so you won’t need the extra ports to be opened. You can use the simple Windows telnet command to work through any initial connection problems. If you can’t connect with Windows telnet, it’s likely that you won’t be able to connect at all unless you’re directly connected to the same network as the AS/400.
.
Tom

It’s not clear what is meant by “at the end of the last record”. SQL has no useful concept of specific records except as specified in a WHERE clause. It doesn’t even have a concept of a “record”; it really only knows groups of columns.
.
Maybe if you let us know something about the SQL that generates the output and how you get that into the streamfile format needed by the other system, we might have a better idea what to suggest.
.
Tom

It looks good except:
I think you mean IIF (Immediate IF)

Another way is to use the Access query grid tool to create a new query.
Add the fields you need in the report or output.
Add a calculated field that references a field in the table that you cannot have Nulls in. (in an empty query grid column)

Use the following in the caluclated field in the query grid:
DollarsCalc: IIf(IsNull([Dollars]),0,[Dollars])
1. This means a create a new field called DollarsCalc
2. Reference the real field Dollars in the IIF statement, which means Immediate IF
3. IsNull checks for Null in Dollars with true of false returned
4. IIF, if it is true moves zero in, else IIF keeps Dollars as is.
5. You can SUM the results in an Access sum query
6. IF you need SQL you generate it directly from the Access query grid
– by choosing View (then down Arrow)/ SQL (after you load the fields in of course).

would you be able to reply and share instructions on this topic?

Best advice might be never to code a “B” data type in D-specs. Only reasonable time to use it is… ummm… well, I suppose if we really really need to store a whole bunch of values accurately in the absolute minimum of space and the values have decimal fractions, it might be useful.
.
If you code a test usage of a [4B 0] variable and display it in hex in debug, first thing you should notice is that it’s only 2 bytes long (4 hex digits). I.e., it most definitely is not a BINARY(4). Now, since it’s only 2 bytes of memory, and the API accesses 4 bytes of memory from that address, what do you suppose the length of your error structure was? (Hint: what was the binary value of the 2 bytes that followed your variable in memory?) So, even if you set your variable to (0), the API probably saw something else, possibly much larger.)
.
The ‘B’ data type is essentially a binary value, but it causes special code to be inserted to handle decimal fractions accurately. The number of digits in [4B 0] tells the range of decimal values, not the number of bytes. That variable will hold 9999, and no more. The decimal value (9999) can be stored in 2 bytes. But a true BINARY(4) is a 32-bit integer.
.
Tom

Yay !
It works & seems to stay “OK” even with updates now that the msgerr field definition is correct.
Thanks for the help.

The WRKACTJOB JOB() parameter can’t be used to select QJOBSCD. It’s a system job. As CharlieBrowne said, it doesn’t run in a subsystem. Read the help for the JOB() parameter. — Tom

If you want to open the file, Notepad should work. But if you want to know a program that can make the file readable to you, there probably isn’t such a program. Opening a file is very different from making it readable to you. If it’s a disk image file such as was made by the DiskDouber or DiskDupe utilities, then the .DDI file doesn’t contain “readable” information. What are you trying to do with the file? — Tom

Suffering from “Nattering nabobs of negativism”

Use the command WRKJOB QJOBSCD
Job QJOBSCD does not run in a subsystem.

If you have BRMS in the system
WRKMEDIBRM LIB(*SAVSYS)
the command will provide with the date of full save and vol information as well.. . .

“it distorts my entire computer”
Could you explain what this means,

Since we do not know what phone you have, please check your users manual.

yeah, thanks for all the ideas, unfortunately, we are at the point where we can’t determine anything definitive. We just have this mysterious occurrence.

If a record is new, it won’t be in any programs yet; so DSPPGMREF won’t show the relevant format ID. But, yes, “files” don’t have format level IDs; only record formats have format level IDs. A new record format can’t cause a format level check. — Tom