career advice
i am a fresh graduate in petroleum engineering and wish to purse a course in sap, I have no experince in IT order than basic computer knowledge.I want a sap course that is related to my field (petroleum Eng) and also make me a consultant.I was looking at MM in sap until recently I met [...]

Answer Question   |  September 18, 2006  6:16 PM
Basis, Career development, Certifications, CRM, Database, DB2, MySAP, Oracle, RPGLE, SAP, SAP careers, SQL, Training

Retrieve RPGLE source date
I am trying to retrieve the source date from an RPGLE program. I’m sure that there is an API but I haven’t been able to find one. The closest I came was QBNRMODI but it seems to require an actual module, not the bound program.

Answer Question   |  December 12, 2010  2:45 PM
Application development, DataCenter, RPGLE

FLOWCHART Generator for COBOL
Does anyone know of a product for generating a flowchart for existing COBOL code on the AS/400?

Answer Question   |  September 19, 2006  12:39 PM
AS/400

clear physical file member question
is it possible for me to only clear certain records of a physical while leaving certain records available? I have a file with thousands of records, but I only need the records starting with a certain date. How can I delete everything prior to the date that i need with out totally wiping out the [...]

Answer Question   |  December 17, 2009  9:25 AM
Application development, AS/400, Backup & recovery, CLP, DataCenter, RPG, Security

modifying a job description
I created a job description with several initial library lists. I now need to add a new library but I don’t want to add it to the bottom of the list. Is there a way to insert the library at the desired location? If not, I will have to retype the entire library list.

Answer Question   |  December 17, 2009  8:31 AM
AS/400, Security

Need Cobol 88 equivalent
I’m coding an RPG program and I need to find a technique that will allow me to evaluate the value of a variable to determine if it matches any one of a list or is within a range of given values. In Cobol I use 88 level entries in working storage. In other languages, SAS [...]

Answer Question   |  December 17, 2009  9:50 AM
RPG

CL Program to vary off Network Servers (*NWS)
Hello Can someone please help me with the following. We have an iSeries with an xSeries attached. The issue is that when we perform a scheduled IPL using the GO POWER menu, the xSeries is not being ended correctly prior to all other subsystems ending and then performing the IPL. What I am looking for [...]

Answer Question   |  December 12, 2010  12:13 AM
CLP

CPYFRMIMPF issue
Okay, here’s the deal. I’ve got a tab delimited file that used to load perfectly fine into file using the CPYFRMIMPF command, using the following options; CPYFRMIMPF FROMSTMF(‘/Directory of file/file.txt’) TOFILE(Library/file) MBROPT(*REPLACE) RCDDLM(*CRLF) STRDLM(*NONE) RMVBLANK(*NONE) FLDDLM(*TAB) RPLNULLVAL(*FLDDFT) After much research, I’m pretty sure that the issue lies in the changes to the CPYFRMIMPF command in [...]

Answer Question   |  December 17, 2009  3:48 PM
AS/400, DB2 Universal Database, RPG, RPGLE

FTP session
During an FTP session, prior to issue the GET command to receive files from a remote site to my local server, I need to clear my local directory. Is it possible to delete files from the local server ?? kind of a DEL or MDEL command that would be executed locally instead of the remote [...]

Answer Question   |  September 12, 2006  2:42 PM
Application development, AS/400, DataCenter, PC/Windows Connectivity

OSDB Connection to AS/400
I am trying to connect the UPS Worldship to our AS/400 (V2r3). The data will download into the 400 file just fine when run separately. I have added a trigger to the physical file so that when a record is written to the physical file, an RPG program is initiated that updated several other files. [...]

Answer Question   |  December 17, 2009  10:14 AM
AS/400, DB2 Universal Database

Laser Check printing of MICR codes
We are wanting to generate laser checks. Where can I find the DDS specs required to generate the MICR codes (fonts & special characters) that print at the bottom of the checks? We do not want to purchase any additional software for printing of MICR information.

Answer Question   |  September 7, 2006  2:55 PM
Application development, Printing, RPGLE

Data migration strategies-2
Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel files with all the relevant data [...]

Answer Question   |  September 11, 2006  4:02 AM
Application development, AS/400, Data analysis, DataCenter, DB2 Universal Database, Project management

Data migration strategies
Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel files with all the relevant data [...]

Answer Question   |  December 16, 2009  4:02 AM
Application development, AS/400, Data analysis, DataCenter, DB2 Universal Database, Project management

Disk Wipe of iSeries
I’m looking to find a way to clear all disks on a iseries 170 running V5R3. This clear must rewrite all data to biniar 0′s or 1′s. Thanks!

Answer Question   |  December 16, 2009  4:18 PM
AS/400, DataCenter

Use SysReq to get WRKJOB
I use to create a library – MYQSYS and load it with CRTDUPOBJ OBJ(WRKJOB) FROMLIB(QSYS) OBJTYPE(*CMD) TOLIB(MYQSYS) NEWOBJ(DSPJOB). I was then able to use the cmd CHGSYSLIBL LIB(MYQSYS)To put this library ahead of QSYS and when I used SYSREQ option 3 I got a WRKJOB instead of DSPJOB (and a cmd line). In my current [...]

Answer Question   |  December 15, 2009  11:00 AM
Application development, AS/400, CLP

OS Version
How can I determine what OS Version is installed on my system from a program? The OS version is not in the system values, RTVJOBA, or RTVNETA.

Answer Question   |  September 5, 2006  1:06 PM
Application development, AS/400, CLP, DataCenter

BRMS – *USRMLB – *MEDCLS question.
I have a problem using BRMS and a Tape Library defined as *USRMLD. I configured a *USRMLB and I defined 4 drives within this MLB. In my System Policy, I defined *MEDCLS as device to use. With V5R2, it was working when I was running 2 concurrent backup jobs from the same AS/400; the 1st [...]

Answer Question   |  September 29, 2006  5:10 AM
AS/400, Backup & recovery, DataCenter, IBM, Storage

RPGLE & Variable-length fields: How do I measure how much disk space is actually taken up by this type of field?
I defined a variable-length field. Do the first 2 bytes of the field signify how much disk space is actually taken up by this type of field? For this field, even if the first 2 bytes have a larger length than the actual number of non-blank characters in the field – in either case, when [...]

Answer Question   |  December 15, 2009  2:49 AM
AS/400, RPGLE

scheduling a job
I have a job that needs to run the 5th of each month. I’ve looked into JOBSCDE but I haven’t see where I could schedule the job thru that. Do you know of an easy way to make that occur??

Answer Question   |  December 15, 2009  2:33 PM
Application development, AS/400, DataCenter

Batch FTP Error “Unable to open file /readi/readicclst.csv to send data.”
I am getting error while doing batch FTP as “Unable to open file /readi/readicclst.csv to send data.”. Suprisingly if i run the same interactively it works. Not sure y ?

Answer Question   |  August 30, 2006  12:59 PM
AS/400