• can strqmqry be run as remote command

    I am trying to run strqmqry via a dos/cmd ftp session. command: QUOTE RCMD STRQMQRY QMQRY(lib/qry) ... where ... are other options I followed various instructions posted here and on as400 tech sites on how to create the query. I was able to do all of that via a dos/cmd ftp session (except for...

    Bdatadigger0 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:

    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:
  • Single quotes around a CL variable

    The easiest way to do the above please

    Raddy590 pointsBadges:
  • Using S/36 object members (load and subroutine) on AS/400

    Hello, We are looking for IBM-supplied commands that will convert and/or run S/36 object members (load and subroutine members) to useable AS/400 system objects. The fact is that we lost the RPG source code from the S/36; so there is no source to compile on the AS/400. We look forward to your help....

    Masquita0 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:
  • Increase Size of Network Storage Area

    I have a client that needs to increase the size of the NWS being used with Windows Server 2003. It is a mapped drive for all users. Can anyone help with the steps required to change the size and maintain the drive mapping? They are on V5R3. Any suggestions will be appreciated.

    Dsheafl0 pointsBadges:
  • Looking for a Jacada User Group

    I am trying to determine if anyone has created a Jacada User Group or would be interested in starting a Jacada User Group. My company currently uses the JIS product.

    Sdhuhn0 pointsBadges:
  • Tools for DDS to DDL migration

    Hi, My Profile: I have a legacy DDS defined DB2/400 database and my IT staff are telling me that for true SQL/ODBC access we either need to migrate the database over to DDL defined tables or add unique indexes to the existing DDS structure. My Question: Do we really need to alter the DDS database...

    Newbie4000 pointsBadges:
  • MACPAC from V5R2 to V5R3

    We are looking to upgrade from V5R2 to V5R3 and we are a macpac SHOP. I understand that there are some required PTF's from MACPAC support that are required to go to V5R3. Has anyone gone to V5R3 with out these so called PTF's? Anyone have any idea what these PTF's are? What could MACPAC code...

    Rgoodson0 pointsBadges:
  • iSeries (AS/400) – Wanting to print to PDF using GhostScript or other software

    We have PostScript files on the AS/400 and we need to convert them to PCL for printing and also to PDF. Having much trouble getting Ghostscript even to compile on the AS/400, so I am looking for another "free" method to do what we need. Our software runs in a browser window connected to the AS/400...

    DougRaw0 pointsBadges:
  • Connect:Direct CDSND command

    Has anybody used this software to send data? We are sending a native file, and were wondering if there was a way to have the file converted to tab delimited on the CDSND command? Or, do we have to tab delimit it to the IFS and CDSND from there ?

    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:
  • Help with PCCMD and windows variable%UserProfile%

    hi everyone, i'm trying to help one of my friend who is using this command: STRPCCMD PCCMD ('rtopcb /s %userprofile%FAVCONVOconvo.tto') %Userprofile% is the environment variable which roots me to C:documents and settingsProfile name. We tried to put this variable into " " but it did not work...

    Fenril060 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:
  • 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...

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

    GHENDER215 pointsBadges:
  • CHGLIBL command in CLLE

    Trying to use a single variable with libraries concated from a file. When the command runs in the program I get XXXXX is not a valid library name. If I create a command string with the variable and use QCMDEXEC it works perfectly. The formating of the variable is obviously correct or the qmd call...

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

Thanks! We'll email you when relevant content is added and updated.