• How to convert character date to numeric date

    Hi All, I have a character date field ('DD/MM/YYYY'). Now I want to convert into ISO numeric format in free format. Thanks

    97834441841,400 pointsBadges:
  • Passing Parameters into a clle program from a Menu.

    Hello I am wondering if there is a way to pass parameters from a menu into a CLLE program, whereby the parameter list could be variable. Most Menu options will pass one parameter to the CLLE program; namely the program name that will be called if security is passed. (PARM 1) But, there are some...

    Piano520 pointsBadges:
  • WRKDBF and undelete function V5R4

    We use wrkdbf and its global undelete and on demand (option 8) does not work with V5R4 (thanks IBM) I have applied the patch from the undel2 library but it does not work on production libraries or do multiple records at a time. It appears to be using my QTEMP and once that is created it does not...

    Superjk15 pointsBadges:
  • Programmatically place outq on hold when empty

    Hi, I have been tasked with writing a CL program that will be run every night that releases a held Outq and allows the contents to go through then, put the outq back on hold once there are no more spool files in it. Is there an API or something I can use in a CL program that will check for an empty...

    Ronnieb345 pointsBadges:
  • System Administration guide lines

    Hi, I'm very new to the administration on IBM i. I have many years of Developmet experience on AS/400 but now my job involves more on admin front than the development. I request you to please help me with some useful tips and guidelines along with some good links on this. Thanks Ram

    ten20081,150 pointsBadges:
  • SAVOBJ command to copy files to a save file

    I am trying to use the SAVOBJ command to copy files to a save file. Is there a way to add to the save file and not write over it with each SAVOBJ call? I know I can create a list of files and send all of them to one save file but I would rather just add to the save file if possible. Thanks!

    Nward35 pointsBadges:
  • Installing V5R4 to V6R1

    Hi, I want to know what are all the problems will appear when I'm installing the V6R1. Now I'm using V5R4. Please let me know the benefits also. Thanks in advance Prabhu

    Sprabhu15 pointsBadges:
  • Can a join logical file only select highest value when multiple records are found?

    Have a file of students (stu # as key), want to join to enrollment file & get the most recent activity date (could be many records for one student or one record for a student). Can a join logical file be created that would give me that? SQL can select via max operand. Does DDS have something...

    BillGood15 pointsBadges:
  • Directory command is not working

    Call qcmdexc parm('CPYTOIMPF FROMfile(mylib/myfile) TOSTMF(/home/test/test.txt)') It is not working I think because of the missing ' I tried to fix it with a hex value of x'7D' but the run SQL procedure didn't accept it

    Blueye20 pointsBadges:
  • Spool File Deletion

    How do I delete Spool Files of a particular user for a specified date range. For eg. Spool Files of Rahul needs to be deleted for dates between 01/01/2009 and 30/07/2009. Kindly help since the Spool File Count for many users ranges from 4152 to 86592 and the same are not required & can be...

    Haaiderali215 pointsBadges:
  • Retrieving current market price of platinum in a RPG /CL program

    We need to invoice our customers the cost of platinum used in some process, based on its usage in grams. I need to retrieve the current market price of platinum from internet and use it in RPG program to do the calculations. How can we retrieve the current market price of Platinum in a RPG/CL...

    SHhand25 pointsBadges:
  • How to restore the save file from directory in AS/400?

    In my environment FTP is stopped so I had copied the save file to local path and past it on destination server. Now I need to work on that save file. How to restore the save file from my WRKLNK directory? Please clarify with details.

    venky48450 pointsBadges:
  • AS/400 Job log not generating

    In my server JOB log (Spool file) {QPJOBLOG} is not generating for successfully completion jobs. Which parameters I need to check? Is there any system value I need to change?

    venky48450 pointsBadges:
  • Have an Excel macro download data to the iSeries

    Is it possible to code an Excel macro to download a spread sheet to the IFS (on the iSeries) and then to start an iSeries job to process the downloaded data?

    aderene180 pointsBadges:
  • RPGLE Trigger – Return Changed Field

    I have a file with an DES encrypted field on the i5 - V5R3. I wrote the program below as a trigger to decrypt the field and return the clear field to the program that initiated the read. I know the decryption works in the trigger but the decrypted data is not returned to the reading program....

    Rlsantucijr445 pointsBadges:
  • RPG: Two PF have same field

    There are two PF, each PF have same named field, but the length of the field not same. How can I use the field in the program?

    Freefly ho15 pointsBadges:
  • LPAR configuration

    Hi, we just received a new AS/400 i570 system. I would like to know how to create LPAR using the HMC console. We have 16 processor and 192 g of memory. I need to create 4 LPARs.

    Rider5 pointsBadges:
  • Opening RTF files using Visual Basic CMD button

    I'm in this project and got problem on how to open a file from RTF using VB CMD open button. What's the code? Thanks.

    Studs5 pointsBadges:
  • Okidata 391 printing draft quality

    Okidata 391 jumps back to LQ instead of staying in draft mode between every spool. Is there a way to stop this and print draft all the time?

    dwichman5 pointsBadges:
  • Unix/Shell/PERL scripting on AS/400

    Hi, Is it possible to create and run the Unix/Linux/Shell/PERL scripting on AS/400 directly? If yes or no, please tell me how does they interact with each other in real time scenario. Regards, Ram

    ten20081,150 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