• Duplicate object (PF) using SQL with same attributes

    I want to create a duplicate object using SQL. I don't want to use CRTDUPOBJ and also do not want to compile my rpg's pgm because of new file level identifier. Please advice

    Anwer5 pointsBadges:
  • Flat file or Physical file in as/400?

    How to know whether a file is physical file or flat file in CL/400?

    Alicsc370 pointsBadges:
  • How to create a physical file without CRTPF

    How to create a physical file without CRTPF command?

    vasanthisrini10 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:
  • Transfer data from iSeries

    How can the field attributes of a physical file be transferred to a text file on a PC?

    hcooper15 pointsBadges:
  • 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...

    Babs312195 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,665 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,665 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,445 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