• 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,410 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:
  • change Mocha 5250 keyboard setting

    In Mocha 5250 'Esc' key doesn't work in window 98.... i re installed mocha software, after also i got same problem...

    pdsathishkumar3,790 pointsBadges:
  • Sql Server Linked Server to iSeries

    Hi everybody, I get the following exception [Non-interface error: CoCreate of DSO for MSDASQL returned 0x80040154] on an iSeries configured as Linked Server in MS-Sql Server everytime I attempt to execute a query (Read Only !) from any PC in a windows Workgroup exception for the PC on which...

    Technet30 pointsBadges:
  • AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database.

    I have a AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database. Is there a API or some method for doing this. Help.

    Theraven35 pointsBadges:
  • Link Tables in AS400 to SQL Server 2008

    Has anyone set up a link server to their AS400 from SQL Server 2008/5?

    Jaymz69765 pointsBadges:
  • GMT timestamp

    I am creating an XML document using RPG and I need to output a timestamp in GMT format : YYYYMMDDThhmmssZ The date will need to end up looking like this: 20131003T210212.001Z. Can anyone tell me how to do that in an RPG program on the iSeries?  Thank you.

    DStaats25 pointsBadges:
  • STMF

    What is STMF in AS/400?

    beniwal5 pointsBadges:
  • Duplicate key on access path.

    I have a physical file PF1 with some key fields(K1,K2,K3). PF1 has say 5 logical files with different keys(K1,K2...K5) I am trying to update only a field of PF1(that field is not a key in PF1) using SQL(stored procedures) PF1 has unique keyword mentioned.But the update is not made on key fields....

    anuppdas105 pointsBadges:
  • Problemas despues de hacer un ENDSBS

    Amigos, tengo el siguiente problema, cuando bajo los subsistemas con un ENDSBS o un ENDSYS y despues levanto los subsistemas con un STRSBS QCTL no me levantan las pantallas verdes, la solucion que encontre fue dar IPL pero necesito que me ayuden a saber como puedo solucionar este tema sin tener que...

    nahuazky5 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