Importing a .dbf file into IBM DB2 table
I have a .dbf database file I want to upload to our IBM i5 and into a DB2 table. Is there an easy way to do this or am I going to need to convert the .dbf file into a .csv file? I’ve tried using the CPYFRMIMPF command, but have had no such luck. Any [...]

Answer Question   |  July 19, 2012  3:02 PM
AS/400, CPYFRMIMPF, DB2, DBF file, i5, V5R4

how to add make available an exit format in a exit point?
Hi, how can I make available an extra exit format for an exit point, by example the QIBM_QSY_CERT_APPS has the exit format CERT0100, but also allow the CATR0100 format , how can I add the CATR0100 for this exit point ?

Answer Question   |  July 4, 2012  8:15 PM
exit format, exit point, iSeries, V5R4

Create one program with a C and CPP modules
How can I create program with mixed modules? is it possible ? I create my modules in this way: // int function1(parms)  crtcmod ( LIB/MOD )  ... //int mehtod2( ) crtcppmod ( LIB/MOD2 )   ... crtpgm ( LIB/CPPPGM ) MODULES ( LIB/MOD LIB/MOD2 )  fails with the message  "Definition not found for symbol function1___" [...]

Answer Question   |  April 25, 2012  4:11 PM
AS/400, V5R4

Backup in LCKW
Hi folks, i have a backup in a LCKW status. I can’t find what is locking the backu. I’m using BRMS. I need ideas, please. Thanks in advance.

Answer Question   |  April 26, 2012  12:35 PM
BRMS, iSeries, V5R4

User Profile Creation Date
How can I get the User Profile Creation Date for all my user profiles in one report?   I would be nice if this was in the same report as my DSPUSRPRF report which has all the other parameters I need, but Audit want to see when they were created . . . Don’t you [...]

Answer Question   |  March 17, 2012  2:53 PM
AS/400 user profiles, V5R4

User profile own objects not in a library
I have several termed user’s whose user profiles contain no objects (WRKUSRPRF & Opt 12-Work With Objects Owned By User), but when I go to delete them (using Opt 4 – delete) I received the error (across the bottom of my screen) “User Profile (name) Owns Objects not In A Library”. The additional information in [...]

Answer Question   |  March 17, 2012  8:28 PM
RCLSTG, V5R4

Open list of Objects using QGYOLOBJ API
Hi, I’m trying to use the QGYOLOBJ API to get all the objects from one type but always gave me invalid results into the List Information str:   struct SelectionControl {     Qgy_Olobj_SelControl_t selControl ;     char status; }; struct Receiver {     Qgy_Olobj_RecVar_t receiver ;     Qgy_Olobj_KeyData_t keys ; } [...]

Answer Question   |  March 19, 2012  4:28 PM
API, AS/400, ILE c, iSeries, V5R4

SQL command Leaving File open
Our VB.net person is using OLE DB Provider IBMDA400 to connect to our ISeries (AS/400). He uses a Table adapter to do Inserts, Deletes, etc… to files on the ISeries (AS/400). For some reason the QZDASOINIT job that is used keeps the files he works with open, doesn’t close them. Can he close them or [...]

Answer Question   |  March 19, 2012  6:04 PM
AS/400, V5R4

Get the ASPs with QYASPOL API from c++
I trying to get the ASP with the QYASPOL API from c++ but the next source code only  returns data in the info variable , the receiver looks empty :S , could you point me in the right direction ?  #include <QYASPOL.h>  #include <stdio.h>  #include <qusec.h>  #include <QGYGTLE.h>   ...    typedef struct   {  YASP_Filter_t filterByNumber ;  [...]

Answer Question   |  March 19, 2012  12:49 AM
API, ASP, QYASPOL, V5R4

Work with PTF Groups showing 2 Cumulative PTF Packages.
Hi, When i displaying Work with PTF groups it is showing 2 Cumulative PTF Packages C1137540(PTF Group SF99540) and C7016530(PTF Group SF99530). Both are showing installed. Do i need to get rid of one. Also in WRKPTFGRP i have many PTF Groups with status NOT APPLICABLE. Is it safe to get rid of them and if yes how can i [...]

Answer Question   |  March 19, 2012  9:03 AM
PTF, PTF Group Installation, V5R4

Full system backup in AS400
Can you please let me know how full system backup in AS400 should be performed?

Answer Question   |  February 8, 2012  9:29 AM
AS/400 backup, AS400 backups, System backups, V5R4

Trial version of Websphere for iSeries
hi guys, anybody knows where i can donload websphere server aplication 6.1 for system i? I just need a trial version. Tanx

Answer Question   |  October 25, 2011  1:34 PM
iSeries, V5R4, WebSphere, WebSphere Application Server

RPGIV Coding Approach for 1 billion records
I have 1billion records in a PF.Key filed  is Date.I want to generate a report based on Key field.Which approach will be best for me (I mean shall i go with OVRDBF or any other approach)Please suggest.(RPGIV-Free Format-V5R4)

Answer Question   |  March 31, 2012  7:21 AM
OVRDBF, RPG Code, RPGIV, V5R4

Typographic/proportionally spaced fonts
I would like to use a proptionally spaced font for a column report, my first go was a mess, is there someting that I should be doing to ease the tidying up process?  Or is it a case of trial and error?

Answer Question   |  March 31, 2012  4:14 PM
iSeries, iSeries administration, V5R4

Decimal Data Error in V5R4
How can we see Decimal Data Error just by looking the code.Without compiling?(V5R4-I’m using Free Format coding)

Answer Question   |  March 31, 2012  2:23 PM
Decimal Data Error, Free Format, Free Format RPG, V5R4

RPG internally described output (printer) file to DDS
How do i convert an old RPG internally described output (printer) file to an externally described DDS printer file?

Answer Question   |  March 31, 2012  4:20 PM
DDS, iSeries printing, RPG, V5R4

What is the best way of printing to two drawers within the same print job?
I need to print client 1, page 1 from drawer 1, client 1, pages 2-10 from drawer 2 , then cilent 2, page 1 from drawer 1, client 2,pages 2-10 from drawer 2 etc. I am doing this from an ILE program with an externally defined print file. I have tried executing an override printer [...]

Answer Question   |  March 31, 2012  2:49 PM
*IBMSNMPDRV, ILE Program, iSeries printing, V5R4

Trouble printing from remote outq
I setup a remote outq to a HP3500 printer. But it will not print any report I sent. It only prints the user and host name on the upper left corner of the paper

Answer Question   |  March 31, 2012  5:34 PM
iSeries printing, OUTQ, Remote Printing, V5R4

Drawer selection for Lexmark T652DN
We are running V5R4 in our iSeries & we have AFP installed.  We want to automatically print to our new Lexmark T652DN from drawer 3 (plain A4), leaving drawers 1 & 2 free for pre-printed forms. The Printer has an IPDS card installed.  How do we go about achieving this?

Answer Question   |  March 31, 2012  9:12 AM
AFP, IPDS printer, iSeries, T652, V5R4

Speed of a V5R4 processor
how to find the processor speed of an V5R4 system

Answer Question   |  March 31, 2012  10:27 AM
iSeries administration, Processors, V5R4