• How to detect a non empty physical file using CLP

    How can I detect a non empty phyiscal file using CL

    aderene180 pointsBadges:
  • DDS with temporary name for Physical file

    Good day all ! On AS400 I have a CL program that creates a temporary Physical file with variable name. File name is created with "user_id + job_name + time". How can I create a logical file, specifying in DDS for logical file that my PFILE is temporary and has variable name ? Thanks !

    Lenny2113115 pointsBadges:
  • Physical file over 600 000 000 records

    Hi We have a Physical file which has more than 60 million records in it. In our application we search for the particular records based on 6 fields as a search criteria (web based) , search process are done in SQL Procedures. Even when i creatd a LF based on the mandatory search fields , we get  a...

    As400programm10 pointsBadges:
  • source physical file snd member

    how system identify that this member is a member of this source file in as/400?

    Dineshtiwari5 pointsBadges:
  • How to differentiate between newly added records and previously added records in Physical file

    i have physical file in which records are added on daily basis. i have to copy record to another Flate file. How can i recognise the block of newly added records? There is no date field in Physical File sothat i can copy records on date basis.

    Kapiltiwari350 pointsBadges:
  • Printing Physical File Records

    I wanted to print the Records in Physical File with out using 1. RPGLE Program 2. Query I wanted to print the PF records using WRKMBRPDM and Option 6 Please help me to find the solution

    rajeshece1,215 pointsBadges:
  • AS400 Physical file conversion to xml file

    Hi, i need to write an RPGLE program to convert an as400 physical file to an xml file. Does anyone have a sample code for it? Thanks in advance.

    Siri55 pointsBadges:
  • Copy logical to different physical

    using STRPDM I would like to create a copy of an existing logical over another physical. For example: Copy the logical F0911LA that is over the F0911 in TKDATA Production TO be created over a F0911 physical in the ARCDATA library in the same Lpar

    Tbc5 pointsBadges:
  • AS400 I have a flat physical file,this flat file will be updated daily by datewise.I have to use an CLP for copying the records by the datewise daily

    I have a flat physical file ,this flat file will be updated daily by date wise . I have to use an CLP for copying the records by the date wise daily and copy that data to another Physical file and change the naming conventions of the file and send the data to mainfram system using FTP( FTP too we...

    Sunilinline25 pointsBadges:
  • Accessing AS/400 DB2 physical files with Java

    Hello All, We have one JDE Word Writer program, which export the order master data in the DB2/400 Physical files. We want to access this data from our java program (reside on windows platform). I am wondering how we can do that. I got one hint that can be accessed by ODBC connection. But I am...

    GeethaNatarjan15 pointsBadges:
  • Flat file to PF conversion

    Hi, can anybody tell me how to transfer the entire flat files contents to a new Physical file in regular fields format?

    ten20081,150 pointsBadges:
  • DB2/400 – Source Physical File Deletion?

    I have a question related to DB2/400. Let’s say, your source physical file name is “QDDSSRC” and inside this source physical file when you try to create a physical file with name same as that of source physical file “QDDSSRC”, if I am not wrong the source physical file will get deleted....

    BibinGeorge130 pointsBadges:
  • How can I convert all the records from a Physical File to Exces ?

    I would like to know how can I achieve this ? and I am working on V4R4. Example : PF1 contains 100 records , I need to convert this into Exces .

    Chrisjam95 pointsBadges:
  • DB2 logical files

    HI, i wanted to know if i can add a new field to a PF via a logical file. If yes give me an example. thanks....ram

    ten20081,150 pointsBadges:
  • Seeing where a member is deleted in a journal

    I have a situation where a member is being created in a physical file and is later being deleted by some process, human or automated. I'm trying to find what is removing the member and set up a journal to find the answer. I am able to readily see where the member is created, where records are added...

    Tsettimo35 pointsBadges:
  • Non-display fields in physical file

    i want to create a PF in which i want to declare fields as non display.Can u help me out

    Babs30 pointsBadges:
  • 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 but when i run this a dump...

    Ambrish 82310 pointsBadges:
  • WRKOBJ System Physical File (QSYS)

    Hi guys, Do u guys know what is the name for the physical file of WRKOBJ in Qsys? I need to OVRDBF with this file. Do u have the reference for the System Physical file for AS400??? Thanks!!!

    SoulReaper20 pointsBadges:
  • Describing files using Data Description Specifications (DDS)

    Describing Files Using Data Description Specifications (DDS)'can u tell me what is the probleme IN PF

    Rmonga23065 pointsBadges:
  • Position to in Single page subfile

    Hi I have one PF with Policy No . , Cust. Name and both fields are key fields in PF . I want to use position to for field cust name which is the second key field in PF . So is there any way to do this without creating any Logical file ??????(in single page subfile)

    S2235 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