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

    Rmason335 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:
  • CPYTOIMPF – SQL ERROR

    I am using CPYTOIMPF to copy AS400 database file to another AS400 database to get the receiver file in .csv format to download to a pc folder. I get a SQL error " Error occured in SQL Call Level Interface. Function sequence error." Does anyone know what this error means? I know that my receiver...

    Ann45 pointsBadges:
  • Embedded SQL to process ALL members

    Hi, I'm trying to get an RPG with embedded SQL to read all the members in a file. I know I used to be able to do this with an OVRDBF command with *ALL specified for the member, but this doesn't seem to work anymore. In the joblog I get a CPF4268 message which says the file has no members or is not...

    Gilly40023,730 pointsBadges:
  • How to create a Data Area with RPG for storing variables

    How to create a data area using an RPG.I need to create a data area and store some values in it.The value to be stored are also retrieved from the same RPG.(that is from screen variables)

    0 pointsBadges:
  • SQL Stored Procedure

    I need to create a stored procedure with an input parameter of member name to create an Alias, select all the data in the member then drop the Alias. This procdure wil be called by 3rd party software using an odbc connection.

    Markpg155 pointsBadges:
  • Need a CL to be written

    Hi I need a cl to be written;The requirement is as follows There will be files created with naming convention INV20081219 or members within files. Now i need a program that will automatically delete files that are more than 3 months old.

    0 pointsBadges:
  • Using the SQL IN clause in SQLRPGLE

    Can I use a variable with the IN clause in an iSeries SQLRPGLE program? Can I use: WHERE CUSTID IN(:CUSTNUMS) Instead of: WHERE CUSTID IN(145,1600,352)

    PWMASI5 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