• iSeries duplicate field info

    I have query which has patient info and when I do summary dept charges and if they have 15 departments, the pat payments will show 15 times and the patient name will show on each line. How do I get this to show only once?

    kleemandebbie5 pointsBadges:
  • Changing variable value in calling RPGLE program

    How do I go about changing a variable value in calling a RPGLE program?

    KeithN25 pointsBadges:
  • SSL just hanging intermittently

    We recently performed our 7.1 upgrade (from 6.1) on a number of 400's. Since the upgrade, we are having issues with SSL communication over data queues in particular. It seems that the system simply stops sending for no reason (nothing in the logs to explain why). If the job involved in the socket...

    Markus15 pointsBadges:
  • [SQL0029] INTO clause missing from embedded statement.

    HI, I have written lots of RPG/ILE & CL & COBOL programs in iSeries. I never worked on procedures & UDF. Now I'm learning these. I'm trying to create a procedure. This is the code. It's compiled without any errors. While running I got the below error. CREATE FUNCTION SUS.REWT(p_value...

    HABBIE895 pointsBadges:
  • DB restore on iSeries

    Hi, I'm trying some other functionality on AS/400 server as creating some native SQL procedures. Now I completed & I want to take the backup of one schema / library. How to get the backup of this library? Will it be possible through the emulators or do I need to use iSeries navigator? Can...

    HABBIE895 pointsBadges:
  • What is a defective PTF in AS/400

    I can't find the answer from the cover letter. It would be great if someone explains for novice.

    rahsin20 pointsBadges:
  • How do we login to DST from SST in AS/400

    How do we login to DST from SST in AS4/00. It would be great if someone lists all the steps.

    rahsin20 pointsBadges:
  • FTP Server on iSeries

    I have a batch process which will create a IFS file from physical file and FTP to iSeries IFS Directory. FTP function will fail if the FTP server on iSeries is not running. I would like to include a statement in CL to ensure FTP server is running on iSeries before placing the file in IFS directory....

    Babs312260 pointsBadges:
  • Import data from Excel 2007 to iSeries

    How do I import data from Excel to iSeries?

    CHARLESG30 pointsBadges:
  • iSeries program message subfile

    I defined a message subfile in the display file with the help key defined. The messages I am writing to the message subfile all have second level text but depressing the F1 key does not display the second level messages. The screen does not respond to the F1 key.

    JCMauro5 pointsBadges:
  • Reading COBOL indexed file in SQL procedure in iSeries

    How do I read a COBOL indexed file in SQL procedure in iSeries?

    Bhusha40 pointsBadges:
  • How to get TAB DELIMITED file format in AS/400 flat file

    I am extracting some data into a flat file using DTF

    rav200025 pointsBadges:
  • Exporting Polish characters from iSeries

    V5R4. We have a client database that, for the first time, has to deal with Latin-2 characters. We have set up some sessions to use Polish configuration (code page 1153) and got around printing problems by having a separately configured printer. Now we have a problem with exporting the data to...

    Abby7075 pointsBadges:
  • iSeries 6.1 ‘IBMDA400.DataSource not registered

    I have a case where I installed iSeries 6.1 on user machine. we have a test machine with the iSeries installed too. They are both 32-bit machines. we are getting an error message The 'IBMDA400.DataSource.1' provider is not registered on the local I have reinstalled iSeries, application etc.

    todd092515 pointsBadges:
  • Best way if there is one to translate a well formed XML document from the DB to a document on the IFS

    We are trying to FTP well formed XML document from DB2 to the IFS. The data is standard ASN (Advanced Shipping Notice) for our industry (Textile manufacture) ... I've created an MQT so at the appropriate place in our process flow, I plan to REFRESH the MQT ... then use CL if such a command exists...

    GigiSarsfield10 pointsBadges:
  • RXFERPCB in iSeries access for Linux

    We used to transfer files using RXFERPCB tool in iSeries access for Windows (or cwbtf.exe ) but I can't find the tool in iSeries access for Linux. Is there any alternative for data transfer in Linux (besides odbc)?

    hamzahir85 pointsBadges:
  • How to retrieve the CHRID from an iSeries device description

    Does anybody know if there is an equivalent RTV version of DSPDEVD? I need to be able to retrieve the code page being used by a session (i.e which keyboard configuration) so that I can mark records accordingly. I have come across the QDCRDEVD API but I don't think it returns the CHRID. RTVJOBA...

    Abby7075 pointsBadges:
  • iSeries: Where is the object of a menu?

    Where is the object of a menu? Our ERP software vendor created some menus in our iSeries. For example, when I type GO IBSDI, the corresponding menu will be showing up. But I cannot find where the object IBSDI is located. I am the system administrator. I know the basic things of RPG, CL, CMD, DSPF,...

    brucema45 pointsBadges:
  • Retrieve Device Capabilities (QTARDCAP) API

    What's a sample CL program for iSeries API, QTARDCAP. Thanks!

    JuliusRP10 pointsBadges:
  • iSeries FTP Character change

    Sending a file from the iSeries box using FTP the file is being change from a bar to an exclamation mark. Why is this happening?

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