• Creating CSV file from AS/400 fixed length physical file

    We are having a requirement that we need to create an interface file with different sections as follows. File Header, Data Header, Data Details and Footer. Each record is of variable length. But the information should follow the same format such as File Header should be first record then followed...

    Babs312175 pointsBadges:
  • Program to get all the member name in source physical file

    Hi, I need all the members list in source physical file (QRPGLESRC) to the workfile (PF). How to use the DSPFD in RPGLE program to populate all the members in the outfile. Please share some example program. And I want to override concept to read all the members. Please share any example program. I...

    srivijay1145 pointsBadges:
  • Reading the part of the AS/400 string

    Hi, I have a Source line in QRpglesrc, There are N number of source line in my source physical file (Qrpglesrc). In that For Example I have a field, with Item = 'find the number of string' to be read. I want a logic to pick only the string within the quotes. it mean i need to pick the string within...

    srivijay1145 pointsBadges:
  • Dynamic ALIAS creation in iSeries

    I need to make a query against a physical file that has 30 members. For this I have chosen to create ALIAS, this means that i have to create 30 aliases. Is there any way to iterate alias creation through a FOR statement dynamically?

    GianDamico25 pointsBadges:
  • *LOVAL in RPG3

    Hi all I want to read a physical file. Before reading I am doing SETLL to position pointer at the top of PF. But when I read the record it switch on EOF indicator with SETLL. What could be the reason?  *LOVAL SETLLTSTPF 55  I get *IN55 on every time.

    hunshabbir71,225 pointsBadges:
  • Email Format on AS/400 Fields

    Hi, I am trying to create a field on physical file, that has to store any email id such as xxxxxxyyyyzzzz@qqq.com.  Kindly let me know, how to go for this.What are the all definitions I need to specify for this field. Thanks!

    HABBIE820 pointsBadges:
  • Repositioning a Physical File

    Hi all, I have a physical file with no key defined. I want it to re-position the pointer to the top of file. Should I Open and Close the file each time, as SETLL works only on keyed files. Thanks

    hunshabbir71,225 pointsBadges:
  • SSN ID format in AS/400

    Hi, I am new to this technology. I need to create some fields on Physical file which should accept the data in the format of SSN ID (123-456-789). Kindly let me know. How can I go with this? If this is an older question, please forgive me & post that older link. Thanks

    HABBIE820 pointsBadges:
  • Creating a field in AS/400 physical file

    Hi, How to create a field in Physical file with (123 456 789). Tried with EDTWRD, unable to specify spaces in between. Thanks

    HABBIE820 pointsBadges:
  • CDSND Connect: Direct issue

    Error while executing CDSND command. (SDE0210I - Requested data set not available. Allocated to another job. )

    ssssssssssssssss115 pointsBadges:
  • How to write Multiple format for physical file using QDDSSRC create PF

    FOUNDATION PHYSICAL FILE USING QDDSSRC  CREATE F6 UNIQUE R FORMAT01 FNO 5S TEXT('FOUNDATION NUMBER') NAME 50A TEXT('FOUNDATION NAM') ADD1 25A TEXT('ADDRESS 1') ADD2 25A TEXT('ADDRESS 2') CITY 30A TEXT('CITY') STATE 2A TEXT('STATE') ZIP 12A TEXT('ZIP CODE') COUNTRY 25A TEXT('COUNTRY') TEL 20A...

    sothonod45 pointsBadges:
  • AS/400 Date Format DD-MM-YYYY

    Hi, I have a scenario. I need to create a physical file with date format of (DD-MM-YYYY).I am specifying with  *EUR/*DMYY  along with this I can't use the date separator. Kinldy let me know, how to achieve this.

    HABBIE820 pointsBadges:
  • Save physical file too small in AS/400

    I would save a PF (800G with about 3 billion records) and one of its logical file. OS is v6r1. However it said the save file is too small. I remember that this limitation of save file is 2T while the size of my physical file and logical file no more than 1 T. Anyone can help me? Thanks a lot.

    liushiqiang15 pointsBadges:
  • Send physical file in SAVF format via CDSND

    How to send physical file in SAVF format (Save file) from AS/400 server to other server via CDSND command?

    ssssssssssssssss115 pointsBadges:
  • Physical File Without Key

    Hi guys, Currently i'm using RPGLE language. If i have a Physical File that without key, How am i going to set my pointer. I can't CHAIN,SETLL and SETGT as well. In order to use them, u need have a key. Am i rite? Is there any idea to solve this matter? Thanks!!!!

    SoulReaper20 pointsBadges:
  • AS/400: Add some fields in the physical file

    Hi! Actually I have a physical file containing 400,000 records. I just want to add some fields in that file and it is referred by many programs. I know that I can use CHGPF. But I'm a bit afraid to change a big database. What are the necessary steps I can take on these process and proceed further?...

    Sureyz2,380 pointsBadges:
  • Changing a physical file definition

    I’m trying to prove how this happened. The file in TEST has an old creation date on the object but it includes 2 new fields. So not done via recompile. Is there another way to change a file definition without recompiling? I suspect maybe SQL? Please keep it simple with any reply – I don’t...

    aceofdelts1,870 pointsBadges:
  • CDSND character mapping in AS/400

    Currently in our system, we are sending a physical file using CDSND to a UNIX system. In the physical file we have '[' charecter, but when this file is transferred to UNIX system this character is changed to Ã. I want to see the [ character at UNIX system, as àcausing some issue at UNIX...

    sivakesava280 pointsBadges:
  • negative sign in physical file copy process

    this is regarding copy file.I have a physical file P1 and physical file P2. Now in P1 i have a zoned decimal field and in P2 i have a packed decimal field. let us assume i have the negative data in P1. after performig the CPYF to copy the P1 to P2, i am getting some junk characters ( '}', 'M', 'S'...

    sivakesava280 pointsBadges:
  • COBOL AS/400 – Using same field name from two different files

    Hi, I have modified a program by adding a physical file with fields fielda, fieldb and fieldc. I am also using its logical file in the program. I have redefined the physical file's record format and changed the fields name. I used redefined keyword in logical file and used filler and changed the...

    yagnasstar5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following