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

    kglen0160 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,170 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:
  • Identifying Source Mbr Names Conditionally

    I would like to find a way to conditionally print source file member names that contain a trailing $ sign. Is there a way?

    Tom196035 pointsBadges:
  • Compare creation date of file to system date

    Hi, I need help in figuring out the begaining of my CL program. I would like for the CL to act accordinly. Check a file creation date and compare that date to the system date, then if a match (do something), if not a match (send message and end job). Thank you

    lotofbad205 pointsBadges:
  • Strengthen QSECURITY level 30

    Hi, Any tips and tricks on how could i strengthen QSECURITY 30 to patch the loophole in this level (without going to QSECURITY 40)? Thank you

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