• Using keyword IN in Dynamic SQL WHERE clause

    In an RPGLE program I am using embedded SQL. I would like a Where clause that says: WHERE BankCode in (:BankList) and I want BankList to be a dynamic list of banks selected by the user. BankCode is defined as 4,0 decimal and BankList is defined as Character since it may have several banks (1000,...

    naturegal0 pointsBadges:
  • Certification in RPG

    I am planning to get certified in RPG from IBM. Is it a good idea? Could you suggest some self study material please. Thanks

    ObjectAuthority0 pointsBadges:
  • RRN Chain to subfile in RPG-Free

    How does one find whether a record is found or not while chaining with RRN to a subfile? Indicators are no good, %Found and %Eof are not valid for subfiles?

    ALichten0 pointsBadges:
  • Run PC command from CL program

    Is it possible to run a PC batch file from a CL program, and, if so, how? Thanks.

    Msadmin0 pointsBadges:
  • Creating logical file keyed by partial field.

    We have a need to create a logical file based on a substring of a particular field as opposed to the entire field. I know it can be done using 'CREATE VIEW' within SQL. Is there a way to do it within DDS specs? I appreciate your help!

    Dantheband0 pointsBadges:
  • TimeStamp created in RPGLE and written to physical file is not in 24 hour format

    I have a program that writes out a record when ever a request is fulfilled. The record has a timestamp to know when it was filled but when ever the time stamp is written in the afternoon or evening the time stamp does not write 24 hour timestamp. Say it was filled at 3:14 PM, the timestamp should...

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