• IPL an AS/400 system weekly

    May I know it is a good idea to IPL the AS/400 system weekly?

    Ytlow30 pointsBadges:
  • Arabic Text In AS/400 to Excel

    Arabic Text when transferred from Excel to AS/400 displays garbage. Is there an add-in I need to install? Kindly help me in this how to transfer the data file from Excel (.xls) to AS/400 DB2.

    AnwarHabib25 pointsBadges:
  • AS/400 Field totals

    I'm trying to run a query where I get the separate total for several fields in a table. I need a return with the individual totals for each field. I'm using the AS/400

    Vladdy5 pointsBadges:
  • BPCS user access list

    How can I generate a user access list in BPCS?

    srksherazi5 pointsBadges:
  • IFS Authority for symbolic links

    I have a problem with IFS security, I’m allowing users to create symbolic links to IFS files which they then cannot remove. I try to use CHGAUT on the link after creating it so the user have sufficient authority but this does not work, I am guessing this is because if you create a symbolic link...

    TMcNeil5 pointsBadges:
  • PASE for i already running in this job

    We have an RPGLE PGM that executes the following to establish a connection to another servers database and it works fine. DBcomm = JDBC_Connect(%TRIM(DriverName):%TRIM(ConnectionString):%TRIM(userid):%TRIM(Password) ); This statement starts running PASE. When the same user in the same job that just...

    Gman7325 pointsBadges:
  • Edit Client Access TFR

    I'm trying to upload a multiple Excel sheets to iSeries, Getting warning message: Multiple sheets exist in PC file. Do you want to send data from sheets other then first. I don't want to use other sheets. Is there a way I can edit the TFR and change it so it does not ask? Where can I find...

    polsh5 pointsBadges:
  • Automate AS/400 backup verify program

    Hi All, I perform AS/400 full system backups using go save, option 21 every week. Once backup is done, I'll give command DSPLOG LOG(QHST) MSGID(CPF096...etc) and verify how many libraries have been saved. I want this to be automated, can we write a program (CL/RPG) to pull all this information into...

    sivaknagula40 pointsBadges:
  • Is it possible to use ADDRDBDIRE to connect to Oracle database?

    Is it possible to connect to Oracle database from IBM i? How to do that (I have IP address user ID, password and SID)? Thank you.

    VadimR5 pointsBadges:
  • WebService call using WSDL2RPG.sh throwing EXCCODE 72

    I have generated code for my WebService as explained in this link http://www.mcpressonline.com/rpg/cool-things-ile-rpg-as-a-web-services-client.html This is my program: /copy EntitlementWebService.rpgleinc /copy EntitlementWebService_util.rpgleinc d ws_ds ds likeds(This_t) inz d wsrequest... d ds...

    sim400380 pointsBadges:
  • AS/400 Audit Journal extraction *CMD

    What command does IBM need to extract audit logs of *CMD run by users?

    aldc12310 pointsBadges:
  • JDBC driver for Linux connect to DB2/400

    Because SAP HANA runs in Linux, I want export data to DB2/400. Where can I download JDBC Driver?

    lance2221357270 pointsBadges:
  • Operation console 8231-E1C for Power 7 machine

    Hello everyone, I have Power 7 machine without HMC and I try to connect to system using operation console as mentioned in following link http://www.ibm.com/support/knowledgecenter/8231-E1C/p7eda/p7edacableandsetopscon.htm. After IPL, the control panel shows the code AA060011 which means that the...

    moeensokkar10 pointsBadges:
  • Slow connection to Oracle from AS/400 (OJDBC)

    I'm trying to connect to Oracle from AS/400 via OJDBC, but the connection is taking 30 seconds. The same is for connection to SQL Server. To connect MySQL is okay, it is simultaneously.

    migallego5 pointsBadges:
  • CCSID 935 to CCSID 13488

    I have a file that is ccsid 935 containing some records with Chinese characters. I need to convert that file to its upgraded version that is ccsid 13488. (These are vendor files, therefore I have no control over their definitions.)  It is possible to simply copy the older file into the upgraded...

    Ckelly0120 pointsBadges:
  • AS/400 report through BRMS

    Please let me know high level schedule for based on the attached reports. File Name DSPLOGBRM PERIOD((*AVAIL '01/10/16') (*AVAIL '01/10/16')) OUTPUT(*PRINT) DETAIL(*BASIC) Date is the date of full system backup. QP1ALG936228.txt BRMS reports for 3 servers WEBSTATS.txt DEVSTATS.txt PRDSTATS.txt

    Progrmmer20 pointsBadges:
  • Generate UUID number in AS/400

    How can I generate UUID number with human readable in v4r5 or V5R3

    birgarib20 pointsBadges:
  • List of companies migrated from iSeries to some other platform

    Hi all, Can someone have list of some major companies which migrated from iSeries to any other platform? Regards,

    hunshabbir72,820 pointsBadges:
  • Invoking web service using XML in RPGLE PGM

    I'm receiving error 415 - unexpected content type error - I have double checked the SOAP and all appears correct - is there a statement I need to add for content type to the XML? How can I tell what is causing this error? SOAP XML from PGM. SOAP = '' + 'http://www.w3.org/2003/05/soap-envelope" '+...

    angelafrye30 pointsBadges:
  • Executing PHP script from CL using qp2shell and php-cli

    I have a PHP script on the IFS which I need to call from a CL program using qp2shell and php-cli. I have the following code which works: CALL  QP2SHELL  PARM('/usr/local/zendsvr6/bin/php-cli' '/stuff/phpEmailer/index.php') However, I need the path to the PHP script ('/stuff/phpEmailer/index.php')...

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

Thanks! We'll email you when relevant content is added and updated.

Following