AS/400 Tag Directory

Featured AS/400 Questions

  • How do AS/400 stored procedures get output?

    I have created a CL which calls an RPG program. Now I have to create a stored procedure which calls the CL! As RPG normally sends back the output to CL! How should I send back the output to SP? Will SP normally pick it or is there any command to send back the output to stored procedure (SP). I have...

    bharathtata25 pointsBadges:
  • DLCOBJ command not working

    I have a program that allocates an object (*file), calls a program, then deallocates. The dlcobj does not work. RPG PROGA calls CL PROGB which calls CL PROGC. PROGC does the alcobj and dlcobj. However when the program returns to PROGA (interactive RPG), the object is still locked. Any ideas?

    ttufankj25 pointsBadges:
  • Error message when compiling CL program: CPD085C 40 Graphic field not allowed for variable & OBJRTVUCS

    Graphic field not allowed for CPD085C 40 Graphic field not allowed for variable & OBJRTVUCS is the error message I get when compiling CL Program. I'm taking output to file of a Vision WRKDG command. This ouput file I declare in the CLP.  While compiling the CL, I'm getting error 40 with...

    JohnsonMumbai1,365 pointsBadges:
  • CPYFRMIMPF command successfully copies to PF but resulted to special characters on PF

    I have created new directory in AS/400 named MMVRADIR with subfolder MMVRAFLR. I have a CL program using CPYFRMIMPF command to restore the content of a txt file inside "MMVRADIR/MMVRAFLR/APDM082716.TXT" to AS/400 physical file SMREB33F. The CPYFRMIMPF was able to copy the contents but when I runqry...

    KAILOFOXS5 pointsBadges:
  • OPENQRYF: Unmonitored message CPF9899 occurred at statement

    Hi All I had made the changes in the program and debug the same but while debugging it gives me the following message at open query file line as: Unmonitored message CPF9899 occurred at statement. OPNQRYF FILE((F60SLB05)) QRYSLT('YTAN8 *EQ ' *CAT + &EMP *CAT ' *AND YTATIM *GT &STARTDATE +...

    Anshul14095 pointsBadges:
  • How can I get system CPU usage and individual job CPU usage from database output of WRKSYSACT command?

    How can I get current system CPU usage and current individual job CPU usage from database file output of WRKSYSACT command. Which are the fields which store these values. I would like to write a program which reads the output (*file)of WRKSYSACT command. This program would send a message/mail when...

    JohnsonMumbai1,365 pointsBadges:
  • How to retrieve the directory name from a string containing directory name/object name in clle.

    Dir1/dir2/dir3/dir4/test.csv. How to retrieve the directory name in reverse order. There is a huge number of records for which I have to get directory name in reverse order. Method that uses less time is required. Tried QSHELL Dirname that will output the STDOUT details to a database file. Here...

    NicyChn135 pointsBadges:

    I am writing a CL program in which I do OPNQRY file based on status field in the file. After this data selection, an RPG program is called which processes the data and changes the status to next status. After the execution of this I call another CL program. In this CL program, I want to copy query...

    abhinavpassi15 pointsBadges:
  • How to create a startup program for WAS61. The program to start the subsystem (QWAS6/QWAS6). 2 JOBS under qwas6 (wmp and wmpappsvr) after every IPL.

    I was assigned to create a CL program to call a startup program to start subsystem automatically after every IPL. the program WAS61 located here: /QIBM/ProdData/WebSphere/AppServer/V61/ND/bin. I do not know where to start and how. Please help anyone. I have tried the steps mentioned here...

    ejaaje150 pointsBadges:
  • Problem with AS/400 data transfer to Excel

    I have been downloading AS400 query files to Excel spreadsheets for many years using the Data Transfer utility in Client Access. There has never been any problem. Now suddenly all of the output data has started transferring to Excel as long hexadecimal strings and is unusable. I asked the IT folks...

    JDK55 pointsBadges:
  • Error in calling RPGLE program from CL

    I have a job running under subsystem. This job is using a CL program which inturn calling RPGLE program. The CL program is failing in call statement to RPGLE with following error message in jobog: Pointer not set for location referenced. Pointer not set for location referenced. Pointer not set for...

    Mayurp5 pointsBadges:
  • Error code CWBCO1048

    I keep getting a CWBCO1048 A firewall or blockage or Time-out occurred trying to connect IBM i. How do I cure this. It seems to happen in only this one branch and not in any others? Thanks Leo

    superbru43115 pointsBadges:
  • Modify hexa string value in CL

    I have a hexa string and I want to modify some value while running program through CL below is the hexa string. X'011F011F000000000F099999999FC9020160309FF0D5 404040F9F9F9E3000000000F40404040404040') In the above string I have a date 20160309. Now I want to change this date to current date.

    97834441841,465 pointsBadges:
  • Why is CL the native language of AS/400?

    Why is CL (Control Language) the calling native language of AS/400? And why it is a driver program?

    Angelg5 pointsBadges:
  • New line in message formatting in CL program

    I want to insert a new line in message formatting in CL program. Like Name new line and details new line and rem details. How can insert a new line in message formatting?

    sivakesava285 pointsBadges:
  • How to pass numeric data to CL program from AS/400 command line

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

    Mohan K695 pointsBadges:
  • CPD0304 when using SUBR and ENDSUBR in CLLE

    I know I've run into this the past, but I can't remember the fix.  I am using V5R4 and trying to use CALLSUBR in my CLLE.  I end my mainline with a RETURN, then I have a SUBR/ENDSUBR... and a 2nd SUBR/ENDSUBR.. then a ENDPGM.  When the compiler hits the 2nd SUBR I get a CPD0304 and it rejects...

    JamesR90 pointsBadges:
  • Use of variable CPYTOIMPF command

    How do I use a variable as the target file in CPYTOIMPF in a CL program?

    tonycs10 pointsBadges:
  • IIF function

    I have 2 tables: First table: 1- name 2- position 3- nationality 4- visa No. Second table: 1- Position 2- No of visas. 3- No of used visas. 4- No of remaining visas. But I want to use IIF function when add new position in first table increases the no of used visas in the second table automatically....

    khalid1155 pointsBadges:
  • CL/400 – How to convert Spool file to Notepad

    Hello Friends, I have a question. In my current project, I have to covert a spool file to notepad and this notepad I have to send it as an attachment to one email address. Question 1: How can I convert spool file to notepad? Question 2: How can I send a notepad as attachment to one email address?...

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