• Recieving a diagnostic message in program

    hi i want to recieve message text of diagostic message that encounters in program .I want it in a variable so that i can write it into a error log file .Please suggest a way to trap them and to have the text. i tried using RCVMSG but it dint wor out.   thanks

    munduuu420 pointsBadges:
  • How to delete data from IFS directory?

    How to write the program for deletion of data from IFS directory? Any cl program?  

    Sms121185 pointsBadges:
  • Need to write a CL program to track user logins

    HI, I WANT HOW TO WRITE A CL PROGRAMME TO KNOW A USER IS LOGGED IN OR NOT.MEANS IN A SERVER NUMBER OF USERS OR THERE SO I WANT TO FIND OUT WHICH USER IS LOGIN STATE WHICH OR NOT LOG-OFF STATE.WHEN I RUN A PGM TO PROVIDE USER NAME IT WILL SHOW THE LOGIN OR LOGOFF STATUS...

    KIRAN9SDR15 pointsBadges:
  • I want to send a DB2 file via email from AS400 to MS outlook using MMAIL/SENDMIME command.

    I want to send a DB2 file via email from AS400 to MS outlook.  I use command MMAIL/SENDMIMe inside my CL program. I've 2 issues. 1. whenever an email reaches to recipient, it attaches some .dat file which doesn't have anything in it. 2. the attachment is in notepad, it removes the readability of...

    Nutan70 pointsBadges:
  • How can I make the job generate just the higher severity messages?

    Everytime a batch job ended abnormally, it generates thousands of pages of job logs.  The jobd is set to logclpgm *no,  msg logging 4/0/*nolist. The job log has all the details of the record read between api programs.  How can I make the job generate just the higher severity messages?  

    Cmt645 pointsBadges:
  • how can i use like in cl program?

    how can i write this statment in cl program? Q -   select name from empname where name like %@name% thanks

    Engrania25 pointsBadges:
  • Download from iSeries directly to an Excel xls file – no CSV

    I need a little help! Is there anything out there that I can incorporate into a CL program that will download a database file to Excel with an xls extension so no further converting is necessary. I tried the CVTPFXLS but get Pointer not set for location referenced.

    Sillyhp35 pointsBadges:
  • cpysplf problem in cl program

    i have a cl program with the cpysplf command that is executed within it. before executing, it retrieves all the spool file attributes from a declared file. when i debug the program all the attributes are correct but it doesn't copy to the physical file. the file is at the top of my library list and...

    SKF75 pointsBadges:
  • Invoking A Menu Option From Within A Pgm

    Our Operations dept type the command [Go Backup] and take option 1 Is it possible to automate these actions from within a CL pgm? Thanks Martin

    Riccam30 pointsBadges:
  • Initiating a job only when a file contains records — CL

    How can I code a CL program to submit a job only when a file contains records

    aderene180 pointsBadges:
  • Create a Stored Procedure using CL and RPGLE programs

    I have an RPGLE program called from a CL program for database files overrides. I want to call the same programs from a stored prodecure on SQL Server from within a Web application. I am brand new to SQL Server but am pretty good on the AS400.

    NCharette20 pointsBadges:
  • Run SEQUEL Viewpoint Client Report from CL

    How can you run a Viewpoing client report from a batch CL job?

    SamH5 pointsBadges:
  • AS400 – FTP (put & get) files size compare.

    Hi, i have created a ftp scritp to put & get (back trasferred file) then compare them using CL program. ie: FTP Script PUT FROM_LIBRARY/FROM_FILE TO_LIBRARY/TO_FILE GET FROM_LIBRARY/FROM_FILE QTEMP/TO_FILE CL pgm 1) RTVMBRD FILE(FROM_LIBRARY/FROM_FILE) NBRCURRCD(&NBRCURRCD) DTASPCSIZ(&DTASPCSIZ) 2)...

    H0S40045 pointsBadges:
  • Controlling JDE app outage times during CL reorg

    We currently run a weekly reorg controlled by a CL program. Until recently we had a four hour window and are now looking to do the reorgs with the smallest possible JDE application outage. Any recommendations?

    AS400 - Ask the Expert485 pointsBadges:
  • how to pass numeric data to cl program from as400 command line

    Hi All, I want to pass numeric data of length (8 0) to my CL program while calling from AS400 command line but program is not receiving correct value into the program. Can anyone plz help me how to pass numeric data.

    Mohan K695 pointsBadges:
  • Transact SQL stored executed from AS/400 CL program.

    How can I execute a Transact SQL stored procedure (actually in the database) on a SQL 2000 database from an AS/400 CL program.

    Jcorzine20 pointsBadges:
  • Program Change

    We have legacy software when a user sign's on it takes them to a CL program/menu. If I make a change to a program they have to sign off and back on to ge the new change. Is there anyway to force that change to that user without them signiong off? There has to be away to do this. Thanks

    RonKoontz1,780 pointsBadges:
  • self-submitting cl pgm doesn’t release screen

    The interactive code in the CL pgm calls an RPG subfile pgm. The user makes selection, the CL pgm steps to the SBMJOB command, the CL pgm is executing the Batch portion, but the screen is hung up with "X system" displayed until batch job is done. The RPG is turning "ON" *inlr and RETURN is...

    Mccsteven30 pointsBadges:
  • Query Run

    A query is running in CL program and it is not showing any error and still it is running for hours together, how to find what error is there in the query?

    PS211230 pointsBadges:
  • WRKLNK on iSeries – HOW CAN I LIST THE STMF FILES UNDER A DIRECTORY

    How can I list or retrieve in a cl program the STMF files under a specific directory? Urgent reply requested. I am running a cl program that run use a software package that runs decryption on a group of stmf data with variable name. I need to retrieve the names in my cl to do further processing. Or...

    Ann45 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