• AS/400 logical files

    A PF has 10 LF’s. Normally, when the PF is updated, the data in the LF is immediately reflected. However, there is a scenario wherein when the PF is updated, I (the user) do not want to see the updated data reflected in any of the LF. How do you achieve this objective?

    As400am5 pointsBadges:
  • Database member Cross reference in Qsys? – Where’s it hidden?

    A number of useful objects are in Qsys these days. Items like QADBIFLD are very useful when you want a system wide search for a field. I've been looking for the equivalent for file members. Specifically, I want to search for all occurrences of a given file member name across the system's many...

    Yorkshireman5,580 pointsBadges:
  • Converting Data in Excel to PF on DB2/400

    Hi All, I have data in the excel where each column equal to the field of a physical file. I want load this data into the PF on AS/400. Could any one let me know the process on how to do it. Thanks in advance

    rajsubhyd105 pointsBadges:
  • Display files in AS/400

    I am getting stated with RPG400.I have 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 create 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...

    AnonymousUser13,030 pointsBadges:
  • 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,970 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!

    HABBIE845 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,970 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

    HABBIE845 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

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

    HABBIE845 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