How to export an AS/400 physical file to Microsoft Excel?
how to export as400 physical file to excel
how to export as400 physical file to excel
5 pts.
Query/physical file headings
Hi, I have a query that creates a file. I transfer the file to my C drive as a cvs file that I send out to a vendor. He would like headings on the file.....I can't seem to find out how to do this.....I know this is a silly question but how can I get the column headings on the file? If I import...
Hi, I have a query that creates a file. I transfer the file to my C drive as a cvs file that I send out to a vendor. He would like headings on the file.....I can't seem to find out how to do this.....I know this is a silly question but how can I get the column headings on the file? If I import...
Embedded SQL over multiple physical file members
Hi, I'm writing a program to process all the members in a physical file. I've done this using embedded SQL because the selection criteria is quite complex. The physical file belongs to an application which I can't change, so I will always have to deal with multiple members. I also don't have...
Hi, I'm writing a program to process all the members in a physical file. I've done this using embedded SQL because the selection criteria is quite complex. The physical file belongs to an application which I can't change, so I will always have to deal with multiple members. I also don't have...
Record addition in a PF
I have a PF with some data in it which i am using in a RPG program. I got another text file with extra data related to PF in it. I have to add this data to the existing data in the PF, Please tell me how can i do this from my RPG program....advance thanks
I have a PF with some data in it which i am using in a RPG program. I got another text file with extra data related to PF in it. I have to add this data to the existing data in the PF, Please tell me how can i do this from my RPG program....advance thanks
How to send the data from a Physical file to a Flat file
Please check the below prgram and advice me how to send the data from APH(physical file) to Flate file SAAPH (flat file). FTRF is a datstructure created for send the data only this two fields in flat file. i am not sure how to club this data structre and flat file in programe. FAPH IF E ...
Please check the below prgram and advice me how to send the data from APH(physical file) to Flate file SAAPH (flat file). FTRF is a datstructure created for send the data only this two fields in flat file. i am not sure how to club this data structre and flat file in programe. FAPH IF E ...
AS/400 script or program needed
I want script or a program which can be called so that i can get the specific information from the system and prints for me in Spool file. For example, i want to know all the PF which are attached to Triggers and their action and also the library. Can any one give a sample script for this or any...
I want script or a program which can be called so that i can get the specific information from the system and prints for me in Spool file. For example, i want to know all the PF which are attached to Triggers and their action and also the library. Can any one give a sample script for this or any...
source physical file snd member
how system identify that this member is a member of this source file in as/400?
how system identify that this member is a member of this source file in as/400?
How to get the row count of a PF with RPG ILE?
Hello, I'm looking for an example of how to get a row count of a PF from a ILE rpg program. Thanks everybody.
Hello, I'm looking for an example of how to get a row count of a PF from a ILE rpg program. Thanks everybody.
How to view online the new data added to a PF?
Hi, I need to display in a subfile the new data added to a phisical file, in real time. Who knows unix, this is something like the command "tail -f". Thanks a lot!
Hi, I need to display in a subfile the new data added to a phisical file, in real time. Who knows unix, this is something like the command "tail -f". Thanks a lot!
Clearing a PF record on AS/400
I'm chaining a field to a unique keyed PF. I'm getting a not found indicator so I'm trying to write the record but I receive a duplicate key error. How this can be I do not understand. A colleague suggested that a field (or fields) within the record might be a key of other LF's over the file and...
I'm chaining a field to a unique keyed PF. I'm getting a not found indicator so I'm trying to write the record but I receive a duplicate key error. How this can be I do not understand. A colleague suggested that a field (or fields) within the record might be a key of other LF's over the file and...
Searching out and eliminating unuse files on AS/400
We have over 1700 files & members in a production library, and we know that there are many that are no longer used or pertinent. We thought we could clean these up by running DSPFD to a physical file and checking such parameters as "last used date", but this seems to be ambiguous and fraught with...
We have over 1700 files & members in a production library, and we know that there are many that are no longer used or pertinent. We thought we could clean these up by running DSPFD to a physical file and checking such parameters as "last used date", but this seems to be ambiguous and fraught with...
Differnce between source physical file and physical file on AS/400
What is AS/400? Difference between source physical file and physical file?
What is AS/400? Difference between source physical file and physical file?
XML to Physical file
We will be receiving a file in XML format. Is there a way that I can convert file to a physical file on the 400.
We will be receiving a file in XML format. Is there a way that I can convert file to a physical file on the 400.
AS/400 - Physical File in update mode
hi all, i have a physical file i need to update that file (not append) ,I opened that file in update mode eg F MYFILE UF E K DISK (i didn't mention 'A' because i dont need to append records) now after certain checks i update (any field) with syntex. UPDATE RECORD FORMAT ...
hi all, i have a physical file i need to update that file (not append) ,I opened that file in update mode eg F MYFILE UF E K DISK (i didn't mention 'A' because i dont need to append records) now after certain checks i update (any field) with syntex. UPDATE RECORD FORMAT ...
AS/400: Unique records in file
hi all, i have a problem , suppose i have a physical file which has multiple occurrences of fld1 , now i need to access that in distinct (one data single time) order. so i created a logical file with UNIQUE keyword . but when i make query on this LF then msg comes that no member found. and a dump...
hi all, i have a problem , suppose i have a physical file which has multiple occurrences of fld1 , now i need to access that in distinct (one data single time) order. so i created a logical file with UNIQUE keyword . but when i make query on this LF then msg comes that no member found. and a dump...
Display files in AS/400
I am getting stated with RPG400.I hev this requirement to add a new field in an existing screen and move this value to a new PF.This is when the screen is opened in crete mode. the other screen where the new field is to be added is the update screen.In this screen value is to be retrieved from the...
I am getting stated with RPG400.I hev this requirement to add a new field in an existing screen and move this value to a new PF.This is when the screen is opened in crete mode. the other screen where the new field is to be added is the update screen.In this screen value is to be retrieved from the...
iSeries: Accessing src PF member using Java/400
I am a veteran iSeries programmer but new to Java. We have a requirement of reading src PF member as record (each line) and to be transmitted. Also, incoming streams to be created as a src PF member by adding the recs in it. Which Java/400 class can be used to read from a member (e.g...
I am a veteran iSeries programmer but new to Java. We have a requirement of reading src PF member as record (each line) and to be transmitted. Also, incoming streams to be created as a src PF member by adding the recs in it. Which Java/400 class can be used to read from a member (e.g...
Finding newly created objects
I am trying to define a query to find any newly created objects ona daily basis. I have scheduled a job to run daily that creates a file to display all DSPOBJD which outputs into a physical file. I now want to query this file to find anything created on the previous day (the job runs overnight)....
I am trying to define a query to find any newly created objects ona daily basis. I have scheduled a job to run daily that creates a file to display all DSPOBJD which outputs into a physical file. I now want to query this file to find anything created on the previous day (the job runs overnight)....
Copy data from flat file to a flat file
My requirement is : I need to copy data from 1 big flat file to a flat file,but size of this flat file must not > 3MB, if size increases then new members will be created and remaining data will be copied there ….so on..hence this small files will only contain records with size upto 3mb. Can...
My requirement is : I need to copy data from 1 big flat file to a flat file,but size of this flat file must not > 3MB, if size increases then new members will be created and remaining data will be copied there ….so on..hence this small files will only contain records with size upto 3mb. Can...
