• Using AS/400 SQL to replace a variable string

    I need to do a scan and replace in a flat file. File has one field 80 characters long. Possibly one or more of the records in the file contain a specific value, such as '%ABC%' and I want to update the record replace ABC with XYZ. This value could be anywhere within the record. I do not want to...

    CharlieBrowne41,380 pointsBadges:
  • How to Test for Numerics in AS/400

    I need to test for Numeric. I have to check, If a variable contains Numeric values. I wanted to use TESTN opcode, but people are saying not to use it; as it does not work properly some times. Is there any other alternative to this? Has anybody done this before? Any help would be of great help....

    svankipu620 pointsBadges:
  • How to export data from AS/400 in Excel

    Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

    Itriconewbie5 pointsBadges:
  • Sort file based on a key in another file

    Here is a scenario. I have a balance file which has account number and balance in it. I want to create a report out of it. The report should looks like this, it shows the Rank,(Rank 1 means account with highest Balance) Account number, and Balance order by Rank. There is another Account master file...

    RamvishakRamesh2,505 pointsBadges:
  • File is not moving in folder

    Hi, I want to move a file which has a invoice no and create a sub-folder in /hame folder using the invoice number as the folder name. for example: NAMEIN=/home/Indicium/20202021.pdf Nameout=/home/Intellichief/20202021/20202021.pdf PGM PARM(&NAMEIN &NAMEOUT) DCL VAR(&NAMEIN) TYPE(*CHAR)...

    97834441841,355 pointsBadges:
  • ‘convert as/400 dates ’0001-01-01′ to SQL Server 2000′

    How do I convert ISO dates of '0001-01-01' to SQL Server 2000 Datetime format?

    Jld10 pointsBadges:
  • ODBC connection to the SQL server from the iSeries

    Is there a way on the iSeries to establish an ODBC connection to the SQL server?

    a1maida150 pointsBadges:
  • AS/400 CL – PRTJOBRPT

    Hi, I'm trying to automate the PRTJOBRPT using CL. The printed report will be copy to PF and send email directly to audit team. I'm having problem with the member (*mgtcol). We all know that *mgtcol is created daily (auto-create), how can I get or retrieve the latest member of performance data? Is...

    iSeries40060 pointsBadges:
  • Help regarding RPG programs

    I want to do a project in RPG, here is my concept. I have a specific product which was containing some functionality and this product was used by some customers. I want to code a tool which will show the info like Full customer info (which functionality were used by customer). Functionality info...

    sivakesava280 pointsBadges:
  • Date validation RPGLE

    Hi, I try to validate the date field but the Indicator sets on for both valid and invalid. Please advice. D datevalid S 8A inz('20131225') D dateINVAlid S 8A inz('99999999') * /free test(DE) *ymd0 datevalid; if %error() ; dsply 'Error!' ; endif ; /end-free * C *YMD TEST(D) datevalid 44 C N44'valid'...

    as400dev480 pointsBadges:
  • Adding disk drive to AS/400 9406-520

    I'm looking for the requirements for adding 2 ,#4326, 35.1 GB disk units to my AS/400. I have the open slots and I need to know if I can user install these units. The unit is RAID 5 DASD.

    ken0611425 pointsBadges:
  • USRPRF disable often after enabling.

    What does this mean: USRPRF disable often after enabling.

    07091988ramya55 pointsBadges:
  • Modernization for a COBOL/400 shop

    There is a (another) study going on to try to determine how we should best "modernize" for the future. We have been a COBOL and CL shop for more than 30 years, but the "dinosaurs are dying off", kids in school don't learn COBOL anymore so thus another study...Someone selling XYZ servers would...

    LetItBe260 pointsBadges:
  • COBOL DB2 program for reading a text file and comparing with one of the DB2 table

    I need a sample COBOL DB2 program in which I take the data from text file consisting of order numbers and comparing with orders number in order table in db2, the data not matched to be stored in some other file?

    bestkapil225 pointsBadges:
  • Test for date in *DMY format in RPGLE

    I have a file field(InpDate) which is of length 6A. It is assumed to have value in ddmmyy format. I am extracting the day month and year part of it using Day = %Dec(%Subst(InpDate:1:2):2:0) Month = %Dec(%Subst(InpDate:3:2):2:0) Year = %Dec(%Subst(InpDate:4:2):2:0) Since am doing a %Dec, I want to...

    RamvishakRamesh2,505 pointsBadges:
  • Calling RPGLE Procedure returning 10 length char value from Java

    Hi, I need to call a RPGLE procedure which is in a NOMAIN module and returning a 10 char. Example of the procedure I need to call is as follows: PRtvChgDesc       B                   Export dRtvChgDesc       PI            10 d  P_Name         ...

    ROYB95 pointsBadges:
  • NAME of a TEXT FILE IN COBOL ILE

    I have a text file text01 member of QDDSSRC and a COBOL ILE member of  QCBLESRC. What is the name I need to write in the SELECT IN-FILE ASSIGN TO because I wrote DISK-TEXT01 but when I open it I have the error 35?

    domhaine5 pointsBadges:
  • Position to nN+1 record and read sequentially the next n records?

    There is a large file, say 1M records. I want to process some 1000 records each time. Is there a way to position to the 1001st or 2001st records and then read sequentially the next 1000 records?

    TonySW10 pointsBadges:
  • as400 db2 to sql server 2005

    how can we take a db2 backup tape and dump to a sql server 2005 database?

    Mingo5 pointsBadges:
  • AS/400 MQ channels

    Hi all, can you please help to get the last sequence number of MQ channels in a programmatic way. There is command WRKMQMCHST which will tell us the last sequence number but this command is not producing any spool report. So please help to get the sequence number of MQ channel. I want to get the...

    frmdeva365 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