DB2 Universal Database

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 !! Potentially...

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

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???

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...

Merging of files in AS400

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

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...

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???

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...

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...

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

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>,...

AS400 intreface with other platforms

Can anybody tell me how to interface As/400 with other platforms say windows or linux for example

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...

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...

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 initial research on that and...

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...

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?

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...

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!

SQL Logical Functions

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