• 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!

    HABBIE805 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

    hunshabbir7860 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

    HABBIE805 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

    HABBIE805 pointsBadges:
  • CDSND Connect: Direct issue

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

    ssssssssssssssss110 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.

    HABBIE805 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?

    ssssssssssssssss110 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,375 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,850 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...

    sivakesava255 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'...

    sivakesava255 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:
  • Pre run time array

    In my PF, one record is there with 40 fields and each field length is 2. Now I declared one array like this: D ARR      S  2  DIM(40) Now I want to move all the 40 fields data into array in a single statement. Can anyone help with this?

    421380 pointsBadges:
  • Altering keyfields inside RPG Program

    Hi all, I have a  Physical file PF with 5 different logical files (LF). PF don't have any keys at all. In RPG program I need to perform a CHAIN on this file with 2 key-fields in which 1 of the key is defined as key field in some LF's. But the other is not. Now I was asked to perform CHAIN without...

    Sai4AS4001,420 pointsBadges:
  • Sort file based on a key in another file

    Here is a scenario. I have a balance file which has account number and balance in it. I want to create a report out of it. The report should looks like this, it shows the Rank,(Rank 1 means account with highest Balance) Account number, and Balance order by Rank. There is another Account master file...

    RamvishakRamesh2,505 pointsBadges:
  • Delete duplicate members from a physical file using RPGLE

    Hi, could someone please help me with the code to delete duplicate records from a physical file. Please post with the full code.

    AS400dot5 pointsBadges:
  • Help with iSeries CRTLF command

    I need to create a logical file over a physical file. Can someone help me understand what I am doing wrong. The physical file is in library IDSDAYA and is called OOIORDDP. It has 6 members and I am interested in creating a file where I can access the data in three of the members at one time. I...

    mgrady15 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