• iSeries query: Compare two fields in one file

    Try to do a multiple select statement and then compare the results of that statement. See below: SELECT "T16.APAR".P._PARCEL_NR FROM QS36F."T16.APAR" WHERE "T16.APAR".P_PARCEL_NR NE "T16.APAR".P_PARCEL_NR (SELECT "T16.APAR".P_PARCEL_NR FROM QS36F."T16.APAR" AS "T16.APAR" WHERE "T16.APAR".P_YEAR =...

    lorit365 pointsBadges:
  • Determine if a submitted job has completed

    Hello ALL --- I have a CL program that executes a command which calls a CL utility program. The utility program submits a job that involves the building of a save file. The original CL program will then restore the contents of the save file into a library and obviously must wait until the submitted...

    mikechance81275 pointsBadges:
  • WRKOUTQ CMD key F20

    A user has a menu option to display an output queue. When I hit F20 in this option, it displays the Work with All writers screen. When she hits F20 it displays the work with printers screen (like F22 also does). She confirmed that the same thing occurs on different PCs. She also checked the...

    Bradenton5 pointsBadges:
  • User space size

    Hi, is the size of user space auto resizable? I tested creating a user space with the initial length to 1 QUSCRTUS(userSpace, /* User space name and library */ "temporal ", /* Extended attribute (QUSLOBJ) */ 1, /* Size of the user space */ &spaceInit, /* Space initialization */ "*ALL ", /*...

    GraceP415 pointsBadges:
  • Object use

    Is there a way to identify who is using any type of object (example a DSPF, PGM, FILE) even though the object is not locked or journaled ?

    aderene180 pointsBadges:
  • rslvsp function returns null

    Documentation for rslvsp points: "A null pointer value means the object was found in a machine context." But I verified that my user space was created successsful rslvsp(_Usrspc,"userspace", "QTEMP", _AUTH_ALL) If it is found in machine context, how can I resolve to it (Have a pointer to the user...

    GraceP415 pointsBadges:
  • IBMDA400 Date Issues

    The IBMDA400 provider seems to convert dates to character values even when using keyword "Convert Date Time To Char=FALSE". This does not happen with the ODBC driver or IBMDASQL provider. I'd be okay with IBMDASQL except IBM states it only works the SQL statements. I'd be okay with ODBC driver...

    Craig Hatmaker1,700 pointsBadges:
  • Access to DB2 from Oracle

    I want to access the DB2 database on iSeries from Oracle 11 (read and write). What is the best way?

    andiqu15 pointsBadges:
  • How to transfer an iSeries file

    How to transfer the file from one iSeries to another iSeries?

    ankit2002770 pointsBadges:
  • Writing CL to run programs, need to monitor for program completion: IF/THEN?

    I'm trying to write a process that will start a program, monitor it for completion and decide to either proceed to the next program if goes END OF JOB, or display a message and terminate the running CL if the program not have successful END OF JOB. I have written a CL that will run all the programs...

    EagerNewb50 pointsBadges:
  • Send mail attachment to iSeries IFS

    Is there a way to be able to automatically send an email file attachment from Lotus Notes to iSeries IFS folder.

    dino624545 pointsBadges:
  • Work management on ISERIES – for IBM supplied subsystems.

    We are accessing data stored on our ISERIES via COGNOS. I am thinking part of our performance issues is related to the IBM supplied subsystem QUSRWRK. It is currently only using base pool and non db page faulting is high for the DDM server job. Is it appropriate to use a storage pool (in addition...

    SMOO4310 pointsBadges:
  • Anyone familiar with 4D front end to DB2 database

    Has anyone had experience with using 4D (4th Dimension) as a front end of IBM DB2 on iSeries? I've tried FTPing a database, it was downloaded to a PC into Excel, Excel had no problem retaining formatting...however I can't get DB2 to maintain the formatting and I used DDS to to generate the physical...

    Gmil494365 pointsBadges:
  • Advise in shifting from Iseries to PL/SQL developer

    Hi, Currently, I am working in Iseries and have 3.5 years of experience as RPG and CL developer. Now, because of the shrinking usage of Iseries I am planning to shift my profession as PL/SQL developer. Could anyone advise whether it will be a wise decision to continue my profession in Iseries or...

    asastr0915 pointsBadges:
  • Accessing FTP site from iSeries

    My client has given following information to access their FTP server. How can I do this from AS/400 FTP Client?........................ The external client/vendor will access the FTP server by following the instructions below using the SSL capable FTP client of their choice: •...

    sim400305 pointsBadges:
  • Problem with overlays while printing to ASCII printer

    Hi There, I created an overlay using Inforprint 300dpi AFP driver and then attached it to a printer file using the DDS keyword OVERLAY. Now after I called the program the spool file was generated , I used AFP work bench Viewer on 'iSeries Access for Windows' to view the spool file and it showed...

    raavibhanu15 pointsBadges:
  • Sending double byte characters from iSeries to Websphere Message Broker

    Hi We are having problems sending double byte characters (Chinese) in an XML string via MQ to Websphere Message Broker. We have been advised to use CCSID 1208 as that is a Unicode character set. The XML string has 'encoding = "UTF-8"' set and we have also set mqmd.mdcsi = 1208 in the RPG program....

    tonyflavell10 pointsBadges:
  • Field color in Display File – Device type 5251 vs 3477

    It started when I noticed that sometimes my displays didn't show the color that I specified for some fields in the screen. Client Access is the interface between Windows and the iSeries. After investigating many usual suspects, I found the culprit in the assignation of device type to my interactive...

    MarcosAlejandro130 pointsBadges:
  • Operation not allowed in a job running multiple threads from SQL RPGLE

    Hi, I am running SQLRPGLE on V7R1. The program takes entries from file and emails. The program on high level does following steps..........: 1. Fetch Record from File, ............ 2. Convert Spool file to PDF and puts into IFS, into Root/Folder1, ......... 3. Copies PDF file from Root/Folder1 to...

    sim400305 pointsBadges:
  • Problems with Expat in RPGLE

    Posted on behalf of MelissaG: I have an RPGLE program that receives an XML character string generated using CGIDEV2, and it is supposed to parse this XML in order to print those values in a spool file. My problem is that the RPGLE program that parses the XML sends an error message like 'Parse error...

    Margaret Rouse1,555 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