We are having more and more users call AS/400 jobs from a SQL Server session on their PCs, and we have trouble giving them the proper library list. Usually, just giving them the libraries in QUSRLIBL works fine. Is there a way to make sure every user, regardless of originating machine or system, gets the library list values of QUSRLIBL?

–Barry

Barry,

I’m guessing that you’re using the SQL Server’s linked server facility to connect to the AS/400. If so, the first thing you need to do is check the linked server’s data provider. SQL Server will use either an

Let’s say I have an IFS file with several thousand lines in it. Let’s say I want to print a few lines of that file. My current method is to copy the IFS file to another file, use Edit File (EDTF) with the copy to delete the lines I don’t want, and use EDTF’s Print command to get the report. Please tell me there’s an easier way.

–Bob

I recommend two Qshell commands. Sed, the stream editor, can select the lines you want to print. The Rfile utility can send them to a printer.

Now, how do you want

Do you know if we’ll be able to read tapes created from a new Linear Tape Open Ultrium drive (400 GB native format) on our old Ultrium LTO 2 drives? We want to take tapes from a scientific vessel at sea that may purchase the LTO 3 drive and read the tapes back in the office on our LTO 2 drive.

–Anne

When comparing LTO 2 and LTO 3 tape drives, the rule is that an LTO drive can usually read tapes that were created at a lower tape drive level, but not tapes that were created at a higher