Using system() function in RPG IV
Could someone please tell why this doesn't work? Path = '\SOMENAME. I get a CPF006 ('Errors occurred in command.') The message in the joblog is 'String '\XMLDATA\A' contains a character that is not valid.' D path S 63A Varying D cpfmsg S ...
View Answer
| Jul 2 2008 6:08 PM GMT
| asked by
GLinds01
AS/400, RPG IV, AS/400 errors
XML-INTO
I'm trying to use XML-INTO with %XML to convert an XML document into a DB2 database file. The XML file has four levels of data with elements from each level that need to be used for the database record. Naturally, the relationships between the level are important, too. The levels are Header...
View Answer
| Jun 26 2008 4:02 PM GMT
| asked by
GLinds01
XML, RPG IV, DB2
RPQSQL / SQLRPG
Any body please helpWanted to know the advantage and disadvantage using RPGSQL / SQLRPGI've heard that this is the new one its not only RPG but become one with SQL.Thanks in advance
View Answer
| Jun 25 2008 0:31 AM GMT
| asked by
TG
RPG, RPG ILE, RPG IV
Automated file transfer from AS400 to Word?
A search400.com reader wrote in with this question:I need to take a spool file (say a Collection Letter) generated from RPGIV. I can copy this spool file to a physical file if needed.I want to automatically import or send this file to Microsoft Word for editing purposes. I have used the 'ADD-INs'...
View Answer
| Jun 10 2008 5:39 PM GMT
| asked by
AS400 - Ask the Expert
AS/400, Spool files, Microsoft Excel
RPG %SCAN Question
I am unable to get all the scanned records for a string in a file. For example, my file itemmast has 1000 records in it. When I use Query 400 and search for 'cable' I get 50 records with the word cable in various positions of a 30 character field. When I use the statement "x = %scan (xcust_pn :...
View Answer
| Jun 5 2008 4:18 PM GMT
| asked by
DLM2007
RPG IV, RPG, AS/400 Query
Printing Logos
We are eliminating some preprinted forms and creating the forms ourselves. The problem is these preprinted forms have our company logo on it. How can I add a logo to a report created on the AS400 in RPGLE?
View Answer
| Jun 3 2008 5:09 PM GMT
| asked by
GHENDER
RPG, RPG/400, RPG III
Writing Information to the JobLog
I've seen a number of snippets here and there on the internet regarding the ability to write specific information to the job log in order to figure out exact problems, based on the conditions placed within. I've seen reference being made to some API, but have been unable to actually find useful...
View Answer
| Apr 25 2008 2:11 PM GMT
| asked by
ShatteredRaven77
RPGLE, RPG IV, joblog
How to FTP a file from PC to my personal library?
How to FTP a file from PC to my personal library?
View Answer
| Apr 1 2008 11:14 AM GMT
| asked by
Pradeepr
RPGLE, RPG ILE, RPG IV
How to read records in all of the members of a single pf?
I have a file name file1. it has 30 members. i have a input value from a display file and i need to check it in all the members. If it match i write the record in file2. How to read records in all members of a single pf?
View Answer
| Mar 27 2008 7:13 AM GMT
| asked by
Pradeepr
AS/400, RPGLE, RPG IV
Advanced Trigger question for *insert *before to allow update of field value
I need to update a field in a record being written prior to it being written. I want to do it with a trigger because many programs write and update this file. I have tried several things and the closest I have gotten is to do a *before *insert where I can see the values of the fields in the after...
View Answer
| Nov 28 2007 7:02 PM GMT
| asked by
Dcdc
RPG, RPG ILE, RPGLE
