• Using Query/400 to create SQL-style GROUP BY

    Greetings and salutations, I'm trying to put together a query for one of my users to track sales numbers and it is starting to give me a headache. I've put together a query using Query/400 with a break at each invoice to sum the dollar amount for each one. The issue is that on many of our invoices,...

    Kyoojin0 pointsBadges:
  • Microsoft Office & AS/400 Database

    I am trying to bring data into Microsoft Access 2007 using ODBC. If a database has multiple members, how do you define/select the correct member in the ODBC definition? I have no problem getting the library list, and can see the files list but unable to select the member.

    Lshipley515 pointsBadges:
  • RSTLIB and Journaling

    I am doing a SAVLIB of our Production Data Libraries creating SaveFiles on our Production iSeries, then thru FTP, transferring the SaveFiles to our Development iSeries, then doing RSTLIBs. During the RSTLIBs I get a CPF7085 - Journal QSQJRN already exists and CPF3756 - JRN QSQJRN not restored. It...

    wpoulin2,480 pointsBadges:
  • Print Image File in iSeries

    Hi, I would like to ask for help to use the data type field GRAPHIC in iSeries. Can I save an image file into this field type? If so, how do I do this? I have tried but it always shows an error of character conversion not valid. Please help. Regards, Tony Tam

    Tonytam0 pointsBadges:
  • System i Navigator connection error to Central Management System.

    I am getting an error message in System i Navigator when I try to connect to Central Management System. "Unable to complete the connection to central system `system name`". I am trying to retreive the System Operator Messages. Also under Basic Operations - Messages click on the bottom panel on View...

    Chabsta85 pointsBadges:
  • User Space in iSeries

    Can someone explain what the object type *USRSPC is used for on the iSeries and what is the best approach for cleanup of these objects? Thanks, Bill

    wpoulin2,480 pointsBadges:
  • i5/OS Upgrade

    I realize how ludicrous this question must sound. However: I want to upgrade my IBM i5/OS from V5R2 to V5R3 (or straight to V5R4) and I don't know how to order a CD of the upgrade. (I don't want to download the upgrade) I do have software support. We bought our existing hardware via IBM Direct so I...

    Selectsoft65 pointsBadges:
  • Copy Spooled File to a Source Physical File Member

    How do I copy a spooled file listing into a member of a source physical file? I accidentally deleted the source member, but have a spooled copy taken via option 6.  I would like to convert the spooled file back into the deleted member.

    Paul10204215 pointsBadges:
  • I am trying to use RUNRMTCMD from my i5 to a Windows 2003 server running VMWare.

    I am trying to use RUNRMTCMD from my i5 to a Windows 2003 server running VMware. I have never used this command before and was wondering if anyone can provide steps as to what needs to be running/setup on each side? If anyone has any documentation that would be great. Thanks.

    Alison88380 pointsBadges:
  • What is difference between V5R3 and V5R4?

    Since we have migrated from I570 TO MMA MODEL. I would like to know the difference betweeb V5R3 & V5R4

    CARE70705 pointsBadges:
  • Where to store email addresses?

    We are looking for a place/table to store email addresses, they need to be associated with i5 User Profiles. They are going to be used in a Java Application. The SMTP System Alias Table seems to be an appropriate place, but I have been unable to determine where this info is stored. Does anyone know...

    wpoulin2,480 pointsBadges:
  • call php script from CL – slow

    Hello, I try to call a php-script on our 520. CHGVAR     VAR(&CMM) +                                                VALUE('/usr/local/Zend/Core/bin/php +                    /www/zendcore/htdocs/test.php') QSH       ...

    Jogisarge30 pointsBadges:
  • Is there a limit to the relative record number(RRN) for physical file on system i?

    Is there a limit to the relative record number(RRN) for a physical file on system i, we are on V5R4 version of OS400. If yes, what are the likely issues we would have to face?

    JohnsonMumbai1,160 pointsBadges:
  • Calling API

    Hi all, Does anyone knows how to call API program in interactive mode? How are the rules to call API? Let say I want to put CALL QEZSNDMG in WRKJOBSCDE, what do I have to put in the command, cause when I try CALL QEZSNDMG parm(''N' 'Y' ' ' 'Testing' 'User1'') its not working. It says that error...

    TG50 pointsBadges:
  • Database member Cross reference in Qsys? – Where’s it hidden?

    A number of useful objects are in Qsys these days. Items like QADBIFLD are very useful when you want a system wide search for a field. I've been looking for the equivalent for file members. Specifically, I want to search for all occurrences of a given file member name across the system's many...

    Yorkshireman5,580 pointsBadges:
  • Convert RTF to PDF on i5

    Is there application which convert RTF documents to PDF and is running on i5. RTF files are on IFS folder and there is thousands of files to convert.

    I5programmer5 pointsBadges:
  • Is the new WRKDBF out yet?

    Anyone heard if the efforts to recreate a WRKDBF utility have borne fruit yet? Once again I find myself needing a general purpose file view utility, and hover on the brink of writing something, for I saw somewhere that a new one was being put together.

    Yorkshireman5,580 pointsBadges:
  • IBM Bladecenters

    Are the IBM I5 Bladecenter H and the IBM I Bladecenter HS, the same hardware, and if so does anyone know if Exchange 2007 can successfully run on this platform.

    Robert Stewart1,810 pointsBadges:
  • Change date format

    I have a date field stored in the i5 as yymmdd that I would like to change to mmddyy when exported to Excel. If I just re-format the cell, Excel treats the number as a Julian date and mis-corrects the date. The other issue is that Excel drops the leading 0 so everything in this decade is...

    DanBubis75 pointsBadges:
  • Major differences between i5 vs i7

    I wanted to ask if there is a major difference between the i5 and i7. If there is a major difference then tell me what the differences are and which one should I prefer when buying a laptop. I also want to know which processor is preferred for which tasks. Dealing with Haswell here

    snipersnake3695 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following