Compile Program for previous system level
You can backup this object with target release up to 2 back levevel release…and restore it to the Target Sys. Hassan ———————————————– For a SQL stored proc, no, you cannot save the object to any previous level. The save operation will result in a CPF3741 “not saved” message with a CPD6427 message pointing out the version [...]

View Answer   |  June 16, 2013  2:00 PM
AS/400 and SQL, IBM i, SQL procedure

Consuming Web Service from AS/400 Java
Here are a few threads in the topic that should help in your research: Simply consuming a web service in Java Consuming a web service using Java Consuming Web Services in Java using JAX-WS

View Answer   |  June 11, 2013  8:00 PM
AS/400, Java, WebServices

Changing user profiles in a CL program
use command wrkusrprf

View Answer   |  April 18, 2013  7:04 PM
CL Program, JOBD, QGPL

Reading files in RPG
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]

View Answer   |  May 17, 2013  9:24 AM
AS/400, RPG

DYMO LabelWriter 450 local printer troubles
The printer is local via USB. The OS is V6R1. The PC is Windows 7 professional. The printer is a thermal label printer that is not supported by IBM.  It was working and now that the PC is down we are unable to configure it.  I have been with this company for 3 months so [...]

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

Updating a physical file
In your F specs you are defineing the file as an Update file. The default then when youi read a record is to lock the record. You need to either execute an instruction to unlock the record or when you get the record with a READ or CHAIN you need to read it without the [...]

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

Journal Before/After image not in plain text
Here is a link to a CMD you can download http://www.tools400.de/English/Freeware/Utilities/utilities.html The command is EXPJRNE. It will allow you to select the Journal Entries you want and then put the data in the format of the original file that was journaled.

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

AS/400
Hi rajeshece, I know its possible with 3rd party software running on the IBM i (AS400) http://www.spacetec.co.uk/embedded-pdf-product-sheet.pdf details and downloads on the web site.

View Answer   |  April 2, 2013  11:23 AM
AS/400, PDF Files

DISPLAYING HELP TEXT OF A PROGRAM IN AN INTERNET EXPLORER WINDOW VIA RPGLE
Awesome. Thank you very much. Haven’t had hardly any exposure to doing things like this and i’m starting to get more involved with it.

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

About EVAL OPCODE
Using the Eval with %Dec BIF will work for this. You may want to do a TESTN first. What if you have other alpha characters uin the field? Is it possible to have a negative number in the field?  Is it always right justified or left justified? Depending on the answer to those questions will [...]

View Answer   |  March 21, 2013  11:01 AM
AS/400, AS/400 Fields

Retrieving the name of a file from object links
you can create a file for your program to process.   QFTPSRC is a regular source file (PF-SRC) that we store ftp scripts and logs you can use any source file you want (you will specify it in the OVRDBF commands).  In your CL you would: OVRDBF FILE(INPUT) TOFILE(QFTPSRC) MBR(GETLIST) OVRSCOPE(*CALLLVL) OVRDBF FILE(OUTPUT) TOFILE(QFTPSRC) MBR(GETLISTLOG)OVRSCOPE(*CALLLVL) OVRDBF FILE(LSOUTPUT) [...]

View Answer   |  March 20, 2013  11:55 AM
AS/400, CPYFRMIMPF, RPGLE

List of users who are members of a group profile
I found this answer on another web site by a person named “Dan Riehl:” where he says the      The command DSPAUTUSR(Display Authorized Users) has a parameter SEQ, that allows you to specify that you want to list out user profiles, within group profile.  Here’s the command, and the resulting output.   DSPAUTUSR SEQ(*GRPPRF)   [...]

View Answer   |  March 19, 2013  4:01 PM
AS/400, AS/400 User Groups

Add a new field in PF
Ravula is correct if hte file was created with DDS. Just change the DDS and do the CHGPF command. You will need to recreate the LFs and recompile programs using the files. (PF & LF)

View Answer   |  March 14, 2013  12:59 PM
Physical Files, RPG

External domain Vs Internal web server
Generally speaking, you should be able to use port forwarding or similar on your firewall to redirect web traffic to you internal server. There are some missing variables here so please provide us more info if you can.

View Answer   |  March 14, 2013  10:48 PM
External domain, Web Server

Adding values to second member of PF
Depends on what tool you will be using to add data to the second member. Can you give us more information as to what your plan is for doing the update. Are you use SQL, RPG/COBOL program, a data file utility, etc.?

View Answer   |  March 12, 2013  1:05 PM
RPG, RPG Program

Copying records
This question has been asked many times. To find more answers just do a search in ITKE. Some of the possiblilies are: FTP, DDMF, and SAVRST Best method depends on how often you need to do this, how large the files are, and how the machines are connected. I use DDM files for some process [...]

View Answer   |  March 12, 2013  11:19 AM
AS/400, AS/400 Records

About programming in AS/400
With a combination of %XLATE and %SUBST you can do this with one instruction.  

View Answer   |  March 11, 2013  4:15 AM
AS/400, AS/400 programming

Length of the entered value
SQL is much faster and has more options that Querry/400. Consider switching over to that. In eiter case, Tom is correct, use SubString to look at positions 11 to 15 of the field and compare that to blank.

View Answer   |  March 8, 2013  3:37 AM
AS/400, AS/400 Query

AS/400 as career option
Thanks for coming to ITKE. Your question haqs been asked many times at this web site. If you do a search you will find previous answers. Most common answers include: It is easier for you to know what is available in your specific location. What background & training do you have Are you willing to [...]

View Answer   |  March 7, 2013  9:17 AM
AS/400, AS/400 careers

Does anybody use FORMPLUS/400…kindly help me
Hello Tom, Here is an example Queue                 Library            Files      Writer                 Status BAKERSFLD      QGPL                0      BAKERSFLD       RLS   BAKERSFLDQ [...]

View Answer   |  March 7, 2013  12:22 AM
AS/400, AS/400 print errors