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

    sivakesava285 pointsBadges:
  • Fixing the decimal data errors.

    In the commands CRTBNDRPG & CRTRPGMOD we have the parameter FIXNBR to fix Decimal data errors. Do we have such provision for ILE COBOL?

    mvrkrishna555 pointsBadges:
  • Xerox WC 7535 print from iSeries and passing security code XSNMPDRV

    We have a client that would like to print to a Xerox WC and they have it setup to accept a security code. We have created a printer device using the IBMSNMPDRV but it rejects the process since it did not receive the security code. Has anyone done a configuration using the XSNMPDRV and configuring...

    hafwhit1,145 pointsBadges:
  • Performance improvement CPYTOIMPF

    Hi, I am using CPYTOIMPF command in my CL program to convert a database file to .CSV file. database file contains 3 million records and CPYTOIMPF command is taking 48 minutes to complete. Can some body kindly suggest me is there a way to improve the performance of the program. Thanks in advance. CV

    ZWANZIG40 pointsBadges:
  • Accessing STRSQL

    Can granting access to limit capabilities *partial or *no will give user the access to STRSQL?

    100282145 pointsBadges:
  • Modify the result after a division with multiples of 10

    I have an expression like this Total = Quantity/10**decimal. If I have value 000080906140000 in quantity and decimal has 6, my result is 0000000080906.13. But I want it as 0000000080906.14. Is it possible?

    RamvishakRamesh2,505 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.