• OPNQRYF & CPYFRMQRYF error

    The log is: output file file1 created file1 added to library mmember of file1 is opened in library. data option was not allowed with open option error reading member file1 in file1 0 records copied to file2

    Archnav01270 pointsBadges:
  • How to insert data from SQL procedure

    How can I insert data from SQL procedure. I am using cursor.

    97834441841,355 pointsBadges:
  • What is QTEMP library?

    What is QTEMP library?

    q2w3e4r510 pointsBadges:
  • Outfile printing

    In CL, I've created a outfile out of dspobjd cmd. To this file, i've filtered a column using opnqryf. I've copied the output (cpyqryf) to a new file. While doing this, i'm getting the error data option was not allowed with open option' The log shows :The first file is created-> added to library....

    Archnav01270 pointsBadges:
  • Need to replace Data transfer RXFERPCB.

    Hi All, Have an old program using data transfer. It works fine from the green screen. New Mapics Software in IDF Level 1 does not like the transfer and stops it with a client error. What is the best way to replace this? Tried CPYTOIMPF and sent the physical file to a folder on the I-Series as a...

    NYRANGER245 pointsBadges:
  • How to create Report on WRKOBJ’s output using a pf?

    Hi gotta develop a pf which will show all the objects under all user's library. Please suggest

    Archnav01270 pointsBadges:
  • AS400 i series – command/field for qry report “last payment date” and during scheduling – how to flag appts

    I am new to using AS400 i series/applications and am becoming familiar with creating/working with existing qry reports.   I am attempting to tweak an existing qry report so that it will also pull (from field needed) data  to include a customer's "last payment date".  I realize that this can be...

    Newlearner2IT30 pointsBadges:
  • transfer problem on iseries

    How do I transfer up a record upto 500 long and not have it wrap on the AS400 ? It will only handle 300

    travisthip15 pointsBadges:
  • AS/400

    How to change the field name in PF?

    avslxmnryn5 pointsBadges:
  • sqlcmd :0 rows updated

    When I run exec dbo.subprogram from sql server management studio, it executes and returns result as many rows affected: But when I run from cmd C:\Users\mssadmin>sqlcmd -S servername -d databasename-q "EXIT( exec dbo.subprogram)" it retunrs as 0 rows affected. What could be the problem

    Beena5 pointsBadges:
  • Strange DNS resolution.

    Hello. This week one of our AS400 got me all surprised. I do not know what to do, where to look, so I would like to ask here...just in case. On this AS400, among others there are four host table entries. These entries are set to 2.xxx.xxx.xxx addresses. The DNS has 9.xxx.xxx.xxx addresses. Customer...

    Champs60 pointsBadges:
  • How to omit one IFS file from BRMS on AS400.

    Please let me know how to omit one particular IFS file from daily backup. The IFS ( /QIBM/UserData/OS400/ResourceMonitoringControl/var/vpd/Hardware.xml) is not being saved on daily backup due to job lock. Hence user requests us to omit this file from backup. Please assist me to omit the IFS file.

    IPDSprinter110 pointsBadges:
  • Problem with CMD/CL and *PNAME type (Path name contains embedded nulls.)

    So I am giving a good effort into writing a CL/CMD pair to start one of our programs from the command line, but I've hit a snag. Here is my CMD source: CMD PROMPT('Start Engine') PARM KWD(PGM) TYPE(*NAME) LEN(10) DFT('TRAN_ENGV2') PROMPT('Engine Program Name') PARM KWD(PATH) TYPE(*PNAME) MIN(1)...

    DraeByllek45 pointsBadges:
  • AS400 object authority

    How can we restrict a particular user to the newly created objects in a particular library. By default the objects creating as *public with *CHANGE authority and this user having the access for newly created objects, so please let me know the steps or procedure to restrict this user for newly...

    Syedm180 pointsBadges:
  • Using cursor in SQLRPGLE

    Can i use single cursor for multiple SQL statements? ex:  declare c1 cursor for select * from ....... also declare c1 cursor for select * from xxx

    varad40 pointsBadges:
  • iseries printing problems

    We have boca printer for printing tickets , when we disconnect and connect printer it appears to be connected but we have lots of messages say "unable to obtain lock on prtxx device prtxx" in the message Q.. we tried lots of commands such vrycfg , wrkobjlck , wrkwtr ... it never response giving the...

    abar1425 pointsBadges:
  • problems with printer in s36

    we have boca printers for printing tickets ... when we disconnect printers and reconnect it again a lots of messages appears in the message q say "unable to obtain lock on device" we tried vrycfg , wrkwtr , and other commands we tries also to change the writer configuration it says " prtxx not...

    abar1425 pointsBadges:
  • what happens when you forgot to transfer job to qctl then you ipl

    i forgot to issue the command TFRJOB (QCTL) to our system after i ended all subsystem. then i tried to issue it. but i did receive an error. so i did panic and thought that IPL will solve it. and so I did. what could be its complication for i was to go for a full system backup. thanks

    joverparas360 pointsBadges:
  • Getting error messages from qsysopr

    Need to gain access to qsysopr error messages coming from custom apps written. Do NOT want an agent on box. Any thought son how to gain access to these error messages?

    Nellie25 pointsBadges:
  • Expand Counter Size in WRKQRY

    I use WRKQRY to produce a summary file. I use '5' to indicate the counting on a special field. The counts is larger than 9,999,999. I got field overflow. How to expand the counter field?

    chen755515 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