Convert a Cobol/400 File Spec to a RPG/400 DDS
How can easily convert a Cobol/400 File Spec to a RPG/400 DDS Spec?
How can easily convert a Cobol/400 File Spec to a RPG/400 DDS Spec?
Query Xref to file
The other day I added a field to the DDS of a file. I recompiled all of the RPG programs and display files that use the physical file. But I got burned when I found that I neglected to include all of the queries that used the file. Is there a way to query all of the query definitions to find if my...
The other day I added a field to the DDS of a file. I recompiled all of the RPG programs and display files that use the physical file. But I got burned when I found that I neglected to include all of the queries that used the file. Is there a way to query all of the query definitions to find if my...
Print a Barcode on a Microline 421 Printer (a dot matrix)
I have a client that uses 10 Mircroline 421 printers (a dot matrix) for purchase order, invoice, pick ticket, etc. They would like to print a barcode on them. The printer does have the capability to print barcodes. The printer is set to IBM emulation. I would like to use the barcode keyword in DDS...
I have a client that uses 10 Mircroline 421 printers (a dot matrix) for purchase order, invoice, pick ticket, etc. They would like to print a barcode on them. The printer does have the capability to print barcodes. The printer is set to IBM emulation. I would like to use the barcode keyword in DDS...
Barcode scanning
We develop and use a lot of barcode scanning and reading applications. Some of the portable scanners in the warehouse allow the user to establish a session to the AS400 via a wireless bridge. Once signed on, the user is presented with the scanning application. Due to the fact that their scanners...
We develop and use a lot of barcode scanning and reading applications. Some of the portable scanners in the warehouse allow the user to establish a session to the AS400 via a wireless bridge. Once signed on, the user is presented with the scanning application. Due to the fact that their scanners...
CPYTOIMPF - Physical file to IFS, get imbedded blanks
I have a physical file with the following fields. (field - attribute - sample content) FILL01 - 1A - blank KEY - 8A - AAPCTINV LENGTH - 2S 0 - 60 TEXT - 60 A - 8028038 When looking at the file using DSPPFM, the info = AAPCTINV608028038 Note, it has 1 space at the begining Using the...
I have a physical file with the following fields. (field - attribute - sample content) FILL01 - 1A - blank KEY - 8A - AAPCTINV LENGTH - 2S 0 - 60 TEXT - 60 A - 8028038 When looking at the file using DSPPFM, the info = AAPCTINV608028038 Note, it has 1 space at the begining Using the...
Copy DDS defined file to .txt file
I am trying to copy a large, 1.4 mil records, 535 byte records, from an old DDS defined file on the iSeries to a .txt file. I have used FTP and CPYTOIMPF using every combination of setting I can think of. Every time it translates the packed numeric fields correctly but creates garbage for the alpha...
I am trying to copy a large, 1.4 mil records, 535 byte records, from an old DDS defined file on the iSeries to a .txt file. I have used FTP and CPYTOIMPF using every combination of setting I can think of. Every time it translates the packed numeric fields correctly but creates garbage for the alpha...
ALTPAGEUP/DOWN CF Indicator Question
I have (in DSPF) ALTPAGEUP/ALTPAGEDOWN as CF04 and CF05. Are you not able to use CF04 or CF05 elsewhere? example: screen1 subfile...F4/F5 = PageUp/Down screen2 F4=prompt F5=deliver the program doesn't "seem" to recognize the F5 (or F4) on Screen2. There is another program that does this...
I have (in DSPF) ALTPAGEUP/ALTPAGEDOWN as CF04 and CF05. Are you not able to use CF04 or CF05 elsewhere? example: screen1 subfile...F4/F5 = PageUp/Down screen2 F4=prompt F5=deliver the program doesn't "seem" to recognize the F5 (or F4) on Screen2. There is another program that does this...
field description-is there a way to run a command over a library to generate an outfile
State audit being performed over all our tables in order to associate level of restriction to some data. I've been tasked to provide a report of all the fields defined in our tables - is there a way to run a command over a library to generate an outfile. Something like DSPPFD but need it to go...
State audit being performed over all our tables in order to associate level of restriction to some data. I've been tasked to provide a report of all the fields defined in our tables - is there a way to run a command over a library to generate an outfile. Something like DSPPFD but need it to go...
Physical file Creation
Can any1 tell me the whole steps in creating a physical file(DDS) . I am new to AS/400
Can any1 tell me the whole steps in creating a physical file(DDS) . I am new to AS/400
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?
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?
Copy Stream File
Hello, I have a stream file that I have copied to the iSeries. I would now like to copy this file to a physical file defined using DDS as a file with one field of 1024. The records in the stream file are delimited with a tilde, not a CR, LF, or any combination of these. Any suggestions how to...
Hello, I have a stream file that I have copied to the iSeries. I would now like to copy this file to a physical file defined using DDS as a file with one field of 1024. The records in the stream file are delimited with a tilde, not a CR, LF, or any combination of these. Any suggestions how to...
Iseries print position problem
I am having difficulty positioning output in the same position on a page across different printers using line/column positioning in DDS. If I use the position keyword in the same document across these printers then the output is positioned on the page in exactly the same spot each time. I want to...
I am having difficulty positioning output in the same position on a page across different printers using line/column positioning in DDS. If I use the position keyword in the same document across these printers then the output is positioned on the page in exactly the same spot each time. I want to...
Code for printing on IBM 6400 printers
My company uses 6400 printers to print reports with bar codes and boxes. Currently the code that is used is what is recommended by Printronix - IGP. This code is difficult to change and hard to read. There are over 100 6400 printers in operation and many different versions of firm ware as well...
My company uses 6400 printers to print reports with bar codes and boxes. Currently the code that is used is what is recommended by Printronix - IGP. This code is difficult to change and hard to read. There are over 100 6400 printers in operation and many different versions of firm ware as well...


