• How can I find on which files a program has been attached as an external trigger?

    I have a "generic" rpgle program that can be attached to any physical file as a trigger. And so it has been, many times.. Is there a utility that I can use to find exactly what files have this program attached as a trigger? Or some table where I can look? Thanks! Kevin

    Beercheck0 pointsBadges:
  • Reg Data extraction from one environment to another

    Hi Consider i have testing library and development library in my library list. Say for eg, given a shipment ID i need to copy all the relevant data from testing enviroment to development environment. Since the file objects reside in testing and dev environment how will i be able to fetch data from...

    Rafiqm0 pointsBadges:
  • Printing a barcode from the O specs of an RPG program

    Specifically, I need information on how to print a barcode from the O specs of an RPG program. I found an example to print a barcode by passing hex in the O specs, but I didn't understand the how to part. I realize this is an older way of printing a barcode as I am aware of how to use the DDS and...

    Wooting0 pointsBadges:
  • Getting job log info into RPGLE program

    I'm looking for an easy way to get "error" information from the job log into my RPGLE Program. I'm "monitoring" a CHAIN to a file for an "unable to allocate" error, and would like to pop-up a window to display who is locking the record. How do I go about doing this? Thanks

    MMAGuy85 pointsBadges:
  • Using an array in embedded SQL in RPGLE

    Is there a way to specify a host array element in a where clause in embedded SQL? This is what I am trying to do: C+ Where TkPart01 = :odPart(01) C+ and TkQty01 = :odQty(01) C+ and TkPart02 = :odPart(02) C+ and TkQty02 = :odQty(02) There's more to it than that but that should give you the general...

    Vatchy1,410 pointsBadges:
  • MS SQL Server 2000

    Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

    Sudh2k0 pointsBadges:
  • CPYTOIMPF Nightmare

    I am using this to transfer data from the S400 to the IFS. The data has to be tab delimited. I am the sending the data to a UNIX box. the problem is I am a getting a carriage return at the end of fields - and it appears to be random. Here is my command CPYTOIMPF FROMFILE(*LIBL/IOBEXT) +...

    Raddy590 pointsBadges:
  • OPNQRYF’s MAPFLD

    I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined this way...

    JohndeCoville0 pointsBadges:
  • Display Footers in Subfiles

    Hi, I have a dual display subfile. I am able to do display the screens allright but it's the footer record i am unable to display at all. I have made sure that the second subfile record doesn't overlap my footer area (by footer, i mean the area where i want to display my Function keys). I have used...

    Me2learn0 pointsBadges:
  • RPGLE & SQL

    I am writing my first SQl in an RPG The statement I am using is: UPDATE AQUA20/XNMSGX SET ISTS = 'd', ISTATE = 'a' WHERE ISTS='C' and ISTATE='C'and idate<20010501 1. Does the statement look okay 2. Can I, and how would I, use a variable in the statement - the date I am checking against will...

    Raddy590 pointsBadges:
  • QDLS and the IFS

    How can I access the QDLS library in a CLLE program? I am using the copy database to an optical file command and CLLE program (CPYDBOPT). I created a folder called "Optical". I can see this folder using iSeries Navigator. I don't see a QDLS library on my iSeries when use I use the work with...

    Rick1020060 pointsBadges:
  • Subfiles – RtnCsrLoc

    I understand that you can use the RtnCsrLoc to retrieve the cursor position and field name. However, is there a way to force values into RtnCsrLoc? This would be best stated with an example. I have 2 fields on my subfile control record. The first Payment type and the second credit card number. My...

    Molly24150 pointsBadges:
  • Learning FTP from the bottom up…

    Are there any good resources available on the web that can give me the basics (most often used/needed) FTP commands. Or, can anyone give me the details of the most commonly used commands. I've got to strart doing some FTP'ing in this new job.

    Raddy590 pointsBadges:
  • Query Security

    I have written several queries which I don't want others to change. I edited the authority for this query and changed the object authority to *EXCLUDE for user *PUBLIC and all other authorized users. However, users are still able to access and change my queries. Why? What do I need to do?

    GHENDER190 pointsBadges:
  • calling an external web service from RPG

    Our web guys have created a web service that we need to access from an RPG program. we have the URL http://999.99.99.99/mywebservice.asmx data will be passed to and from via SOAP format. Martin.

    MartinSchloesser0 pointsBadges:
  • Monitoring VRYCFG

    Hello, Well, I need some advice because I'm one more time a little bit lost in my learning of AS/400 programming. Here is what I'm trying to do: Everytime that the AS/400 receives a VARY OFF on 1 specific device, I would like to execute a program after the VARY OFF is complete. I was thinking of...

    PierreLG45 pointsBadges:
  • ISO date Formats and Move

    I need to do 2 things . Perform day additions and deductions on a date format yyyymmdd. Am I correct in thinking this is *ISO format? And is there any example code of arithmetic? 2. Also I have been advised on RPG4 not to use MOVE to change char to dec. Is this correct, and what alternatives are...

    Raddy590 pointsBadges:
  • The server with this database is no longer responding

    I am trying to access a link in a Database on the LNS through the lotus client but it is throwing the error message 'The server with this DB is no longer responding Should notes switch to a replica on other server'. The link is accessible from a other client.I have shutdown the firewall also....

    Prasanna400 pointsBadges:
  • RPGLE Interactive Debugging

    I am debugging an interactive RPGLE program using STRDBG. I am doing a BREAK line# WHEN a certain condition occurs. Is there a way to break when multiple conditions occur? I tried using AND but I got a syntax error.

    GHENDER190 pointsBadges:
  • Api usage

    Hi! Any one that knows where (in which library) to find the CEERARN0 api? The crtpgm command can't find the module. Best regards! //MikEhr

    MikEhr0 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