• 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:
  • Workstation Entries vs Communication Entries

    I'm lagging with a clarity between Workstation Entries and Communication Entries. Can anybody explain me about which is meant for what ?to my understanding Workstation Entries are workstation devices for logging into the system for interactive work ?Communication Entries - ? this also do similar...

    qmaster1,675 pointsBadges:
  • We have one AS/400 printer of HP model

    We have one AS/400 printer of HP model, its printing first print and then stopping, every time we have to start the printer. Can you please suggest why this is happening, and how can we fix this.

    anusuiyasingh5 pointsBadges:
  • FLOWCHART Generator for COBOL

    Does anyone know of a product for generating a flowchart for existing COBOL code on the AS/400?

    RPGCRAZY30 pointsBadges:
  • Create Excel from AS/400 with multiple sheets

    I have a requirement to generate an excel from 2 different PF as 2 sheets in a single Excel file. I have created single sheet excel using CrtCsvDta command. Please help me to figure out to generate multi-sheet Excel from AS400.

    RamvishakRamesh2,505 pointsBadges:
  • AS/400 RPGLE

    0001.00 DBXLATER1 pr 50 0002.00 Dinpstr 50a 0003.00 PBXLATER1 b 0004.00 DBXLATER1 pi 50 0005.00 Dinpstr 50a 0006.00 Doutstr s 50a 0007.00 Dwork s 1a 0008.00 Dpos s 3s 0 inz(0) 0009.00 Di s 3s 0 inz(0) 0010.00 Dlower c 'abcdefghijklmnopqrstuvwxyz' 0011.00 Dupper c 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'...

    JSDHFKJHA335 pointsBadges:
  • Retrive Day from a field which holds date

    I have a file which has a field say FieldA which is of type 10A. It holds date in Format DD/MM/YYYY. Through an RPG program, I'm reading this file and when the Day in FieldA is a Saturday/Sunday I need to perform some set of logic. How can I extract the day from FieldA?

    RamvishakRamesh2,505 pointsBadges:
  • Future of AS/400 Admin and Support Jobs

    I have been working with AS/400 for the past 4 years. I know that IBM is shutting down its support for V5R4 now, and also that V7R1 is going to be the last version of OS that a power5 box can have. I think most of the customers may not be upgrading to a new physical box, I'm not sure but I think in...

    AdminAS40015 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