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
If you have EAN Code-13 DDS sample for print a Barcode could you please send me that sample..? Thanks in advice
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 field, apparently any...
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 field, apparently any...
Describing files using Data Description Specifications (DDS)
Describing Files Using Data Description Specifications (DDS)'can u tell me what is the probleme IN PF
Describing Files Using Data Description Specifications (DDS)'can u tell me what is the probleme IN PF
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.
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.
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...
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...
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 these DB files...
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 these DB 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. How can i make it to...
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. How can i make it to...
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....
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....
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...
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...
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?
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?
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 a Join 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 a Join file?
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...
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...
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?
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?
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...
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...
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)
How to create Dynamic DDS for a PF(Physical File In AS/400)
AUTO INCREMENT
We created a File with an Auto Increment Field using MYSQL statements through PHP. I have no Idea how to do this using DDS statements or settings.
We created a File with an Auto Increment Field using MYSQL statements through PHP. I have no Idea how to do this using DDS statements or settings.
How to transfer source code from AS/400 to PC to CD.
What is the quickest way to transfer multiple RPG and DDS source code members from an AS/400 to a PC and then to a CD.
What is the quickest way to transfer multiple RPG and DDS source code members from an AS/400 to a PC and then to a CD.


