• AS/400 Job Ended Abnormally and Message wait job

    Hi Guys,   If a job ended abnormally updating 20 files and not updating 10 files. What to do to update remaining 10 files?. How we need to take action considering there is no commitment control?.   And also if a job is in message wait because of record lock and if we are in a situation, where we...

    Alicsc370 pointsBadges:
  • SYNON built in function *CONCAT

    I need to combine several fields into one text field and thinking about using *CONCAT for that. However it seems that *CONCAT can only merge two fields at a time. If so it would mean a lot of code if I have ten fields to merge. Am I understanding this correctly? Thanks for any help! Lars Holmberg...

    Larsholmberg5 pointsBadges:
  • AS/400 performance issue

    i have a project which was compiled and running on v5.4. Now i try to run the same in v6.1 then the performance issue is coming that the product is running very slowly. I have recompiled entire project in v6.1 and then tried again, now the performance improoved bit, but not like v5.1. Why the same...

    Satya30055 pointsBadges:
  • Spool Manager/400 and V5R4 – any issues?

    We are about to upgrade to V5R4 on our iSeries. We run a utility called Spool Manager/400 (obtained in Europe) which is at version 310. Can anyone advise if there are any issues with this verion of Spool Manager/400 at V5R4. We have been trying to get some support from the company we pay for...

    djac900 pointsBadges:
  • Posting Data Online

    We want to "post" various documents on-line so that we can give members of our outside consulting group access to view, and even possibly download them. Is it possible without opening them up to the public-at-large? In answering, keep in mind the following: 1. We prefer not to purchase any...

    TheVyrys0 pointsBadges:
  • COBOL Compute statement

    How do I specify in COBOL the following arithmetic expression to calculate the value of Y. Y = 1 / (1 + exp(-X)) where exp(-X) is the exponentiation of the negative value of X and X is any numeric value.

    Timothy Li15 pointsBadges:
  • How to restrict AS/400 user to one Workstation?

    there is any way to lock the user so user only can use one workstation?

    Kiong135 pointsBadges:
  • Converting msg format contacts to nsf format

    I have few contacts in msg format. I want to convert/export them to Lotus Notes. These msg contacts are saved in my computer in the shared drive and I don't use Outlook in my office pC. Is there anyway I can export these contacts to Lotus Notes Address book(names.nsf)

    Charanpal10 pointsBadges:
  • What is the best way to wat to save the WRKJOBSCDE entries

    I am converting over to a newer AS400 and what to transfer my WRKJOBSCDE entries from one system to another and have not been able o find an to SAVE/RESTORE the entries

    TJB5 pointsBadges:
  • Convert as400 file to Excel and Pdf

    I would like to transfer a PF data into Excel , my add ins not working. Can u provide me any other ways to do that.

    As400programm10 pointsBadges:
  • What is QRWTSRVR and QCNDDMF

    What is QRWTSRVR and QCNDDMF for? Is there a default value? Where and how can I change and view this? Thank you

    Jedlasquite330 pointsBadges:
  • Combining printer files from multiple programs in one spool file in a job.

    We run one job with several checks at night. All these program use the same PRTF, but each results in a separate spool file. Is it possible to have the output from all these programs in one spool file? I.e. pgm1 has printed output and I want pgm2, pgm3, in the same job to add to it.

    r.otto810 pointsBadges:
  • Determining which concatenated dataset is being processed by a COBOL program

    I'd like to determine which dataset in a group of concatenated datasets is currently being processed. I have multiple datasets going through an edit process (COBOL) on a mainframe and when I find an error I'd like to list the DSN the record is in. 

    Jfruehwirth5 pointsBadges:
  • S0C4 ?

    I am copying VSAM file to flat file by using ADUT515 but the job is abending with SOC4 with reason code 10. how to fix this permanently ?

    Madabathula5 pointsBadges:
  • FTP from AS/400 to PC

    Hi Anyone Please help.. I need to pull from the as400 via ftp a file onto the pc. I tried the following: I have run ftp on the run command entering both the logon and password. I have done a dir dir 227 Entering Passive Mode (10,44,164,2,119,23). 125 List started. QPGMR 122880 08/06/11 05:05:00...

    devan390 pointsBadges:
  • System i Access Windows 7 V6R1 install error 1713

    I'm installing System i Access for Windows V6 R1 M0 on a Windows 7 machine and I'm getting the "Error 1713...cannot install one of its required products" error.  I've tried deleting the installed objects, cleaning the registry, rebooting and installing.  No Luck. This is the first problem in...

    Marz355 pointsBadges:
  • CHGPF doesn’t change the based on LFs

    I used the CHGPF command to change the record layout of a Physical File but the based on Logical Files were NOT changed - the Format Level Identifier still had the old value. 

    QCDT25 pointsBadges:
  • String Aggregate Function

    I need a report that provides an aggregate of a string column - in this case a concatenation of the values in a comma separated string. There is no such DB2 aggregate function that does this. A stored procedure (or possibly a customer aggregate function?) seems the only likely way to accomplish...

    Mgemmill5 pointsBadges:
  • AS400 – Queries

    Hi I have one query Which is a join of table A and Table B. select store,sum(amt) from table A and table B where A.fld1 = B.fld1 A.fld2 = B.fld2 A.fld3 = b.fld3 AND A.fld3 between date range group by Store order by store. I need to run this query in a batch mode,just by changing the date range.how...

    iiiiiiiiiiiii335 pointsBadges:
  • Autorefresh in RPG

    Once the display file is displyed, the control should be come back to the program after specified time and do the refresh of the screen. Can you please suggest some of the good methods and some examples for DFRWRT in DDS.

    frmdeva365 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