Merging columns from 2 different files
I want to merg data from 2 different files.  1 column in both files has same type of data but the headers (Library and Libraries) are different and the fieldnames (ODLBNM & MLLIB).  Is there a way to merge both columns into 1 column?

Answer Question   |  April 5, 2013  10:17 PM
AS/400, as/400 files

How to read from flat file
How to read from flat file For eg: The data in one flat file is like this D|EMPN0001_001_01|C55BFIT|.00|.00|GBP|Y|1.00|20030101|20130301|IT|||||LC|100 D|EMPN0002_001_01|C55BFIT|.00|.00|GBP|Y|1.00|20030101|20130301|ECE|||||LC|100 The data in another flat file is like this: D|EMPN0001|N||.048448|.048448|100.0000|0.0000|100.0000|77.7782|EMP02|CME02|LM D|EMPN0002|N||1.000000|1.000000|100.0000|0.0000|100.0000|35.8566|EMP02|CME02| D|EMPN0003|N||.025600|.025600|100.0000|0.0000|100.0000|100.0000|EMP02|CME02|L I want to read these two files and stores these values in a separate Physical files. Main purpose is that to compare the values [...]

Answer Question   |  March 28, 2013  5:49 AM
AS/400, as/400 files

Size of a save file in AS/400
Hi, I would like to know is there any way to find out the size of a save file in AS/400 in bytes.

Answer Question   |  March 27, 2013  3:34 PM
AS/400, as/400 files

How to change display file text after compilation
I created one display file after compilation when I am trying to edit some text in that display file using option 2.when I type the new text, it displays only capital letters only. I am unable to type lower case letters. Please tell me how to type small case letters in that display file.

Answer Question   |  January 14, 2013  8:50 AM
AS/400, as/400 files

How to monitor what data is read from PF
Hi All: For security concern. we want to know what data contents is read from AS400 files , for example, we can know “kevin lee f123456 team1″ data is read from file. I try to find audit journal but no similar function is found. Could you give any idea about it ?

Answer Question   |  September 24, 2012  8:34 AM
AS/400, as/400 files

How to find the fullpath/absolute path of a file at AS400?
One program file (MYFILE) exist at one Library (MYLIBRARY), but how to know the fullpath/absolute path of this program file ? Can not find the file at /MYLIBRARY/MYFILE, where is the file located ?

Answer Question   |  April 6, 2012  8:46 AM
AS/400, as/400 files

Files
hai friends, i have PF in this format ————–PF1-NAME R   REC      FLD1      FLD2 ———————— FOR LF: ——————LF1 R   REC   PFILE(PF1) ——————– My question Is it possible to have some other record format name in my LF??? Example:: ————————LF1 R   ANC    PFILE(PF1) ——————- Thanks in advance..

Answer Question   |  March 17, 2012  11:30 AM
AS/400, as/400 files

AS/400 Source. Physical Files. Key Fields?
We assume that we have a source physical file from AS/400 about i.e. Amounts. Is there a way to figure out the key fields?

Answer Question   |  March 17, 2012  10:29 AM
AS/400, AS/400 Fields, as/400 files

AS400 – Files
I am using one File in Rpgle Program. I am reading the File. In debug mode, I am trying to see all the field values which is in File. But i am not able to see all the field values. I am able to see the field values which i used in program. What is [...]

Answer Question   |  March 19, 2012  11:19 AM
as/400 files

Create a LF based on a particular member in a multimember PF
Hi,  How can I create a LF using crtlf command based on a particular member in a multimember PF? Where I have to specify the member name?

Answer Question   |  June 24, 2011  12:23 PM
as/400 files, CRTLF, Logical Files, Physical file members

Retrieving remote Files from AS/400
I’m running SFTP and I just want to receive files that begin with JR. .. I tried using a JR*.* but got everything … any ideas ? Thanks in advance

Answer Question   |  March 29, 2011  7:32 PM
as/400 files, AS/400 SFTP, SFTP

Remove SAVF from SAVF in AS/400
I have a lib that I have backed up in a savf. I then ftp this savf over to another as400. I would like to edit this savf file because there are several savf’s inside of this savf that I dont need on the other as400. I guess my qeustion is, Can I edit the [...]

Answer Question   |  December 6, 2010  7:24 AM
AS/400, AS/400 backup, as/400 files, AS/400 FTP, AS/400 Library, SAVF

File with varying record length in AS/400 RPGLE
Can a file having varying record length be used in the same rpgle program? If so let me know on how to implement it.

Answer Question   |  June 23, 2010  12:04 PM
AS/400, as/400 files, RPGLE

AS/400 Integrated File System problem
when I used the path as ‘/demo/file1′ to open the stream file using API QHFOPNSF I’m getting the error “File system name demo not found.” Aren’t the file system and directory are same?

Answer Question   |  June 25, 2010  4:08 PM
AS/400, as/400 files, Integrated File System