• SQLCODE = 1077952576

    All- I'm getting the above error code from an RPGSQL program. This is just after a DECLARE statement. Other fields in the SQLCA are blank. I can run the statement in Interactive SQL w/o errors. I should be getting a small subset. I get 0 records. Any Ideas?  It's not in the SQLCODE finder. Phil

    MurrayInfoSys940 pointsBadges:
  • Does sFTP works for SNDDST command

    Currently our business is modifying all existing interface (From IBM V5R4M0) with Windows server to replace FTP by sftp. Our Question is -- whether SNDDST works even after we covert from FTP to sFTP, if there exists any issue what would be the alternate IBM command which works along with sFTP

    edava50 pointsBadges:
  • Display Performance Data in AS/400

    I have several LPAR's that collect peerformance data. In one LPAR I can see all Performance Collections with DSPPFRDTA *SELECT in QMPGDATA. On the others only the current collection is shown although the *MGTCOL objects are in QMPGDTA. How can I force these to be shown on the other LPARs as well ?...

    pdraebel2,380 pointsBadges:
  • AS400 Printing Trouble

    Hello. My company upgraded our AS400 from v5r4m0 to v6r1m0 about a year ago. Ever since we've had issues with printers going into *END status randomly. The printers are two IBM InfoPrint 6400's. We never had this issue on our old AS400. During the day when we see it happen we just WRKWTR and use...

    Lemonjello100 pointsBadges:
  • Upgrading from V5R3M0 to V5R4M0 Using HMC on P-570

    I'm at the planning stage of this upgrade and it's the first upgrade with a HMC attached. There's no twinaxial console, so my question is , Can the HMC perform the upgrade? Do I need to attach a console, to carry out the upgrade.

    IVJ5 pointsBadges:
  • PM400 screen to print

    PM400 option Print performance report displays the screen (below) to allow the user to drill down.  This screen is a summary with interval of 15 minutes for a 24 hour period.  I would like to copy the data lines (all entries for 24 hour period) data down to an Excel file (or .csv).  ...

    infiniumpro325 pointsBadges:
  • APPN session initiation attempt has failed

    I get this message when someone or something is trying to connect to a system that has since long been Obsolete. My question is : is there a way to get to the job that is trying to get a connection to that location?

    pdraebel2,380 pointsBadges:
  • Restore iSeries tape

    Can I restore data on the tape ULTRIUM3 after I run INZTAP comand with CLEAR(*NO)?[Br _extended="true" />[Br _extended="true" />

    YMjK5oDo105 pointsBadges:
  • AS/400 Error: RRN() does not start from 1, but starts from number of rows deleted + 1 db2, v5r4m0

    i'm trying to populate a field in A table with the row number using rrn(tablename). the first time if i insert 4 rows then the id is 1,2,3,4 as required. if i delete the rows and try the insert again the rrn() does not return the same so 1,2,3,4 but returns 5,6,7,8 (that is the nr of rows deleted +...

    Elai45 pointsBadges:
  • Testing RPGSQL for the number of records.

    I need to update file A if I can match a record in file B using an SQL statement. (IE: is Work Order # 5 in file B.) Im looking for something similar to a SETLL. When I OPEN the cursor, will the SQLCA give me some specific answer? Or do I have to actually FETCH the cursor? Thanks, Phil

    MurrayInfoSys940 pointsBadges:
  • Query Manager Error

    Type SQL Statement ************************** Beginning of Data ************************* 0001.00 SET MISC :MISC6 0002.00 SELECT bcbgcd COLHDG("MISC" "CODE"), 0008.00 &MISC LEN(4,0) COLHDG("SHARED CONTAINER" "CODE") NAME(MISC) 0009.00 FROM lmbcrela 0012.00 WHERE bcbgcd=&MISC In checking the SQL...

    a1maida150 pointsBadges:
  • Version of DB2 running on AS/400

    I need to know the version of DB2 runing on AS400, do you know how can I to get it?

    GeLaLo10 pointsBadges:
  • Passing parameter to Query Manager

    I have the following query manager that errors with the following statement that is being placed in the CLP program: Type a value for variable "SELECT" and press Enter. This value should have been passed by the CLP program: *************** Beginning of data ************************************ PGM...

    a1maida150 pointsBadges:
  • client access from p/c to AS400 signon screen

    Since we have changed our password to disable the persons user ID for invalid attempts instaed of varying the seesion off. We now have aproblem where user get thier user ID diabled when really doing nothing. They have already gain access and are doing their work and may be inactive for a few...

    Dataadmin15 pointsBadges:
  • MQ software upgrade

    I am going to upgrade MQseries to latest version. I don't know anything about MQ. Can somebody tell me what are the basic steps I need to follow?   My machine is 9406-825 and os is V5R4M0

    Niranjanmulay35 pointsBadges:
  • i5 FTP over SSL

    I have a message: FTP Unsuccesful. See the FTP log in CPSSRC,OUTPUT .... Stupid question: how do I view the log ?

    Nallumaq40 pointsBadges:
  • How can I see when a user signs onto iSeries to check their profile?

    I need to know a user signs on the iSeries so I can check the profile aganist a file to disable the profile or not. How can I get this information??

    Carm5 pointsBadges:
  • Iseries Netserver fails to start

    We are doing a full system save of our system (model 520, v5r4m0). When the full system save completes and the system restarts iseries netserver fails to start because the subsystem qserver is not active at the time. This seems to be a timing issue. Not sure how i can get the subsystem started...

    jsrwagner20 pointsBadges:
  • Require the method and steps to decrease ASP and DASD utilization.

    Hi, I am new to AS400 Admin. And one of the AS400 box has high ASP utilization. The Disk space report shows the user libraries and user directories occupy maximum space. Can anyone please elaborate the steps I need to perform inorder to reduce the ASP utilization of the system.Specifically for...

    Meetmeonline210 pointsBadges:
  • How to run CHGPRTF on QSYSPRT in V6R1M0

    In V5R4M0, we are able run CHGPRTF on Qsysprt. In V6R1M0, this file is always unavailable, it is use by QSYS in SCPF. Any way to run CHGPRTF on Qsysprt?

    Gkcover15 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