Key list in AS/400
 I have defined 3 keyfields in my logical file and I’m using them in my program as keylist parameters. Is it possible to perform chain operation using first and third keyfield? If not can you please tell me the other alternative?

Answer Question   |  April 3, 2013  5:50 AM
AS/400, AS/400 logical file

iSeries SQL Cobol
In my COBOL SQL select statement that was previously running on V5R4, I was able to extract a date field defined with “date” as the data type. We are now on V7R1 and we get a data mapping error. No clue as to why? Any ideas? thanks

Answer Question   |  April 2, 2013  6:59 PM
COBOL, iSeries, SQL statement

DYMO LabelWriter 450 local printer troubles
We are no longer able to print to our label printer. The PC we were using had to be replaced. We need to know how to set up this printer so it will print addresses via USB connection. I downloaded and installed the correct drivers for the printer. I used printer model *WSCST to configure [...]

Answer Question   |  April 2, 2013  5:16 PM
AS/400, AS/400 printing, DYMO, DYMO LabelWriter, dymo labelwriter 450 Turbo, Print thermal labels

Updating a physical file
Suppose I have a RPGLE Program P1 And P2 and a physical file PF1 . P1 using PF1 in update mode and p2 also using Pf1 in update mode. When P1 calls P2, it throws an error saying file locked. What can be done. I need to update pf1 in both the progs.

Answer Question   |  April 2, 2013  2:59 PM
Physical File, RPGLE, RPGLE files

Journal Before/After image not in plain text
I have a journaled file that I need to review the before and after image of a field change. When I look at the field, the characters in both the before and after images are unreadable (strange characters, blocks, etc.). How do I view the journal image in plain text, or convert it to plain [...]

Answer Question   |  April 2, 2013  1:30 PM
IBM i, IBM i 7.1

webservice and iDB2 connections slow on startup
We have a web service running on a SQL server sending data to our I-Series using a DB2 connection. The first time the service is run to submit an order, there is a long delay before it is submitted. On repeated orders it much quicker. Is there something we can do to speed up the [...]

Answer Question   |  April 1, 2013  2:11 PM
AS 400, DB2 connectivity, i series, SQL Server

AS/400
I want to package all PDF files in to one PDF file. Same as ADOBE – packaging. Is it possible in AS/400?

Answer Question   |  April 1, 2013  11:23 AM
AS/400, PDF Files

Data missing in CPYTOIMPF
I am doing CPYTOIMPF FROMFILE(MIUOALLV1/LSJSEP) TOFILE(QTEMP/LOWA5P) + TOCCSID(*FILE) STMFCCSID(*PCASCII) + STRDLM(*DBLQUOTE) FLDDLM(‘;’) + DECPNT(*COMMA)) Where LSJSEP is a file with 50 fields , total length of the fields is arounf 1500 , LOWA5P is a file with only one field of length 12000. The copy works correct and I see all the data in the [...]

Answer Question   |  April 1, 2013  8:21 AM
AS/400, AS/400 commands, CPYTOIMPF

Sending Japanese characters from Websphere Message Broker to iSeries
We have a requirement to send data from WebSphere Message Broker to an iSeries via MQ. The message triggers a call to an RPGILE program which will process the message and write the data out to JD Edwards database files. The messages on the broker are encoded as CCSID 1208. The iSeries OS has a [...]

Answer Question   |  March 28, 2013  4:37 PM
CCSID, iSeries, WebSphere

Run system 7.1 on power 6 550
Hi, Please can anyone tell me if we can run 7.1 system on power 6 550. Thanks

Answer Question   |  March 28, 2013  9:19 AM
AS/400, AS/400 Upgrade

How to read from flat file
How to read from flat file For eg: The data in one flat file is like this D|EMPN0001_001_01|C55BFIT|.00|.00|GBP|Y|1.00|20030101|20130301|IT|||||LC|100 D|EMPN0002_001_01|C55BFIT|.00|.00|GBP|Y|1.00|20030101|20130301|ECE|||||LC|100 The data in another flat file is like this: D|EMPN0001|N||.048448|.048448|100.0000|0.0000|100.0000|77.7782|EMP02|CME02|LM D|EMPN0002|N||1.000000|1.000000|100.0000|0.0000|100.0000|35.8566|EMP02|CME02| D|EMPN0003|N||.025600|.025600|100.0000|0.0000|100.0000|100.0000|EMP02|CME02|L I want to read these two files and stores these values in a separate Physical files. Main purpose is that to compare the values [...]

Answer Question   |  March 28, 2013  5:49 AM
AS/400, as/400 files

Reset/CTRL in a Macro in AS/400
I’m trying to write a macro that fills in a list of items with a list of properties. My only problem is I cannot find a way to reset controls (if I look at my key bindings, left ctrl is bound to [reset/ctrl]) I have tried many combinations of a few available functions, nothing works [...]

Answer Question   |  March 27, 2013  3:50 PM
AS/400, AS/400 macros

Size of a save file in AS/400
Hi, I would like to know is there any way to find out the size of a save file in AS/400 in bytes.

Answer Question   |  March 27, 2013  3:34 PM
AS/400, as/400 files

What will be the port number using for Canon printers from AS/400
What will be the port no using for Canon Printers from AS/400?

Answer Question   |  March 27, 2013  12:26 PM
AS/400, Canon

Indicators in RPG
HI, I am a cobol400 developer and new to RPG and curious to know much about RPG… My question here is In what scenarios we use the below indicators 1.Overflow indicator 2.Record Identifying indicator 3.Control level indicator 4.Field level indicator 5.Resulting indicator Thanks in adv Anup

Answer Question   |  March 27, 2013  12:11 PM
AS400 RPGLE, RPG, RPG indicators

DISPLAYING HELP TEXT OF A PROGRAM IN AN INTERNET EXPLORER WINDOW VIA RPGLE
Hello all, I was wondering if anyone has had any experience in using Internet Explorer in conjunction with RPGLE programs. Now, I’m not looking to go out to any internet site, instead, my boss wants me to create something for our user community. While in an Interactive Program, if the user hits F1 for Help, [...]

Answer Question   |  March 27, 2013  11:40 AM
AS/400, Internet Explorer, PHP, RPGLE, techniques, TIPS, TRICKS

SFL
I have a SFL. In which I have a option selection field. I have used reverse image indicator for it. But when I insert a wrong value in that field, then the entire column is highlighted instead of the option selection field for that particular record. What should I do?

Answer Question   |  March 27, 2013  7:11 AM
RPG, RPGLE, SFL

IF loop
key1 chain file1 if %found(file1) elseif key1 chain file2 Can anyone let me know whether the above if loop is correct or not?

Answer Question   |  March 27, 2013  6:37 AM
AS/400, RPGLE

True type fonts – AS/400 v6r1
which directory do I have to place my true type fonts

Answer Question   |  March 25, 2013  4:41 PM
AS/400

Canon ImageRUNNER on iSeries printing to specific mailboxes
We have connected a Canon ImageRUNNER to our iSeries via the network.  I have created a Workstation Customization Object to send reports to a specific mailbox and can’t get the PJL code to work.  I know the system is recognizing the Workstation Customization Object because I can get it to switch drawers but I can’t [...]

Answer Question   |  March 25, 2013  4:07 PM
Canon ImageRUNNER, iSeries