• iSeries 9406-800 and V6R1

    We have a 9406-800 currently running V5R3 and we want to upgrade to V6R1.    First of all is the ox compatible with V6R1?   Secondly what kind of issues do I need to be aware of before I take on the upgrade?

    Shadow4412265 pointsBadges:
  • MySql Select multiple columnsfrom distinct rows based on one column

    I am building one sql query based on 5 select statements unioned all together. Each select is built as a variable with where clauses based on filters selected by the users. All 5 selects are concatenated together to build the one dynamic query. The one select below needs to be changed to select...

    Canuhp235 pointsBadges:
  • SSL certificates

    How do I configure SSL certificates on our IBM ISeries at v6R1? what will I need to do to setup this service for our iPad remote users?

    Rrockk200020 pointsBadges:
  • XML-INTO fails, which element caused it?

    I'm using XML-INTO in an RPGLE program with allowextra=yes, allowmissing=yes and case=any and it returns an error. PSDS doesn't give any useful info so what is the best way to figure out why it failed? If the end tag is mispelled it parses all the data but gives the same error as if the first...

    baumgardnd50 pointsBadges:
  • V6R1 storage limit exceeded for data queue

    Just upgraded to V6R1. Getting the following message in one of my applications: Storage limit exceeded for data queue. Why and how do I correct?

    Kfbarl5 pointsBadges:
  • Can wrkrmtwtr command be used on V6R1?

    can wrkrmtwtr command be used on V6R1?  would I download the savf that was created for V5R3, or is there a new one?

    Banjogbv5015 pointsBadges:
  • What is the earliest version of MQ needed for iSeries V6R1

    What is the earliest version of MQ needed for Iseries V6R1

    Otamir20115 pointsBadges:
  • Selecting Field Defined as L in SQL Server

    I am building 4 part SQL select across 4 files using union alls. All 4 files have a date field which is one of the fields I am selecting. My problem is that on one file the date field is defined as L type where the other three files have a date field defined as 8S 0. Since the field I am selecting...

    Canuhp235 pointsBadges:
  • CPF8361 Error after V6R1 Upgrade

    After upgrading from V5R4 to V6R1 we have begun to encounter CPF8361 errors related to Committment Control running embeded SQL.    Transactions get hung up in RDB and then processes get stuck.   Is this specifically related to the upgrade and is there a simple process to correct the issue. 

    Shadow4412265 pointsBadges:
  • Overlay and ‘print’ as pdf. Overlay not included !

    This statement OVRPRTF   FILE(MYPRTF)  DEVTYPE(*AFPDS) TOSTMF('/myapp/mypdfs')  WSCST(*PDF) beatifully generates a .pdf file and places it in the IFS-folder '/myapp/mypdfs'. ( ref:  http://www-01.ibm.com/support/docview.wss?uid=nas12bd8020c496ae912862575f400640da6  ) I have an overlay which I...

    DanTheDane2,555 pointsBadges:
  • SST password in AS/400

    i have installed V6R1 on my machine and i am not able to enter in SST whoever i have entered in DST and tried to change the password of my SST. I have not setup and ID and password for SST , please advise what do i need to do now, 1111111 and 2222222 is also not working.

    now225 pointsBadges:
  • Management Central running but cannot open.

    Management Central is running but when I try to open it I get "An unhandled win32 exception occurred in cwbunnav.exe" It opens a Visual Studio Just-In-Time debugger. Selecting Yes to debug doesn't work because the source is unavailable. Selecting No (and when exiting the debugger), the iNavigator...

    Jim328100 pointsBadges:
  • We have a COBOL application running on power6 , i 570 server with OS as V5R4

    We have a COBOL application running on power6 V5R4, will upgrading OS to V6R1 benefit in terms of performance.

    JohnsonMumbai1,160 pointsBadges:
  • Is message queue QSYSMSG still viable at releases V6R1 and above

    With all the new technology is message queue QSYSMSG still viable at releases V6R1 and above

    Shadow4412265 pointsBadges:
  • Edit mask on date field in AS/400

    Is there some trick that would allow using an edit mask on a true date field? I need to display a date in *USA format and allow the user to edit the date. If I convert the date to a numeric field, I can use the EDTWRD and EDTMSK keywords to accomplish what I want. If I display the date specifying...

    BWierman25 pointsBadges:
  • Find missing numbers with SQL

    In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

    DanTheDane2,555 pointsBadges:
  • Tracking IPDS printing on AS400

    How do I pass on user information to the printer from the AS/400? That is, if I wanted to embed user and job information on the IPDS job and send it to the printer, how would I go about it? 

    As400newton5 pointsBadges:
  • Why aren’t the Crystal Reports indexes showing since loading V6R1?

    I use Crystal reports via ODBC to the iSeries and have for years.  After loading V6R1 when I go in to create a report, the files aren't showing any indexes like they used to.  The used to show indexes based on the file definitions but now there are no indexes showing. I have even pointed the ODBC...

    DHardy5 pointsBadges:
  • Will the SQL performance improvements in V6R1 affect QUERY?

    Will the SQL performance improvements in V6R1 affect QUERY? Does QUERY use SQL under the hood?

    Fw15 pointsBadges:
  • Does V6R1 Support previous versions

    Does V6R1 still support older versions of IBM OS/400. E.g. does it still support IBM System36, IBM System 38, File naming conventions (TU.TABLE),relative files of System36 etc

    Nba5 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