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.
Answer Question
| February 1, 2013 3:06 PM
DDS, Physical File
Would journaling over a multiple member physical file cause duplicate records? The DDS of the file does not have UNIQUE.
Answer Question
| February 1, 2013 3:06 PM
DDS, Physical File
How to change a field description
I plan to re-use an unused field in a PF. Of course, I want to give it a new COLHDG. My question is … how to do this without re-creating the PF? I did this once (4 years ago) but I don’t remember what command I used to make it “take” (just changing the source [...]
Answer Question
| January 22, 2013 7:34 PM
AS/400, DDS
I plan to re-use an unused field in a PF. Of course, I want to give it a new COLHDG. My question is … how to do this without re-creating the PF? I did this once (4 years ago) but I don’t remember what command I used to make it “take” (just changing the source [...]
Answer Question
| January 22, 2013 7:34 PM
AS/400, DDS
AFPDS PRTF special character printing within text string?
Is it possible to include a special character within a text sting output to an AFPDS print file? We have output the special character by using a symbol character set but it has to be output as an individual field and results are not perfect for different printers. Has anyone created a DDS Print file [...]
Answer Question
| January 8, 2013 9:02 PM
AFPDS, AS/400, DDS, FNTCHRSET, PRTF
Is it possible to include a special character within a text sting output to an AFPDS print file? We have output the special character by using a symbol character set but it has to be output as an individual field and results are not perfect for different printers. Has anyone created a DDS Print file [...]
Answer Question
| January 8, 2013 9:02 PM
AFPDS, AS/400, DDS, FNTCHRSET, PRTF
Mandatory Field on Display File in AS400
I have a display file with mandatory fields. Is there anyway that i can highlight those fields to bring attention to the user? The same behavior that AS400 makes when we attempt to execute a command without completing all the required parameters. Note: I have used DSPATR(HI) or DSPATR(RI) and they have different behaviors. Thanks.
Answer Question
| August 28, 2012 2:28 PM
DDS, Display File, DSPATR, mandatory fiels
I have a display file with mandatory fields. Is there anyway that i can highlight those fields to bring attention to the user? The same behavior that AS400 makes when we attempt to execute a command without completing all the required parameters. Note: I have used DSPATR(HI) or DSPATR(RI) and they have different behaviors. Thanks.
Answer Question
| August 28, 2012 2:28 PM
DDS, Display File, DSPATR, mandatory fiels
Get list of files used in a code
Hi Is there any way we can get the list of files used in an RPG/RPGLE code. I want to check the Level Check Identifier Code used in my file (Checked using DSPFD command) with the Level Check Identifier of same file used in program. Thanks
Answer Question
| July 16, 2012 5:05 PM
DDS, Level Check, RPG
Hi Is there any way we can get the list of files used in an RPG/RPGLE code. I want to check the Level Check Identifier Code used in my file (Checked using DSPFD command) with the Level Check Identifier of same file used in program. Thanks
Answer Question
| July 16, 2012 5:05 PM
DDS, Level Check, RPG
Storing HTML in a Physical File
Hello everyone, I’m looking for ideas for the best practice of storing HTML in a Physical File (PF). - A huge character field with VARLEN? - Some other data type available in DDS? Can’t describe the PF with SQL (I’d like to, but need to use DDS). Thanks in advance! Dave
Answer Question
| June 21, 2012 2:40 PM
Database, DDS, HTML, PF, System i
Hello everyone, I’m looking for ideas for the best practice of storing HTML in a Physical File (PF). - A huge character field with VARLEN? - Some other data type available in DDS? Can’t describe the PF with SQL (I’d like to, but need to use DDS). Thanks in advance! Dave
Answer Question
| June 21, 2012 2:40 PM
Database, DDS, HTML, PF, System i
RPG internally described output (printer) file to DDS
How do i convert an old RPG internally described output (printer) file to an externally described DDS printer file?
Answer Question
| March 31, 2012 4:20 PM
DDS, iSeries printing, RPG, V5R4
How do i convert an old RPG internally described output (printer) file to an externally described DDS printer file?
Answer Question
| March 31, 2012 4:20 PM
DDS, iSeries printing, RPG, V5R4
ODBC problem Changing Structure Table
I have a client program conncected via odbc to AS400, I defined a structure table (DDS) in the AS400 that the client program use, then I had to change the length of numeric field (3 to 8) but the client program not recognized. What I have to do?
Answer Question
| March 31, 2012 5:18 PM
DDS, ODBC, V5R3
I have a client program conncected via odbc to AS400, I defined a structure table (DDS) in the AS400 that the client program use, then I had to change the length of numeric field (3 to 8) but the client program not recognized. What I have to do?
Answer Question
| March 31, 2012 5:18 PM
DDS, ODBC, V5R3
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 [...]
Answer Question
| March 31, 2012 1:12 PM
AS/400, AS/400 Subfiles, DDS, RPGLE, Subfiles
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 [...]
Answer Question
| March 31, 2012 1:12 PM
AS/400, AS/400 Subfiles, DDS, RPGLE, Subfiles
Displaying a standalone UIM panel?
Suppose you wanted to provide users with the contents of a few pages of text coded as UIM panels. There used to be a DSPHLPDOC which would show a resolved document from a folder. No Officevision (aka Displaywrite) now though. Any ideas ?? – trying to avoid using a DDS screen of literals or coding [...]
Answer Question
| June 30, 2011 2:23 PM
DDS, DDS Source, UIM QPNLSRC, V5R4
Suppose you wanted to provide users with the contents of a few pages of text coded as UIM panels. There used to be a DSPHLPDOC which would show a resolved document from a folder. No Officevision (aka Displaywrite) now though. Any ideas ?? – trying to avoid using a DDS screen of literals or coding [...]
Answer Question
| June 30, 2011 2:23 PM
DDS, DDS Source, UIM QPNLSRC, V5R4
Printing Electronic Signature that is Printer Resident
HELP!!! I am trying to print an electronic signature that is printer resident on an HP printer attached trough the LAN. I have the PCL Escape sequence from the manufacturer. So far, I have retrieved the WSCST source, modified it to include an INDFNTE tage with a unique font id (used to passs the PCL [...]
Answer Question
| June 24, 2011 2:47 PM
AFPDS, AS/400 - DDS, AS/400 printing, DDS, iSeries V6R1
HELP!!! I am trying to print an electronic signature that is printer resident on an HP printer attached trough the LAN. I have the PCL Escape sequence from the manufacturer. So far, I have retrieved the WSCST source, modified it to include an INDFNTE tage with a unique font id (used to passs the PCL [...]
Answer Question
| June 24, 2011 2:47 PM
AFPDS, AS/400 - DDS, AS/400 printing, DDS, iSeries V6R1
How to speed up AS/400 SQL?
We have SQL on our Data Warehouse written using SHOWCASE. The SQL could be better, it is not SO bad for something writen with a drag and drop gui, but the execution is far too slow – 12 minutes to extract data from the main 3.5 million record file, with several left outer joins. So, [...]
Answer Question
| June 8, 2011 8:46 AM
AS/400 - DDS, AS/400 SQL, Data warehouse, DDS, Showcase
We have SQL on our Data Warehouse written using SHOWCASE. The SQL could be better, it is not SO bad for something writen with a drag and drop gui, but the execution is far too slow – 12 minutes to extract data from the main 3.5 million record file, with several left outer joins. So, [...]
Answer Question
| June 8, 2011 8:46 AM
AS/400 - DDS, AS/400 SQL, Data warehouse, DDS, Showcase
Restoration of back ups taken on Dat through tar -cvfr /dev/st0 – RHEL 5.0
Backups are being taken on Dat DDS4 format OS RHEL 5.0. The command is used tar -cvfr /dev/st0 File name. Thus the backups are being taken no of times in one Dat. How to restore the backup of a file which has been taken after first occurence?
Answer Question
| December 6, 2010 5:16 AM
Backup, Backup and restore, DDS, RHEL 5
Backups are being taken on Dat DDS4 format OS RHEL 5.0. The command is used tar -cvfr /dev/st0 File name. Thus the backups are being taken no of times in one Dat. How to restore the backup of a file which has been taken after first occurence?
Answer Question
| December 6, 2010 5:16 AM
Backup, Backup and restore, DDS, RHEL 5
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.
Answer Question
| October 6, 2010 6:22 AM
AS/400, AS/400 flat file, DDS, FMTDTA
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.
Answer Question
| October 6, 2010 6:22 AM
AS/400, AS/400 flat file, DDS, FMTDTA
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?
Answer Question
| June 1, 2011 6:41 AM
DDS, DDS Source, Synon, 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?
Answer Question
| June 1, 2011 6:41 AM
DDS, DDS Source, Synon, Synon USRSRC
Create more member to single physical file
I TRYED TO CREATE MORE MEBERS TO THE PF WITH CRTPF COMMAND AND ALSO GAVE *NOMAX OPTION TO PF .BUT IT IS NOT POSSIBLE FOR ME?HOW TO CREATE A MORE MEMBERS TO PERTICULAR PF ? PLEASE GIVE ME CLEARY?
Answer Question
| September 30, 2010 1:46 AM
AS400 physical file, DDS, Physical Files, V5R3
I TRYED TO CREATE MORE MEBERS TO THE PF WITH CRTPF COMMAND AND ALSO GAVE *NOMAX OPTION TO PF .BUT IT IS NOT POSSIBLE FOR ME?HOW TO CREATE A MORE MEMBERS TO PERTICULAR PF ? PLEASE GIVE ME CLEARY?
Answer Question
| September 30, 2010 1:46 AM
AS400 physical file, DDS, Physical Files, V5R3
how to change AS/400 Textbase application to windowslike application
Hey, who can give me advice, or has experince, to change an textbase AS/400 RPG & DDS application to an windowslike application?
Answer Question
| May 19, 2010 1:46 PM
Applications development, AS/400, DDS, RPG
Hey, who can give me advice, or has experince, to change an textbase AS/400 RPG & DDS application to an windowslike application?
Answer Question
| May 19, 2010 1:46 PM
Applications development, AS/400, DDS, RPG
SQL index on dds file
Will and existing rpg program that is doing a file read/table scan utilize an sql index with changing any of the rpg program?
Answer Question
| March 5, 2010 2:43 PM
DDS, SQL, sql indexes
Will and existing rpg program that is doing a file read/table scan utilize an sql index with changing any of the rpg program?
Answer Question
| March 5, 2010 2:43 PM
DDS, SQL, sql indexes
Tab to Output fields in DDS
I have a screen layout in DDS that only has one input field and a large number of output fields. Users can put their cursor on a few of the output fields and hit F4 to see what makes up the value of that field. I would like the user to be able to tab [...]
Answer Question
| February 16, 2010 8:15 PM
AS/400, AS/400 programming, DDS
I have a screen layout in DDS that only has one input field and a large number of output fields. Users can put their cursor on a few of the output fields and hit F4 to see what makes up the value of that field. I would like the user to be able to tab [...]
Answer Question
| February 16, 2010 8:15 PM
AS/400, AS/400 programming, DDS
DDS Logical File
How can i create one Logical File based to more than one Lib
Answer Question
| January 18, 2010 5:24 PM
AS/400 - DDS, DDS, DDS Logical Files, Logical Files
How can i create one Logical File based to more than one Lib
Answer Question
| January 18, 2010 5:24 PM
AS/400 - DDS, DDS, DDS Logical Files, Logical Files
