List all file members from a multi member AS400 File
Either of these DSPFD commands should work for you:<pre> DSPFD FILE( mylib/myfile ) TYPE( *MBR ) OUTPUT(*OUTFILE) OUTFILE( somelib/mymbr ) DSPFD FILE( mylib/myfile ) TYPE( *MBRLIST ) OUTPUT(*OUTFILE) OUTFILE( somelib/mymbrlist )</pre> Run a couple tests to QTEMP and use RUNQRY to view the differences. Choose the variation that you need. From a PC, the commands [...]

View Answer   |  May 15, 2010  1:04 AM
AS/400, iSeries, Multi-Member, ODBC Microsoft Access Driver Login Failed

AS400 File Transfer
I guess I’ll start the list:<ul> <li>SNDNETF</li><li>SNA/DS</li><li>FTP</li><li>FTS</li><li>scp/sftp</li><li>SAVRSTOBJ</li><li>QFILESVR.400</li><li>QNTC</li><li>NFS</li> </ul> I suppose others could include variations of DDM or even SQL INSERTs into a remote database. The SQL could be via EDRSQL. The sockets send_file() API might be included. Those are off the top of my head. If I think, I might come up with others. Tom

View Answer   |  May 14, 2010  11:30 PM
AS/400 File Transfer

saving and restore libraries/objects
What is the CPF error you receive from the failed RSTLIB cmd? Are you restoring to an existing library that already contains objects? RSTLIB restores the whole library, which includes the library description, object descriptions, and contents of the objects in the library. The RSTOBJ restores the object description and contents of each object specified [...]

View Answer   |  May 14, 2010  7:14 PM
BMRS, RSTLIB Errors, RSTOBJ, SAVF

DDM files on IBM i
We use DDM files across 3 machines. Identify the file (PF or LF) on box 1. Then on box 2 use CRTDDMF and fill in the file name & library from box 1. For Remote Location, we use the IP address (so type is *IP). Note that the file names do not need to match [...]

View Answer   |  May 14, 2010  5:53 PM
AS/400 DDM Function, AS/400 File Transfer

Monitor IFS Folder
Plz use CL command RTVDIRINF and provide the folder name..hope this helps

View Answer   |  May 14, 2010  2:54 PM
IBM iSeries 825, IFS, IFS Directory to iSeries Folder, IFS Folder

retreiving Job information (command String) for jobs waiting in job queues on an Iseires
Rather than dumping the joblog to an output queue have you considered replacing that logic with calling either the <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/apis/QMHLJOBL.htm”>List Job Log Messages (QMHLJOBL) API</a> or the <a href=”http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/apis/QGYOLJBL.htm”>Open List of Job Log Messages (QGYOLJBL) API</a>? I haven’t had a chance to test either for your situation but they should do the trick. Another [...]

View Answer   |  May 14, 2010  2:48 AM
iSeries, iSeries programming commands

File Level identifier Vs. Record Format Level Identifier vs. Member level identifier
File Level Identifier will have created Time stamp Value. Format Level Identifiers will have system created value. This will be used in programs to check the format of the file. I dont think there is no member identifier. Please correct me if i am wrong =============================================================== File and Member Level Identifiers are forms of timestamps [...]

View Answer   |  May 13, 2010  9:33 PM
as400/DB2, File Level Identifier, member level identifier, Record Format Level Identifier

AS/400 Query
I’m not sure if query will work with a file that long However, you would make a result field using substr to get the company Then use the result field in the select record option. But you say Company Code ’01′ which is the 925-927 — 925-927 is three characters wide? Phil

View Answer   |  May 13, 2010  1:59 AM
AS/400, AS/400 Query

AS/400 BPCS Query Training Manual
CA 2E Manuals and Tutorials From 2EWiki (Redirected from The Horse Race Tutorial) Jump to: navigation, search How to Get the Manuals 1. Go to https://support.ca.com 2. Click Create An Account and fill out the required details. NOTE: If you don’t have a Site Id, select “None of these”. 4. After registration login to CA [...]

View Answer   |  May 12, 2010  7:57 PM
AS/400, BPCS, bpcs queries, BPCS training, Query

writing to a flat file/stream file
Sure, but why would you want to? I/O for stream files/flat files in the IFS is done using APIs, which are much easier to deal with in a language like RPG or COBOL. Use the right tool for the job. ============================================================ As of V5R4, ILE CL handles streamfile I/O almost the same as ILE RPG, [...]

View Answer   |  May 11, 2010  8:23 PM
CL programming, Flat files, IBM i, Stream files, V6R1

Upper Case Identification
http://www.mcpressonline.com/programming/cl/string-handling-in-rpg400-and-cl.html Check: Finally, string checking is the process of determining if all the characters in the string belong to a certain set of characters. For instance, you can check that a given string (which is supposed to contain a hexadecimal notation like “12F6″) only contains the valid hexadecimal nybbles 0 to 9 and A to [...]

View Answer   |  May 11, 2010  6:51 PM
AS/400, RPGLE

Running the QSPOLJBQ API
Hi, Do you get any messages in the joblog when you run in debug? Are you running the same object with debug and without debug (is there another one in your library list)? Regards, Martin Gilbert. Hi Martin, thanks for responding. There are no special messages in the job log and I only have the [...]

View Answer   |  May 11, 2010  8:05 AM
API, iSeries, QSPOLJBQ, RPGLE

AS400
It can depend on what version you’re compiling to. In i V6.1 and earlier, you would define the sort order on the D-spec along with the DIM() attribute:<pre> d pk s 10i 0 dim( 20 ) descend</pre> In V7.1, the SORTA op-code can have a (A) or (D) extender. Tom

View Answer   |  May 11, 2010  2:31 AM
AS400 RPGLE

AS400 – RPGLE
Assuming that the file has a key defined, use the SETLL op-code. After the statement completes, the %EQUAL() built-in function will be either true (’1′ or *ON) or false (’0′ or *OFF). Tom

View Answer   |  May 11, 2010  2:20 AM
AS400 RPGLE

embedding sql to rpgle
This is actually more of a math function. Get 2 fields defined as date format. From date is Jan 1st of the year desired. Thru date is your target (maybe today’s date ?) $TDATE Subdur $FDATE $DDIFF:*W I think it allows *W for Weeks. If not, use *D for Days then divide by 7 to [...]

View Answer   |  May 11, 2010  1:20 AM
AS/400, Embedded SQL, RPGLE, SQL Server

TFRJOB has to get executed along with library setup program
The TFRJOB command has parameters beyond just naming the job queue that the job is transferred to. One of those parameters is the RQSDTA() parameter. For any job on a job queue, the RQSDTA() is what tells the command processor what to run when the job starts. This is no different from the SBMJOB command [...]

View Answer   |  May 10, 2010  9:12 PM
AS/400 jobs, TFRJOB

Transfer Or copy savf from Iseries Server to Other Without use ftp
I’ve done this as an FTP and as a save/restore via tape. I remember saving the save file to tape as a SAVOBJ. I restored it on the 2nd box via RSTOBJ. Finally, you restore from the save file as you would if it were on the 1st box. Mike L.

View Answer   |  May 10, 2010  6:12 PM
iSeries, SAVF

sign on dspf
Hi, I believe that there is a QDDSSRC source file in library QGPL with the source for the standard display file. You can edit this using SDA – but be careful, there are a few things you must not do :- 1. Don’t remove any of the input fields – if you don’t want to [...]

View Answer   |  May 10, 2010  7:06 AM
DSPF

Enter in to synon main menu from AS/400
If YSTRY2 is the name of the command that starts your SYNON environment and you have authority to it, then enter this command:<pre> WRKOBJ *ALLUSR/YSTRY2</pre> A list of all commands named YSTRY2 should appear. (The list won’t show any of those commands that are in IBM libraries, but there shouldn’t any.) There might be more [...]

View Answer   |  May 9, 2010  4:19 AM
AS/400, Synon/Cool 2E

Session terminating
check out the qsysopr msg..from there you might be able to find something

View Answer   |  May 9, 2010  3:05 AM
AS/400, Client Access, session terminating, V5R2M0