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

    sivakesava255 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:
  • Update Data SQL Server From AS400

    Hi, some help me. I want to write data to SQL Server from AS400 in RPGLE. Some have code for make this. Thanks for advance.

    JLH5 pointsBadges:
  • Java Code to Copy AS400 file to SQL Server database/table

    I need Java code to access and copy an AS400 file to SQL Server database/table. It must also copy a specific amount of records from the SQL Server side. 

    IRob5 pointsBadges:
  • SQL Syntax issue via Free-Form RPGLE

    I'm having difficulty with a select statement.  As below, it works .  If I remove the '//' comment-out tags, it doesn't, so obviously there's an issue with those statements.  I'm trying to populate an output 3-char field with either Yes, No, or N/A.  The Y/N comes from the contents of a field...

    Eric Witham690 pointsBadges:
  • Delete duplicate members from a physical file using RPGLE

    Hi, could someone please help me with the code to delete duplicate records from a physical file. Please post with the full code.

    AS400dot5 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