AS400 PRINTER FONTS
I have been asked to produce new printed output in the Helvetica style. I have looked high and low for the font codes to plug into the CRTPRTF cmd with no sucess. Where can I find a listing of these 2, 3 & 4 byte codes (ie 18, 82) We don’t have printed documentation on [...]
Answer Question
| April 1, 2007 2:00 PM
Application development, AS/400, DataCenter, Printing, RPG, RPGLE
I have been asked to produce new printed output in the Helvetica style. I have looked high and low for the font codes to plug into the CRTPRTF cmd with no sucess. Where can I find a listing of these 2, 3 & 4 byte codes (ie 18, 82) We don’t have printed documentation on [...]
Answer Question
| April 1, 2007 2:00 PM
Application development, AS/400, DataCenter, Printing, RPG, RPGLE
Problems eliminating HEX 41 character.
I have a number of files on my DB2/400 database that have spaces with a Hex code of 41 instead of 40. This causes a problem when FTP’ing to a PC for integration with a barcode labeling application. Does anyone know how I can change this character to ANYTHING other than Space HEX 41 !! [...]
Answer Question
| January 5, 2010 9:03 AM
Application development, AS/400, DB2 Universal Database, RPG, RPGLE
I have a number of files on my DB2/400 database that have spaces with a Hex code of 41 instead of 40. This causes a problem when FTP’ing to a PC for integration with a barcode labeling application. Does anyone know how I can change this character to ANYTHING other than Space HEX 41 !! [...]
Answer Question
| January 5, 2010 9:03 AM
Application development, AS/400, DB2 Universal Database, RPG, RPGLE
Subfile not displaying properly
I am having a problem with my subfile not displaying properly. I my application, I have two scrollable subfiles displayed. The user can select several vendors and then display a list of checks sent to that vendor in a sequential manor (meaning if the user presses enter, the next vendor selected?s checks are displayed). This [...]
Answer Question
| March 19, 2007 3:18 PM
Application development
I am having a problem with my subfile not displaying properly. I my application, I have two scrollable subfiles displayed. The user can select several vendors and then display a list of checks sent to that vendor in a sequential manor (meaning if the user presses enter, the next vendor selected?s checks are displayed). This [...]
Answer Question
| March 19, 2007 3:18 PM
Application development
Trying to publish a Webfacing Project
Using WebSphere Development Studio I’ve created a WebFacing project converted an existing application on our iSeries to a WebFaced application, but i can only access the WebFaced application from my PC. How publish the application to a web server so that other users can access it. I tried exporting the project to a directory on [...]
Answer Question
| March 16, 2007 11:48 AM
Application development, AS/400, DataCenter, PC/Windows Connectivity, RPG, RPGLE, Web development
Using WebSphere Development Studio I’ve created a WebFacing project converted an existing application on our iSeries to a WebFaced application, but i can only access the WebFaced application from my PC. How publish the application to a web server so that other users can access it. I tried exporting the project to a directory on [...]
Answer Question
| March 16, 2007 11:48 AM
Application development, AS/400, DataCenter, PC/Windows Connectivity, RPG, RPGLE, Web development
Sorting out missing out
I have 2 files. One having 1000 records and the other 1350. I need to sort out the missing records and place them in an excel sheet. Programmatically how to acgieve this???
Answer Question
| March 19, 2007 1:14 AM
Application development, DB2 Universal Database, RPG
I have 2 files. One having 1000 records and the other 1350. I need to sort out the missing records and place them in an excel sheet. Programmatically how to acgieve this???
Answer Question
| March 19, 2007 1:14 AM
Application development, DB2 Universal Database, RPG
CL code to work on a spoolfile
Hi, I wish to create a database file from a spoolfile. I know how to do this using cpysplf. I don’t want the user to have to track down and enter the parameters for this command because, it will always be the same printfile and user. The only variable parameter will be the spoolfile number. [...]
Answer Question
| January 3, 2010 7:25 AM
Application development, AS/400, CLP
Hi, I wish to create a database file from a spoolfile. I know how to do this using cpysplf. I don’t want the user to have to track down and enter the parameters for this command because, it will always be the same printfile and user. The only variable parameter will be the spoolfile number. [...]
Answer Question
| January 3, 2010 7:25 AM
Application development, AS/400, CLP
AS400 disk initialize info
Hi All, I am trying to find printable results or logs for a disk that has been initialized successfully by using SST or DST. The procedure normally completes with a single line of “COMLETED SUCCESSFULLY” I need more infomation like model, serial no, sectors or some proof that this particular disk has passed for the [...]
Answer Question
| January 4, 2010 5:00 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, Printing, RPG, RPGLE, Security
Hi All, I am trying to find printable results or logs for a disk that has been initialized successfully by using SST or DST. The procedure normally completes with a single line of “COMLETED SUCCESSFULLY” I need more infomation like model, serial no, sectors or some proof that this particular disk has passed for the [...]
Answer Question
| January 4, 2010 5:00 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, Printing, RPG, RPGLE, Security
Count days between 2 dates
I wish to, using query count the number of days between 2 dates, the dates are in YYYMMDD format but I presume I’ll need to convert the dates to Julian first to allow the caculation. Can anyone help?
Answer Question
| January 4, 2010 8:25 AM
Application development, AS/400, RPG
I wish to, using query count the number of days between 2 dates, the dates are in YYYMMDD format but I presume I’ll need to convert the dates to Julian first to allow the caculation. Can anyone help?
Answer Question
| January 4, 2010 8:25 AM
Application development, AS/400, RPG
Programming with arrays
Answer Updated
Answer Question
| January 2, 2010 2:42 PM
Application development, RPG
Answer Updated
Answer Question
| January 2, 2010 2:42 PM
Application development, RPG
problems with infsr(*PSSR) and callp
I have a program in which I specify infsr(*PSSR) on a file. This program uses the callp command to call another program which in turn uses the callp to call another program. In this third program, if an error occurs on an IO command on a file that is different than the one upon which [...]
Answer Question
| January 1, 2010 4:56 PM
Application development, RPGLE
I have a program in which I specify infsr(*PSSR) on a file. This program uses the callp command to call another program which in turn uses the callp to call another program. In this third program, if an error occurs on an IO command on a file that is different than the one upon which [...]
Answer Question
| January 1, 2010 4:56 PM
Application development, RPGLE
QSPOLJBQ – API
I am using QSPOLJBQ (open list of job queues) API to generate a list of all job queues on the system. Need help to use this API.. All I get is “Receiver value too small to hold result.” (MCH1210). But the help is not enough to resolve. I tried changing the parameters in many ways. [...]
Answer Question
| December 29, 2009 2:02 AM
Application development, AS/400, DataCenter, RPGLE, Web development
I am using QSPOLJBQ (open list of job queues) API to generate a list of all job queues on the system. Need help to use this API.. All I get is “Receiver value too small to hold result.” (MCH1210). But the help is not enough to resolve. I tried changing the parameters in many ways. [...]
Answer Question
| December 29, 2009 2:02 AM
Application development, AS/400, DataCenter, RPGLE, Web development
Deleted files
WE have a PF file that got deleted, we don’t do job logs unlwss there is a problem…is there anyway to tell who deleted it? Also for in the future, what is the best way to be able to track deletions? We have 9 people that have all obj authority. Also is it possible that [...]
Answer Question
| October 24, 2007 8:44 AM
Application development, AS/400, Backup & recovery, DataCenter, RPGLE
WE have a PF file that got deleted, we don’t do job logs unlwss there is a problem…is there anyway to tell who deleted it? Also for in the future, what is the best way to be able to track deletions? We have 9 people that have all obj authority. Also is it possible that [...]
Answer Question
| October 24, 2007 8:44 AM
Application development, AS/400, Backup & recovery, DataCenter, RPGLE
How can I find on which files a program has been attached as an external trigger?
I have a “generic” rpgle program that can be attached to any physical file as a trigger. And so it has been, many times.. Is there a utility that I can use to find exactly what files have this program attached as a trigger? Or some table where I can look? Thanks! Kevin
Answer Question
| January 24, 2007 5:56 PM
Application development, AS/400, DB2 Universal Database, RPGLE
I have a “generic” rpgle program that can be attached to any physical file as a trigger. And so it has been, many times.. Is there a utility that I can use to find exactly what files have this program attached as a trigger? Or some table where I can look? Thanks! Kevin
Answer Question
| January 24, 2007 5:56 PM
Application development, AS/400, DB2 Universal Database, RPGLE
SQL
I have a beginner SQL question. I’m new to using SQL on the iseries. I want to get the system date and compare it to a date in a file and depending if its 30 days past delete that record. I can get most of it but the system date is driving me nuts. How [...]
Answer Question
| June 20, 2008 4:53 PM
Application development, AS/400, CLP, RPG, RPGLE, SQL Server
I have a beginner SQL question. I’m new to using SQL on the iseries. I want to get the system date and compare it to a date in a file and depending if its 30 days past delete that record. I can get most of it but the system date is driving me nuts. How [...]
Answer Question
| June 20, 2008 4:53 PM
Application development, AS/400, CLP, RPG, RPGLE, SQL Server
Emailing from iSeries with multiple attachments
I am looking for a way to send an email from the iSeries with multiple attachements. The attachments are documents (.doc, .pdf, etc.) in the IFS not spool files. SNDDST only allows one attachment and most of the other options I have seen involve spool files. Does anyone know how this can be done? Thanks [...]
Answer Question
| January 22, 2007 11:15 AM
Application development, AS/400, CLP, Email
I am looking for a way to send an email from the iSeries with multiple attachements. The attachments are documents (.doc, .pdf, etc.) in the IFS not spool files. SNDDST only allows one attachment and most of the other options I have seen involve spool files. Does anyone know how this can be done? Thanks [...]
Answer Question
| January 22, 2007 11:15 AM
Application development, AS/400, CLP, Email
FTP from iSeries to PC
I have installed a Cerberus FTP Server on the PC and I need to FTP a flat file FROM the iSeries TO the PC. However, when I enter the PUT statement it returns with : 227 Entering Passive Mode (213,210,55,130,4,22) 425 Unable to open the data connection Any idea where I am going wrong please?
Answer Question
| January 18, 2007 10:38 AM
Application development, AS/400, PC/Windows Connectivity
I have installed a Cerberus FTP Server on the PC and I need to FTP a flat file FROM the iSeries TO the PC. However, when I enter the PUT statement it returns with : 227 Entering Passive Mode (213,210,55,130,4,22) 425 Unable to open the data connection Any idea where I am going wrong please?
Answer Question
| January 18, 2007 10:38 AM
Application development, AS/400, PC/Windows Connectivity
Reg Data extraction from one environment to another
Hi Consider i have testing library and development library in my library list. Say for eg, given a shipment ID i need to copy all the relevant data from testing enviroment to development environment. Since the file objects reside in testing and dev environment how will i be able to fetch data from particular environment. [...]
Answer Question
| January 17, 2007 4:26 AM
Application development, AS/400, CLP, RPGLE
Hi Consider i have testing library and development library in my library list. Say for eg, given a shipment ID i need to copy all the relevant data from testing enviroment to development environment. Since the file objects reside in testing and dev environment how will i be able to fetch data from particular environment. [...]
Answer Question
| January 17, 2007 4:26 AM
Application development, AS/400, CLP, RPGLE
FTP from iSeries DB2 to iSeries AIX (Oracle)
I’m taking a FILE and using CPYTOIMPF to either create the flat file pipe delimited to another DB2 File or directly to the IFS as *PCASCII. Using iSeriesNavigator, I have no problem looking at the IFS. No issue with iSeriesNavigator and looking at FILE either. Using FTP, <namefmt 1>, <mode binary>, I’m able to send [...]
Answer Question
| January 1, 2010 3:08 PM
Application development, AS/400, DB2 Universal Database
I’m taking a FILE and using CPYTOIMPF to either create the flat file pipe delimited to another DB2 File or directly to the IFS as *PCASCII. Using iSeriesNavigator, I have no problem looking at the IFS. No issue with iSeriesNavigator and looking at FILE either. Using FTP, <namefmt 1>, <mode binary>, I’m able to send [...]
Answer Question
| January 1, 2010 3:08 PM
Application development, AS/400, DB2 Universal Database
AS400 intreface with other platforms
Can anybody tell me how to interface As/400 with other platforms say windows or linux for example
Answer Question
| December 29, 2009 1:30 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, Printing, Security, Web development
Can anybody tell me how to interface As/400 with other platforms say windows or linux for example
Answer Question
| December 29, 2009 1:30 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, Printing, Security, Web development
ADDSVRAUTE & DDM files
I am writing an Order Entry application that requires use of file on a remote system, which I will access via DDM. The problem is that we have hundreds of order entry clerks and turn around is great. I do not want to open a can of worms by having to create and maintain remote [...]
Answer Question
| December 29, 2009 4:17 PM
Application development, AS/400
I am writing an Order Entry application that requires use of file on a remote system, which I will access via DDM. The problem is that we have hundreds of order entry clerks and turn around is great. I do not want to open a can of worms by having to create and maintain remote [...]
Answer Question
| December 29, 2009 4:17 PM
Application development, AS/400
