• CL/QMQRY

    i hav code   STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT)   In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it...

    Sanashakeel15 pointsBadges:
  • CL Programming

    PGM                    DCL VAR(&TIME) TYPE(*CHAR) LEN(6)                    DCL VAR(&DATE) TYPE(*CHAR) LEN(6)                    DCL VAR(&YEAR) TYPE(*CHAR) LEN(2)                    RTVSYSVAL SYSVAL(QTIME) RTNVAR(&TIME)                    RTVSYSVAL...

    anupsshelke420 pointsBadges:
  • As400

    i need to convert folling rpgle code into rpg EVAL      CMDKEY = %TRIMR(CMDKEY) + ' ' + F6COM 

    Nikrajpapa230 pointsBadges:
  • Printer Overlays

    What is the simplest way to create an overlay for a printer file? I'd prefer to go generic, rather than buy a package.

    OldScott10 pointsBadges:
  • CPF3309 error message

    While executing CPYSPLF command I get the error CPF3309 with the error description , " No files named &1 is sctive",Please let me know your thoughts and advice solution for the same

    assa150 pointsBadges:
  • AS400 TELNET

    Hi, whilst having problems with connectivity to AS400 sessions, was advised to restart the TELNET service. How do i do that, will a simple ENDHOSTTCP and STRHOSTSVR do? or do we have any specific procedure that need to be followed to? Thanks in advance

    harisudhan211,005 pointsBadges:
  • Recompile CL program

    Hi, We added few new fields to an exising Physical file. When I check for the dependents for the changed Physical file in ALDON it shows 250 dependent objects. Do I need to recompile all 250 objects? Thanks, Elan

    elan0030 pointsBadges:
  • How do you code footers in DDS Print File?

    I need to print a footer on every page of a report. Thought it would be simple like headers. If anyone has the answer let me know. Thx.

    Kdbwheels180 pointsBadges:
  • iSeries number of Web users

    How can I find out who is logged into the system via an applications web interface?  i.e. Lawson, Jgo, etc.

    NickHutcheson11,380 pointsBadges:
  • COBOL400

    I get the following message MCH3601 (pointer not set for loacation referenced) when calling a Cobol program from another Cobol program, passing 4 paramters.However this abend happens on the second call to this program as the first call was sucessful.Can anyone help me. It fails after open...

    Rr22100 pointsBadges:
  • Vista and Office 2007

    We have a customer upgrading their PCs with Vista and Office 2007. The host is an 820 at V5R3. iSeries access fix pack is SI28055. Does anyone have this mix and do you have issues to report? Thank you.

    maryann465 pointsBadges:
  • CPYTOIMPF .txt file shows garbage when viewing on windows

    CPYTOIMPF .txt file shows garbage on IFS when viewing on windows but when using wrklnk it looks fine, please help.  below is cmd than used.  /* copy the file to stream file and put delimiter */       CPYTOIMPF  FROMFILE(&FILENAM) TOSTMF(&STRFILE) +        ...

    M0015 pointsBadges:
  • Security and QSECOFR number of sign-ons

    For security purposes, the number of sign-on attempts can be *NOMAX or as few as one. I configured for 3 maximum sign-ons. Does anyone know if the OS/security sums the total number of sign-on attempts from the device only before it disables the device, or does the OS not count total from the...

    Gmil494365 pointsBadges:
  • AFP report to PDF (20bytes naming convention for PDF)

    Hi All,  I have a requirement to save my splf (reports with overlays - AFP format) in an IFS folder.  I need to store them with a custom 20 byte name and in a PDF format.  I tried SPL2PDF and it works as long as there are no overlays. So is there anyway to convert an AFP reports to PDF.  We are...

    Rohitha1Lavu25 pointsBadges:
  • RPGLE opcode similar to SNDF in CL

    Is there any way we can display a message "Processing" while the program is building the data in a subfile. In CL we can use the SNDF command to send such message to the display. Please help.

    ShajiMohan45 pointsBadges:
  • Convert seconds into time format in QM Query

    I have one scenario where i have time field as seconds and i need to convert this into time format like HH:MM:SS in 24 hour format in query 400. I am using V6R1M0. Can anyone help me on this ASAP? Thank in advance Saravanan D 

    Dsaran2007150 pointsBadges:
  • STRQSH Not working in CL for JDE Server Manager Stop and Start

    Hello, I hope someone can please assist and let me know why when we run the submit command for STRQSH in CL, it does not work?  But when we execute the command from the command line, it works fine. Here are the commands, SBMJOB     CMD(STRQSH...

    IS Questions110 pointsBadges:
  • Clear a logical file

    Is there any command to clear a Logical File?

    RamvishakRamesh2,505 pointsBadges:
  • AS/400 question

    how can we see records in a physical file without using run query?

    Ramaduguanil5 pointsBadges:
  • iSeries text message alerts

    Does anyone know of a cheap solution that will allow mobile phone text alerts to be sent from an iSeries system. Specifically for jobs in MSGW or Threshold warning messages etc.

    Bristoldoug45 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