Forum: DDS

Hi I have to code display file in a way that after 30 mins idle time it should auto signoff, can someone please tell me display file keywords (forcedata etc) used for this coding in RPG???? thank you

Whats the difference between Multiple Format Logical File and Join Logical File?

Hi in my master file some records for the particular file was missing so i need to move from another table to this.how will u do this in sql or by copy file. and also how to copy particular records using copy file from one file to another for eg...filea and fileb we have all the same...

Hi, I have an application where there are 16 entries listed, per screen, in a subfile. There is a function key setup to drop the records to show additional data. Currently this data is comprised of a few lines of fields and several lines of text. These lines of text are causing me to only be able...

i had one simple doubt regarding files operation i had one file in four libraries like 1,2,3,4 i update the file using program..i set the library list as 4,3,2,1 in what manner it will get updated?

I have a sfl which has many options that can be requested via a 2 byte numeric input/output field and after one of the options is requested, I receive the message above. The option in question here is to copy an existing record which is mostly internal. Then, when I position the record, clear...

HI is there any way to find all the programs that is using particular file...

hi all i want to know exactly what is a print file? and what is display file? so who know please answer for me. thanks you so much

Is there a way to force the screen to be no bigger than 24 characters wide and 16 lines long? Regards, David

I have a 3 numeric field in a file that I am trying to display as 00 on my display. I use the EDTCDE(J) code but it comes out with just one zero not two. Can one recommend a way to display a 3 numeric pack field as 00 on a dds display screen. Thanks, DAC

hello, I'm new to this forum and as400 also. I just want know whether it is possible to use As400 C with a display file?? many thanks Anuradha

hi to all why is commit and rollback used?...even though i goggled ...i got confused....becoz we had commit through CL , db2-sql....what is the difference while doing in sql and cl(strcmtctl)....can you explain it with examples... sorry do u felt it was silly questions

is this possible to runqry reference file....?

HI somebody deleted some records from physical file through sql session. lot of user are there.is there any way to find out which user did this? DSPFD shown only show the number of deleted records , date and time...dsplog wont show anything? please do the needful?

hi is it possible to restore the deleted records in physical file ? please help me very urgent............

hi i have again with some doubts. ...i having one display file..here we give the date fld ( from and to date)how its possible to move that fld into the file source....we have the date field like from and to date field in the file

Does anyone have an example of using *DS3 and *DS4 in a DSPF using a Subfile as *DS4 with additional Records as *DS3? For reasons unknown to the common man, I can't seem to get it to compile for any reason what soever!! Records: HDR1 SUB1 CTL1 FTR1 SCR1

I've been in the information business for almost 2 years, and sometimes it seems that I've spent half that time sorting data. Without question, putting data into proper sequence is a big part of our jobs. Card sorters are ancient history. Sort utilities (e.g., #GSORT and FMTDTA) still run, but...

Many people don't realize that they can use the Change Physical File command to alter the field and key definitions of a physical file without having to recompile that file or to save and restore their data. This command can enlarge or shrink existing file fields, add new fields, delete old fields,...

how to send the input to the wrkqry through programs. actually. in my query i have to give the date input in record selection is it possible to give that one through some diplay file.?

hi i am having the single format display file.i need to enter fields,update options through function keys...like that here i have to lock the input fields...when i press some function keys it is open for write,or editing.otherwise it should locked...how its possible....

how to move the screen field value to another screen. for example...in first screen we have the policy :XXXXXXXXX second screen also have the policy.is it possible to move the policy value xxxxxxxx of first screen to second screen.

Program Terminated Due To Status 9P In File ...WHAT DOES IT MEAN

hi my client wants me add some new options in the screen.how to find the program for that screen?also the same program in different libraries.how do find the correct program which the screen refers?

I think I'm slowly getting mad. :duh I'm trying to print in 2 different fonts in one printfile. My printfile looks something like that: A R HDR A FONT(2305 (*POINTSIZE...