• AS/400 DDS mandatory check issue

    Good morning, So my issue is that I have an input screen it asks a user to input a bunch of fields and write/updates a file and a lot of the fields on screen need to be ME (mandatory entries). What I'm trying to do is not have the screen clear when the user hits enter. (So if it fails a check the...

    bp0144290 pointsBadges:
  • AS/400 printer file – record automatically moves to next line

    I am trying to read a file containing 12 records and want to display in spool file as 4 rows and 3 columns. First record and second record are written properly (into 1st and 2nd columns of first line) however, third record automatically moves to second line (3rd column): Printer file code: O E...

    sri8707105 pointsBadges:
  • Insert lines in DDS using Synon USRSRC

    Depending on the field conditions, I need to include lines in DDS using Synon USRSRC. Is it possible to include lines in DDS for different fields..i.e.in same USRSRC??? Please guide me if anybody have come across this situation?    

    MAGIC205 pointsBadges:
  • How to format a flat file using customised FMTSRC

    Hi, I have a falt file.i want to sort it using a customised format source file.Please tell me how to create a source file for formatting the flat-file.I want the sample of a DDS of sort.

    Supriyoas400250 pointsBadges:
  • Create iSeries PF with multiple record formats

    How can I create an iseries PF with multiple record formats

    aderene185 pointsBadges:
  • Logical File key not working

    I am creating a new logical over a physical file. Very basic. Just one key field. It is a character file as the key. R RUB04000 PFILE(RUB0400F) K TRALER. After I create the logical file successfully and check the records, the records are NOT in the sequence as defined in the logical file DDS. I...

    Philcards15 pointsBadges:
  • Problem with character alignment on output or retrieval of variables

    We have an issue we have never seen before but I'm sure happens all the time. We have a DDS screen where the character's are shown as follows:- RETAIL LOGISTICS                     : £99.00 RETAIL FREIGHT                         :£120.00...

    Sxlad200145 pointsBadges:
  • CONCATENATING in DDS

    Can you concatenate 2 fields in DDS which were created using the substring command?

    GHENDER220 pointsBadges:
  • Any way to limit color choice for background?

    I discovered a user who set the background color of his RF device to RED. Of course, most error/info messages are in RED, so he mostly can't see them. Is there a way to restrict or override the user's background color? I have no info on the device being used - hoping I can do something...

    aceofdelts2,445 pointsBadges:
  • Merge two Physical Files using Logical File

    I have multiple Physical files (Trans2006, Trans2007, Trans2008, etc…) with same record layout with the yearly transactions on my iSeries. I want to merge these files (for temporary period). Is it possible to create a Logical file? If so please help me.

    nhewage50 pointsBadges:
  • Subfile load all & expandable

    Hi , i have some confusion beween load all & expandable subfile, for example in case of load all Pf has 100 records sfksiz=20 and sflpag =10   but if i am writing more then 20 records , but it should allow only 20 records in load all subfile because sflsiz=20 but its allowing to write more...

    Rpgle400tech145 pointsBadges:
  • Looking for less complex DSM interfaces

    We have recently developed a business application using external definitions stored in a database file - such as fields definitions, data structures, validity checks, and so on. One of the uses of this external data has been to generate a DDS source that is then compiled into a DSPF. I would like...

    AS400 - Ask the Expert485 pointsBadges:
  • Font code for MICR printing

    We are using the forms overlay feature in the AS/400 to generate checks. We use the font command in the print file DDS to specify the MICR font. The bank does not like the MICR font we have selected. Can anyone tell me the MICR font they use which their bank accepts?

    WoodEngineer7,640 pointsBadges:
  • DDS or SQL

    We have an existing COBOL application using files defined in DDS format. We are considering to move from DDS to DDL for future development. What is the best strategy to take this approach?

    Uiiuo50 pointsBadges:
  • DDS Keywords for AS/400 Windows screens

    I have an Interactive Maintenance Screen program that calls a program to display an AS/400 Windows. When I get to the first Screen and the call to the AS400 Window display is made, the background is blacked out and only the Window shows up. Is there any way that the background (first) Screen can be...

    Ppeier10 pointsBadges:
  • Need to find everyplace a file is being used.

    I have a file that we are adding a field. Need to find every program the file is being used to know which ones need to be recompiler. Would be nice to do one big search of the entire library. 

    nitzinger385 pointsBadges:
  • -ve Sign deletion from Screen DDS Display

    Hi,I have a display file with some numeric fields in which some fields are containing '-' (-ve Sign) at the end. How to remove it from appearing on the screen while seeing (by option 12).?. My screen is like this.. 999- 999- Here both are of size 9(4). Please reply me. Thanks!

    Sai4AS4001,420 pointsBadges:
  • Display file record format Merging

    Hi all, How to merge 2 or more record formats of a display file while displaying (Exfmt    A ) in AS/400. Please note that the Record formats are not of type SFL here. Here A  B and C are  Different Record formats. On Exfmt A/B/C. all should display together. How to do it?. Please reply.

    Sai4AS4001,420 pointsBadges:
  • Compile SQLTBLSRC on AS/400

    How do I compile a SQLTBLSRC on the AS/400?

    Amartin1510 pointsBadges:
  • Duplicate records in a keyed physical file

    Would journaling over a multiple member physical file cause duplicate records? The DDS of the file does not have UNIQUE.

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

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

Following