• STRQMQRY not sum up the right total

    I try to use STRQMQRY to pass in a variable to run a query. It works great except the query suppose to have a grand total, for some reason, it doesn't add up right. When i run the query manually without using STRQMQRY, it works fine. Anyone know what do I have to do here? Thanks.

    Heidiltl0 pointsBadges:
  • User Profiles

    Is there an option on a menu somewhere to find when the last time a user profile was changed and by whom? Or is there a file that can be queried to find this data?

    Debjam0 pointsBadges:
  • Sending Email Attachement in PDF format using SNDDST

    I need instructions on how to send email attachement in PDF format from iSeries. I tried to copy a spool to the shared folder, change extension to .DPF and email it using SNDDST; When I received the email it looks like I received an attachhment with pdf format. But file cannot be opened. Please...

    Rodesa0 pointsBadges:
  • ASP

    I have AS/400 9406-270 with expansion unit 12 H.D.(4318)connected to 2763 IBM PCI RAID Disk Unit Controller assigned as ASP1.(175GB with ASP %91) I added six 4318 H.D.(to decrease the percentage)and connected them as parity to second 2763 IBM PCI RAID Disk Unit Controller and I assigned them as...

    YEMEN50 pointsBadges:
  • iseries backup solution,

    In a data center with unix boxes and a partitioned iseries. Is there a solution to succeffuly backup these mixed platforms or does the iseries require it's own solution apart from the Unix boxes ?

    Fuzz77915 pointsBadges:
  • having trouble restoring a tape written by a Sys38

    the tape file is not created by a SAV*. We've been trying various combinations of CPYFRMTAP without any luck..... all three data file label say rec length =0 and block length = 16384. the dumped data looks like it might be a library.... with sources files. any ideas??

    Ccrinc0 pointsBadges:
  • AS/400 classes

    Hi, what is a class on AS/400 system and where are they used. How is it created and its significance?   thanks

    ten20081,150 pointsBadges:
  • CPYTOPCD command.

    Are any of you familiar with this command? Can this be used to copy something from the AS400 to a shared folder on a Windows system, or do any of you know how to accomplish this?

    Bkr0963c0 pointsBadges:
  • IP address clarification — different IP addresses for same computer – ipconfig vs. browser

    This question is just for my own education (as opposed to trying to accomplish a particular task).  Can someone explain the difference between the IP address which is displayed by sites, such as: http://www.displayip.net/ - as your computer's IP address  and the information that ipconfig...

    BookMama5 pointsBadges:
  • Data Extaction and Cleansing as/400

    What is the best way to extract and clean data from AS/400 dbase?  We are planning to replace legacy systems with an integrated package that may have a different dbase.  Is there a good product / service?

    Dataextract15 pointsBadges:
  • Simple printing from CL

    Is there a simle way to create a 'plain text' spool file in CL, without using DDS? I am trying to create a spool file in a specific OUTQ (configured as a *WSCSTNONE HPT). I do not need the AS400 to create any control characters, s I know the exact sequence of characters I need to print (Zebra ZPL...

    Wheeler50 pointsBadges:
  • something strange passing parameters…

    hi all, i will explain my problem : i have 2 CLP/400 programs, the first CLP1 who calls the second CLP2 by submitting it, and passing to him 35 parameters, for a total size of 1830 bytes (the largest parm is 256 char long), all parms are char defined. CLP1: PGM CHGVAR &P1 'toto' CHGVAR &P2 'titi'...

    Rodymary25 pointsBadges:
  • system save problem

    During system save with option 21, I receieved a message "Job 035775/Qsecofr/Dsp01 started (date/time) in subsystem qctl i not all subsystems ended" options were g or c. Selecting g only returned the same message after a few minutes. What is the problem and how can I get around it or determine what...

    Clwaid25 pointsBadges:
  • Communication to iSeries

    I get this message alot on my system, it seems to come everytime someone signs on and when my server downloads information to a database using ODBC. Is there a way to stop logging this message? Message . . . . :   User XXXXXXXX from client 192.168.X.XX connected to job   368959/QUSER/QZDASOINIT...

    plaporte55 pointsBadges:
  • DISK SPACE

    ANY TIPS ON CLEANING UP AS400 DISK SPACE.??

    PUCKHANDLER0 pointsBadges:
  • MMAIL

    Hello everyone, I recently downloaded the MMAIL Utility for Windows from http://www-922.ibm.com/mmailh/wmimemenu.htm I believe it installed successfully, but I get the following error for several functions like edit, display or open mime files. Error: "The value specified for one of the parameters...

    Orozcojoe0 pointsBadges:
  • OPNDBF

    This may sound stupid but I have not used OPNDBF command till now. I tried to use it thinking it will perform the same function as opening a database file in a COBOL program. I issued OPNDBF in a CL program and then tried to read records within a COBOL program without opening it in the COBOL...

    Pgsdeb20 pointsBadges:
  • RPGLE Build in function (BIF)

    It is imposable for me to set the length of Variable-Length Field D ServUser S 30A VARYING D IDLenth S 3i 0 C Eval %Len(ServUser) = IDLenth After this statement length of field ServUser still is 30 pos long. In Debug mode I get the message CPF7E2B: Type compatibility error occurred. Thank you for...

    Igor0010 pointsBadges:
  • Possible to transfer ASCII file from IFS to mainframe?

    Steve has a question about transfering an ASCII file from the IFS to a mainframe. He writes, "I'm being told that I can't transfer an ASCII file from AS/400 IFS to our mainframe. It transfers OK using Connect:Direct, but the file is unreadable. I can quite happily read the file on the IFS from my...

    MichelleDavidson515 pointsBadges:
  • What are these false hardware errors?

    Pat ran into this problem when applying PTFs. He writes, "We are running V5R2. When applying the CUMs, I always do the HIPER and DATABASE PTFs before I do the CUM. I IPL between the two groups. During my last two CUM applies, I got false hardware errors that halted the IPL. The first time I got the...

    MichelleDavidson515 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.

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

Following