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

Question on Workfile
Hi, Please could any one help me getting answers to these Questions…. What is the diff. between Workfile and PF? How do u create a WorkFile in RPG or CL. What are the advantages of WorkFile over PF? Thanks Rama

Answer Question   |  March 26, 2007  6:01 AM
AS/400, DataCenter, DB2 Universal Database, RPG, RPGLE

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

Sorting out missing records.
Suppose i have 2 database files. one with 250 records and another with 350 records. There are some common records in both files. How to get the missing records?? Is this possible with CPYF command. If yes???Please explain me how to get this. or Is there any other to achieve this. Thanks and Regards Rama [...]

Answer Question   |  March 2, 2007  3:51 AM
DB2 Universal Database

Merging of files in AS400
What is the use of merging files in AS400? How do you do this?

Answer Question   |  February 23, 2010  5:22 AM
DB2 Universal Database, RPG, RPGLE

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

Comparing 2 files .CSV and getting the missing data using AS400.
I have 2 files of .CSV format. I need to compare them and capture the missing data into Excel sheet. How do i do this using AS400???

Answer Question   |  January 3, 2010  6:46 AM
DB2 Universal Database, RPG, RPGLE

Windows Scheduling iSeries Data Transfer
I have 4 data transfers created in IBMs data transfer from iSeries Server programs that I need to schedule using Windows Scheduler. I can make the transfers work by double clicking on the .dtf but when I try and schedule them I get the following errors: filename, directory name, or volume labe syntax is incorrect. [...]

Answer Question   |  June 18, 2010  3:40 PM
AS/400, DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, PC/Windows Connectivity, Security, Servers, Software, SQL, SQL Server, Tech support, Web development

SQL RRN Processing – by Key?
I’m putting together a job that needs to process a large masterfile in a very short period of time. To do this, I’m (sorta) cloning an existing SQLRPGLE application that runs multiple concurrent copies of a program…each processing a range of the file by RRN. The number of copies is dynamic, set by an input [...]

Answer Question   |  December 29, 2009  11:27 PM
DB2 Universal Database, 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

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

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

GENERATED KEYS…
I want to generate the next avalable key when INSERTing new rows. For an example… Create Table DBALIB/PARENT ( PARKEY BIGINT NOT NULL WITH DEFAULT PRIMARY KEY, PARNAME CHAR (30) NOT NULL WITH DEFAULT); INSERT INTO PARENT ( PARKEY, PARNAME) VALUES ( PARKEY(MAX) + 1), (<=====> just for illustration) ‘BOBBY’)

Answer Question   |  January 8, 2007  12:02 PM
DB2 Universal Database

using SQL statements…………..
Hi All, I have a problem. I have a string variable STR which contains SQL statements…… Like insert into lib1/fil1 select * from lib2/fil2 variable STR is changable…means I update the values of library and files at run time…in the variable STR.. I want to execute the SQL statements contained in string STR… How can [...]

Answer Question   |  December 23, 2010  9:52 AM
CLP, DB2 Universal Database, RPGLE

Front End Development for AS400
Hi We have an application in AS400 for which we are thinking of developing a GUI front end for the users. The users will then be able to run the processes from their PC. I have not worked on any such application and so, I do not know anything of that. I have done some [...]

Answer Question   |  January 7, 2007  10:39 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Email, PC/Windows Connectivity, Web development

Using two same files from different libraries in a RPGLE program.
Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime.So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve the [...]

Answer Question   |  December 28, 2009  4:15 AM
CLP, DB2 Universal Database, RPGLE

Is it possible to reorganize a very big transaction in one night?
I want to reorganize a very big transaction file in day end process and it cannot finish within 1 night. The problem is RGZPFM command lock that file ,so the day after , user cannot use that file because it is locked. Do you have any ideas to help me?

Answer Question   |  December 28, 2009  4:43 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security

iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB – real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files available [...]

Answer Question   |  October 14, 2010  10:35 AM
Access, ASP.NET, C, Database, DataCenter, DataManagement, DB2, DB2 Universal Database, Desktops, ESRI, HEAT, HTML, Management, Microsoft Office, Microsoft Windows, MySQL, Oracle, OS, PC/Windows Connectivity, Perl, PHP, Security, Servers, SQL Server, T-SQL, VB.NET, VBScript, Web site design & management, WebSphere Studio, XML

Commit utilization in SQL stored procedures
I need an explample of an SQL stored procedure running in an DB2 environment that uses commitment control. I don’t want use RPG. I would like to call it from QSQLSRC via LXISCH (AS400 scheduler) and update over 100,000 records in 20,000 row increments. Any Suggestions? Thanks!

Answer Question   |  December 28, 2009  1:08 PM
AS/400, DB2 Universal Database, RPG

SQL Logical Functions
Which is better to use and why? Also, which function is faster and why? Coalesce -or- IfNull

Answer Question   |  December 19, 2006  3:10 PM
Application development, AS/400, DB2 Universal Database