• opnqry

    I need to select a range of dates for a single parameter in opnqry. qryslt(’date *EQ ‘ *CAT &wrkDTE),where date is numeric and wrkDTE is char.here i have just selected 1 day i want data for range of dates Please suggest.

    0 pointsBadges:
  • RRN to Chain the file

    I want to chain a file with RRN value but the file is not KEYED. How is it possible in RPG/400?. Please suggest me!

    frmdeva365 pointsBadges:
  • Duplicate overlays not printing on the same page of a report

    We have a report that is suppose to print the same overlay twice on a page but only prints it once. We get an AS400 error message PQT3302 but do not know why the error occured or how to resolve it. The error message says 'Print data may be missing from the report'. This is true the second overlay...

    Nmassey5 pointsBadges:
  • System date and RPG/400

    please advice me how to less 1 day from system date in rpgile. please send me the syntex.

    Askt1140 pointsBadges:
  • cl

    i have created a file member AA20081224 using addpfm.The file members will get created on a daily basis with that particular date appended to AA. I need a code that will check on a daily basis if there are file members that are more than 3 months old and purge all members except for the one...

    0 pointsBadges:
  • move document to AS400 (Iseries) folder

    How do you move (or copy) a document from an IFS directory to an Iseries folder?

    AZL20 pointsBadges:
  • As/400 Job number ..Two part question

    Hi all, We are in the process of implementing online paystubs for employees to view. Here are the steps that I am trying to automate from the IT side of the house. 1) Clrpfm 2) cpysplf 3) cpytopcd So far..number to is the issue due to not knowing what the job number will be in advance. I have...

    Rmason345 pointsBadges:
  • AS400 Print Screen button on upper lefthand corner not working with new VISTA PC

    Hi, A user reported a problem where she used to be able to print whatever's on her screen from within any AS400 application by pressing the print screen icon on the upper lefthand corner of her screen (under the File button). Since she got a new pc with VISTA on it, it only prints a screen with...

    Kineno1615 pointsBadges:
  • cl

    i have a flat file. data is populated to this file on a daily basis. I need to create a new member every day as and when the flat file is populated.In my cl code I tried using AA *cat &qdate in addpfm and build the name of the file but couldnt do so...As stated earlier i neeed this to purge members...

    0 pointsBadges:
  • How to send the data from a Physical file to a Flat file

    Please check the below prgram and advice me how to send the data from APH(physical file) to Flate file SAAPH (flat file). FTRF is a datstructure created for send the data only this two fields in flat file. i am not sure how to club this data structre and flat file in programe. FAPH IF E DISK FSAAPH...

    Askt1140 pointsBadges:
  • FTP Source File transfers between to AS/400 systems

    I have written a bound ILE CLP and RPG comand/program that will allow LIB/FILE.source transfers between two AS/400 systems and/or LPARS using FTP. It works fine with the exception that the source files are transferred with out the Descriptive TEXT. Does anyone know how to solve this dilemma? We are...

    ECLAY25 pointsBadges:
  • CL SysDate Conversion

    Hi I have converted the sys date to *CYMD format.I have two problems, 1.For eg 19/12/08 is now 1081219,where 1 stands for 2000-2050 and 0 stands for 1900 to 1999(defined in system).But i want to map this with dates in file whose format is 20081219. 2.If this is possible i need to subtract the date...

    0 pointsBadges:
  • Printer drops out when spool file goes to associated Output Queue

    We have a Xerox Phaser4500 printer config as a 3812. Recently our third party software ACOM creates a merged CHECK spoolfile (its an *userascii) type from mapping and sends it to our outq. The spoolfile will show "WTR" and nothing prints. The printer then has to be turn off and on again. And then...

    Donna5 pointsBadges:
  • Native database implementation on AS/400

    Hi, I am searching for a native database implementation for AS400. Either an open source or that can be bought and used or ( a database impl that can be achieved by doing some programming). Can i get some help regarding this. Thanks all, teja.

    Engineerteja5 pointsBadges:
  • seect records for current day

    I want to run a daily job and select records that have been added on current date, field is 6,0 P in YYMMDD format, how can this be accomplished without modifying daily?

    rmb115 pointsBadges:
  • validation

    i need to concatinate two fields and send to resultant field in rpg/400. one is numeric and other one is character. so please advice how can i

    Askt1140 pointsBadges:
  • Impact of upgrading the iSeries OS from V5R3 to V5R4 on Content Manager for iSeries

    Hi, We are upgrading the iSeries OS from V5R3 to V5R4.Will there be any impacts on Content Manager for iSeries (V5R3). I wanted to make sure if following supported on V5R4 1)Content Manager SW 2)Content Manager iSeries Client Conc User Lic 3)Content Manager iSeries Server 4)DB2 CM ONDemand for...

    Shichy20 pointsBadges:
  • Error code 10: Function sequence error using CPYTOIMPF on AS/400

    I am using the CPYTOIMPF function on an AS400 to copy from one data base file to another. I want to end up with a .CSV file format. It worked once but now I get the following error: Message Id: SQ999999 Error occurred in SQL Call Level Interface. A procedure call encountered an error. The error...

    AS400 - Ask the Expert485 pointsBadges:
  • Easiest way to swap drives on 9406-520 AS/400

    I have a 9406-520 with six (every slot full) 36 GB drives. We need to replace all six drives, with six 73 GB drives. What's the easiest, quickest way to accomplish this task? Thanks!!

    AS400 - Ask the Expert485 pointsBadges:
  • cl

    Hi 1.I need a cl code that will purge text files that are more than 3 months old...text files will be created with the date of creation suffixed to the filename... 2.If the above is not possible will i be able to create flat file members and purge those file members.

    0 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