printing a multiple page document along with a form(PO)
Could you shed some light on how could I print a text document using DDS. Overlay does not work, and I do not want to type 2 pages on DDS, besides it should be on aseparate page looks like a standard text document and should come as one print along with my form(PO) Thanks
Answer Question
| May 1, 2009 5:57 PM
AS/400 Printer File, AS/400 printing, DDS
Could you shed some light on how could I print a text document using DDS. Overlay does not work, and I do not want to type 2 pages on DDS, besides it should be on aseparate page looks like a standard text document and should come as one print along with my form(PO) Thanks
Answer Question
| May 1, 2009 5:57 PM
AS/400 Printer File, AS/400 printing, DDS
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 !
Answer Question
| January 19, 2010 1:41 PM
CL programs, DDS, Logical File, 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 !
Answer Question
| January 19, 2010 1:41 PM
CL programs, DDS, Logical File, Physical File
Need EAN-13 DDS sample for printing a Barcode
If you have EAN Code-13 DDS sample for print a Barcode could you please send me that sample..? Thanks in advice
Answer Question
| March 3, 2011 10:43 AM
AS/400 printing, Barcode, DDS, EAN-13
If you have EAN Code-13 DDS sample for print a Barcode could you please send me that sample..? Thanks in advice
Answer Question
| March 3, 2011 10:43 AM
AS/400 printing, Barcode, DDS, EAN-13
DB2/400 field to match an Oracle VARCHAR?
We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS [...]
Answer Question
| May 18, 2009 9:03 PM
AS/400 interoperability, DB2 connectivity, DB2/400, DDS, Oracle development, Oracle interoperability, Oracle VARCHAR, VARCHAR
We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS [...]
Answer Question
| May 18, 2009 9:03 PM
AS/400 interoperability, DB2 connectivity, DB2/400, DDS, Oracle development, Oracle interoperability, Oracle VARCHAR, VARCHAR
Describing files using Data Description Specifications (DDS)
Describing Files Using Data Description Specifications (DDS)’can u tell me what is the probleme IN PF
Answer Question
| March 24, 2009 9:14 AM
Data Description Specifications, DDS, DDS Error Messages, Physical File, RPG
Describing Files Using Data Description Specifications (DDS)’can u tell me what is the probleme IN PF
Answer Question
| March 24, 2009 9:14 AM
Data Description Specifications, DDS, DDS Error Messages, Physical File, RPG
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.
Answer Question
| January 12, 2012 10:41 PM
Data Description Specifications, DDS, Logical File, Physical 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.
Answer Question
| January 12, 2012 10:41 PM
Data Description Specifications, DDS, Logical File, Physical File
DDS
How do I insert ‘ as text in DDS. Ex: Smith’s
Answer Question
| March 11, 2009 5:56 PM
DDS, DDS Character Input
How do I insert ‘ as text in DDS. Ex: Smith’s
Answer Question
| March 11, 2009 5:56 PM
DDS, DDS Character Input
AS400 DDS Specifications and Arrays
We are working toward converting our system from a S/36 to an AS400 S36/E. On the way we are attempting to create DDS specifications for our files and externally define the files to the RPG code. We are prototyping a program to read the RPG II programs and build the DDS specifications from the source [...]
Answer Question
| February 4, 2009 5:18 PM
AS/400 upgrades, DDS, DDS RPG ARRAY, S/36, S36E
We are working toward converting our system from a S/36 to an AS400 S36/E. On the way we are attempting to create DDS specifications for our files and externally define the files to the RPG code. We are prototyping a program to read the RPG II programs and build the DDS specifications from the source [...]
Answer Question
| February 4, 2009 5:18 PM
AS/400 upgrades, DDS, DDS RPG ARRAY, S/36, S36E
Problem in CCSID converting
I have a QM query that forms up a DB file. A physical file. A file that afterwards will be tranferred to the excel worksheet. All the source DB files (as well as all the records inside) that I use in the QM query are having the CCSID=297 (french). But the data itself stored in [...]
Answer Question
| January 22, 2009 5:09 AM
5250 session, AS/400, AS/400 import/export, CCSID, Change Physical File, CHGPF, Coded Character Set Identifier, DDS, iSeries Access for Windows, locale, Microsoft Excel, Physical File, QMQRY, Query Management Query, V5R3
I have a QM query that forms up a DB file. A physical file. A file that afterwards will be tranferred to the excel worksheet. All the source DB files (as well as all the records inside) that I use in the QM query are having the CCSID=297 (french). But the data itself stored in [...]
Answer Question
| January 22, 2009 5:09 AM
5250 session, AS/400, AS/400 import/export, CCSID, Change Physical File, CHGPF, Coded Character Set Identifier, DDS, iSeries Access for Windows, locale, Microsoft Excel, Physical File, QMQRY, Query Management Query, V5R3
Program Described Files?
Whats the use of program described file any example with file dds please?
Answer Question
| December 19, 2008 6:19 AM
Data Description Specifications, DDS, Program Described Files
Whats the use of program described file any example with file dds please?
Answer Question
| December 19, 2008 6:19 AM
Data Description Specifications, DDS, Program Described Files
Display system messages in window
I have a window created in DDS. It has a couple of valid function keys F1 and F2 say. When I press F5 system error message is displayed in the window but when I press any other key say “a”, “b” etc the error message “0005 = Invalid input field” is displayed outside the window. [...]
Answer Question
| November 20, 2008 9:20 AM
DDS, DDS Error Messages, DDS System Messages
I have a window created in DDS. It has a couple of valid function keys F1 and F2 say. When I press F5 system error message is displayed in the window but when I press any other key say “a”, “b” etc the error message “0005 = Invalid input field” is displayed outside the window. [...]
Answer Question
| November 20, 2008 9:20 AM
DDS, DDS Error Messages, DDS System Messages
Hide field which is present in DDS
I want to hide data of specific field which is present in DDS.The requirement is even in the runqry that field should be hidden….
Answer Question
| February 28, 2011 6:33 AM
Data Description Specifications, DDS, RUNQRY
I want to hide data of specific field which is present in DDS.The requirement is even in the runqry that field should be hidden….
Answer Question
| February 28, 2011 6:33 AM
Data Description Specifications, DDS, RUNQRY
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 to replace this [...]
Answer Question
| May 25, 2010 5:52 PM
5250 session, DDS, DSM, DSPF
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 to replace this [...]
Answer Question
| May 25, 2010 5:52 PM
5250 session, DDS, DSM, DSPF
Barcoding in RPG/400 DDS
How can I code an EAN13 barcode in RPG 400 DDS
Answer Question
| November 4, 2008 9:36 AM
Barcode, Data Description Specifications, DDS, EAN-13, RPG, RPG/400
How can I code an EAN13 barcode in RPG 400 DDS
Answer Question
| November 4, 2008 9:36 AM
Barcode, Data Description Specifications, DDS, EAN-13, RPG, RPG/400
SQL View on 1 AS/400 using data from another AS/400
We have 2 AS400 machines connected with a 1g pipe. I need to create a SQL view on one of the machines using data that is in DDS physical files on the other machine. How can I accomplish this?
Answer Question
| November 10, 2008 8:41 PM
AS/400 SQL View, Data Description Specifications, DDS, SQL/400
We have 2 AS400 machines connected with a 1g pipe. I need to create a SQL view on one of the machines using data that is in DDS physical files on the other machine. How can I accomplish this?
Answer Question
| November 10, 2008 8:41 PM
AS/400 SQL View, Data Description Specifications, DDS, SQL/400
Key on DDS Join Logical File
I have created a join logical file. On the second file there is a field that has to be a part of the key. But I get the following error message “Key field not from first file on JFILE keyword.” Is there way to get past this, or another way of doing this than using [...]
Answer Question
| June 10, 2011 1:51 PM
DDS, JFILE, Join logical files
I have created a join logical file. On the second file there is a field that has to be a part of the key. But I get the following error message “Key field not from first file on JFILE keyword.” Is there way to get past this, or another way of doing this than using [...]
Answer Question
| June 10, 2011 1:51 PM
DDS, JFILE, Join logical files
DDS Keywords for AS400 Windows screens
I have an Interactive Maintenance Screen program that calls a program to display an AS400 Windows. WhenI 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 prevented [...]
Answer Question
| March 11, 2011 1:56 PM
AS/400 errors, AS/400 Windows, DDS
I have an Interactive Maintenance Screen program that calls a program to display an AS400 Windows. WhenI 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 prevented [...]
Answer Question
| March 11, 2011 1:56 PM
AS/400 errors, AS/400 Windows, DDS
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?
Answer Question
| September 26, 2008 8:12 PM
AS/400 printing, DDS, MICR, Spool files
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?
Answer Question
| September 26, 2008 8:12 PM
AS/400 printing, DDS, MICR, Spool files
Positioning Cursor in Subfile
I can use the SFLRCDNBR(CURSOR) keyword to position the cursor on the correct subfile line that I want, but can I then get it to position on a particular field ? SFLRCDNBR(CURSOR) defaults to the first input capable field. DSPATR(PC) seems to override the SFLRCDNBR keyword; therefore I lose the cursor RRN.
Answer Question
| September 9, 2008 4:28 PM
DDS, DSPATR, RPGLE, SFLRCDNBR, Subfile
I can use the SFLRCDNBR(CURSOR) keyword to position the cursor on the correct subfile line that I want, but can I then get it to position on a particular field ? SFLRCDNBR(CURSOR) defaults to the first input capable field. DSPATR(PC) seems to override the SFLRCDNBR keyword; therefore I lose the cursor RRN.
Answer Question
| September 9, 2008 4:28 PM
DDS, DSPATR, RPGLE, SFLRCDNBR, Subfile
How to create Dynamic DDS for a PF(Physical File In AS/400)
How to create Dynamic DDS for a PF(Physical File In AS/400)
Answer Question
| September 8, 2008 8:50 AM
CREATE TABLE statement, DDS, Physical File
How to create Dynamic DDS for a PF(Physical File In AS/400)
Answer Question
| September 8, 2008 8:50 AM
CREATE TABLE statement, DDS, Physical File
