• DSPLY SQL value is zeros

    I am trying to display the 2 result values from this SQL statement and they are zeros: D totdlq S 11 2 inz(0) D totcnt S 5 0 inz(0) * D totdel S 20a D totrec S 10a /Free Exec sql DECLARE C1 CURSOR FOR DynSqlStmt; Exec sql open C1; Exec sql Select sum(utcbal), count(*) INTO :totdlq, :totcnt from...

    a1maida150 pointsBadges:
  • Job Scheduler Authority

    I have a operator that is unable to submit a job in the scheduler using the "Option 10 to Run Immediately". He gets a error message "Not Authorized to user QSYSOPR" How do i authorize his group profile to user QSYSOPR? I'm not to familiar with the Job Scheduler and am looking for some help.

    jjsuthe125 pointsBadges:
  • *ALLOBJ

    Hi, I need to create an ID, the main condition is that he should not have any special authorities(especially *allobj ). where he should be able to access (Read and write only ) for some library and its objects (more than 10 libraries and 20000 objects). Where those libraries and its objects are in...

    IBMiserver35 pointsBadges:
  • Subfile positioning while adding records

    Hi, I am having problem in repositioning subfile when I add a record. Scenario is like my subfile is self extending and page size is 4 .Data is like a,b,d. Suppose i add e then it gets positioned to e and page up don't work . It shows end of file found. Now if i add c it again position file to c...

    munduuu435 pointsBadges:
  • Changed external data structure

    I have RPG program P1 which has an external data structure D1 on a file F1. I am reading the file F1 in PGM A and based on a condition I am calling PGM B. In PGM B I am updating a field of the file F1.When the control returns to PGM A, the updated field in the file F1 shows blank in the external...

    Tecchie30 pointsBadges:
  • Data in Dump

    I have got a dump file of a program which went to message wait last month. From the dump I got to know the value of a field as 'Asset'. I would like to know there can be a possibility that data is 'ASSET' but displayed in dump as 'Asset'?

    RamvishakRamesh2,505 pointsBadges:
  • Is this a library list error?

    Function check. CPF0001 unmonitored by * at statement *, instruction X'0021'

    jnixon55 pointsBadges:
  • Good book to learn SQL in AS400?

    I would like to learn SQL query, embedded SQL etc. Any suggestions from people who are in this field for many years?

    RamvishakRamesh2,505 pointsBadges:
  • QPFRADJ – Set to Automatically needs a IPL?

    Performance issue and suggestion to set the QPFRADJ (Performance adjustment) to Automatic...does that needs an IPL?

    AS400PERFORMACE60 pointsBadges:
  • Finding the duplicate job

    I have submitted a job.Now i want to identify the duplicate job submitted/running by using the CL Program.

    ankit2002770 pointsBadges:
  • AS/400 has a performance issue after OS upgrade from V5R4 to V7R1

    AS/400 has a performance issue after OS upgrade from V5R4 to V7R1? Any specific requirement? Performance tunning/Monitoring option ?

    AS400PERFORMACE60 pointsBadges:
  • Color Overlays?

    What is required to produce a COLOR overlays on an iSeries. B&W is no problem.

    DLM2007285 pointsBadges:
  • Networking

    Control messages between the Hosts are exchanged through IMPs, which causes the unnecessary delay. Suggest an alternative to minimize the delay?

    51403210 pointsBadges:
  • SQL Query

    I have a file which has a account number and name. I want to find all those account number which has more than one name. How will the query looks like

    RamvishakRamesh2,505 pointsBadges:
  • Session Limit – Cannot Ping AS/400 Server

    Why can some users ping the AS/400 and some cannot? Does this have anything to do with reaching a session limit?

    ssburns20015 pointsBadges:
  • Trimming trailing Zeros

    I have a numeric field of 25,9 in a file. I have a program which calculate this value. I want to appear this field in file without trailing zeros. If the value is 2,935.995000000 I want it to write to file as 2,935.995. How is this possible?

    RamvishakRamesh2,505 pointsBadges:
  • Add In function in Excel 2010 to download file from iSeries v7.1 exceeding limit, is there something we need to do to up the limit of records from 64K

    We are running a Data File Transfer from the iSeries to Excel 2010, using the Add In off of Excel for File Transfer From iSeries. We can only download 64K records. How can we get this size limit to be larger? Our iSeries is at V7.1 and our client Access is at V6 and/or V7 for various users. We want...

    pgmr85 pointsBadges:
  • How to display more than 1 error message in a message subfile

    I currently have a screen that display an error 1 at a time in a message subfile. User can roll up or down to display the next error. I want to be able to display all errors in message subfile in 1 full screen when user hits a function key. Since the message subfile (sflpag=1) already has the...

    kglen0145 pointsBadges:
  • F22 step into in STRDBG not working

    Using STRDBG, I use to be able to hit f22 to step into a program or procedure but now nothing happens when I hit the key. Is there a setting that enables this?

    kglen0145 pointsBadges:
  • Query400 report generation

    I'm using query400 tool and using output type as printer files.. I want to generate a report format of transactions like this.. date act# amount date1 act no1 total act no2 total act no3 total date1 act no1 total act no2 total Final Total example transaction is like date act# amount 23/10/12 100...

    sivakesava280 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