• sending message and variable to message queue using RPGIII

    Is there a way using RPGIII that I can send a message with a variable to a message queue?

    AS400Consultant0 pointsBadges:
  • List of Values in a SP Parameter

    I need to pass a List of Values parameter from a Crystal Report to a Store Procedure. 1) How do I define the Parm? and 2) How do I code the WHERE clause? Example: Result Sets 1 Language SQL Begin Declare C1 Cursor with Return For Select * From Table1 WHERE Field1 in('Value1', 'Value2','Value3',...

    Saratusthra0 pointsBadges:
  • New overlay software needed

    Nancy wrote in with this question recently: "We are upgrading from iSeries V4R5 to iSeries V5R3. We need to change our overlay software from Forms eXpress (which is no longer made, which means no support) to something else that will also work with the iSeries format. This should also transfer well...

    DebraTart0 pointsBadges:
  • Positioning a field depending on certain conditions

    Jana wrote in with this question recently: "Can I position a field depending on certain conditions? For example: If the condition is true, the field will be on (10,10). If false, the condition will be displayed at (15,10). Is that possible? If yes, please let me know how?" -- Debra Tart, associate...

    DebraTart0 pointsBadges:
  • SQL Select

    Does anyone know of a way to use SQL (embedded) to select only the 1st occurence of duplicate key records in a file. I have a file where there may be duplicate keys and I need the 1st occurrence of the key as the data following the key is the data that is needed.

    RPGCRAZY30 pointsBadges:
  • iSeries and PHP

    I am on a i520 running V5R3, I am thinking of using PHP to build some SQL query built web pages. I use PHP at home on Linux with MySQL so I think I have just enough knowledge to be dangerous. I was reading the RedBooks paper ?Bringing PHP to Your IBM eserver iSeries Server?. It appears to be...

    Verl8100 pointsBadges:
  • Variable Positioning of a Field in a display file

    Is it possible to set the postion of a field in a display file as per the condition without using two record formats? Like, if a said condition is true, the field will be displayed at (10,10), otherwise it will be at (15,10).

    Rajsekhar0 pointsBadges:
  • RRN in Query

    Does anyone know of a way to retrieve the rrn in a query and print it on a report?

    Fabrics0 pointsBadges:
  • data encryption/decryption

    We are in the process of building encryption/decryption applications. We are using the IBM QC3ENCDT AND QC3DECDT API'S. I've starting testing against our database using apprx 3000 records to encrypt and then decrypt. Out of that 3000 records, there are 17 instances of failure to decrypt to clear...

    Rigger0 pointsBadges:
  • Certain countries do not contain ASCII/EBCDIC characters. Now what?

    Alan wrote in with this question recently: "We are taking orders, via the internet, from all over the world. It has come to our attention that orders from certain countries (Turkey for example) do not contain ASCII/EBCDIC characters, so that when the order is fed into our system, they are not...

    DebraTart0 pointsBadges:
  • Retrieve file from customer’s server to our AS400 via FTP

    We have a customer that is placing a file on their FTP server for daily pickup. This file will have a varying name from day to day as the filename contains the date to make it unique. There is the potential that a day could be missed and we would need to retrieve multiple files during the same...

    Scottheffren0 pointsBadges:
  • how to get the location of the User Options (updated usinf PF18 from PDM)

    How can I access the Defaults information from Rexx / CL ? PF18 from PDM. I am looking for the values of Option file/lib/member. thanks Change Defaults Type choices, press Enter. Object library . . . . . . . *SRCLIB Name, *CURLIB, *SRCLIB Replace object . . . . . . . N Y=Yes, N=No Compile in batch...

    GonenSho0 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