• subsystems and interactive

    Hello, I am interested in moving soome devices to certain subsystems to run there jobs like querys. How can I accomplish this?

    deputy825 pointsBadges:
  • DB2 UDB for iSeries: Using CPYTOIMPF to trim blanks

    Mark is looking for an alternative to trimming blanks from the end of a record. He writes: "I would like to use the CPYTOIMPF command only if I can Trim Blanks from end of Record. I found out how to do this in FTP, but would really like to stay on this path and avoid FTP using Override Inputs. I...

    MichelleDavidson440 pointsBadges:
  • Need help transfering iSeries DB2 file to PGP Windows program

    Augusto needs your help. He writes: "I have an RPG ILE program that creates a file in my iSeries. The CL I am running controls that the file is ready to FTP to another location. To do this I have to transfer the file to a PC/Windows environment and then use a Windows-based PGP encryption program,...

    MichelleDavidson440 pointsBadges:
  • STRQMQRY problem

    I've used STRQMQRY command to pass a numeric company code to the query. Unfortunately, everytime I execute the query, it prompts me to enter the company number variable. I would like to execute the query without having to prompt. Could someone in the AS400 development world assist me with this...

    hbrooks10 pointsBadges:
  • CPYTOPCD filename length limitation

    Hi all, Am aware of the limitation of the filename (filename.ext) for CPYTOPCD command. eg: 12345678.123 (8chars and ext 3chars). Is there any command that I could use to have my filename as follows: AA12345678.txt or AA12345678 ? Or maybe additional step that I could insert into my CL after the...

    JechLee5 pointsBadges:
  • Possible to prevent program from being called if other program is active?

    Ray has two CL programs: PgmA and PgmB. He doesn't want users to call PgmB at a command line if PgmA is active and vice versa. Is there a way to handle this in a CL? Getting rid of the command line is not an option. Let Ray know if you have any suggestions. Michelle Davidson Editor Search400.com...

    MichelleDavidson440 pointsBadges:
  • Binding Directory Signatures

    I've been researching implementing ILE RPG in our office versus OPM style coding. I've read through the ILE RPG Reference as well as the Concepts and Programmer's Guides. I now have *SRVPGMs moderately well figured out and I've defined Binding Directories for compiling my *SRVPGMS. I discovered the...

    MadDogDing0 pointsBadges:
  • UPDPGM

    Hi, Is there a way to accomplish program updates automatically after module or service program changes. How can we find which programs are bounded with that module or service program?

    PANDUL0 pointsBadges:
  • program updates

    Hi everyone! I need to modify an RPG program that is called from a menu (a *MENU object). If I modify this program, do I need to recompile my menu?

    MelissaG20 pointsBadges:
  • as400 v4r5 to pc win2k pro ethernet connection

    i connect to my as400 150 via a mini-hub. pc IP adddress is assigned by as400 DHCP. i have installed a cable modem for broadband. pc IP address now being assigned by my ISP. my connection to as400 no longer works. can i reconfigure as400 to solve this problem? can i install a 2nd pc LAN card? can...

    Graham4000 pointsBadges:
  • how to read records from Externally Described file into data structure

    FAAAL21 UF A E K DISK F RENAME(REC:arec) D jkdata E DS extname(aaal21) c read arec jkdata after compiling, the error message is : RNF7701 20 The data structure is not allowed for the operation according to the book <ILE RPG Reference?SC09-2508-4?>, the above operation should be allowed. I...

    Gracema0 pointsBadges:
  • Line feed problems

    I am trying to create a file on the IFS and then ftp this to our client. He requires a line feed between certain fields and Cr/LF (x'25') at the end of the record. I do not have a problem with the end of record requirement. I am using codepage 437 on the as400 and tried x'15' to get only a line...

    Ronsurething3g0 pointsBadges:
  • QMF issue

    I have my QMF for windows version 8.1 Fix Pack 13, and I try to run this instruction INSERT INTO destination table SELECT * FROM origin table and every time I receive this error message: An error occurred while running the query. destrination table not valid for operation. (SQL code = -7008, SQL...

    Tiburonblanco80 pointsBadges:
  • CL/400 with Looping ?

    Hi friends, please help me, I have a looping on this CL ?, this statements below is correct ?, at the first time when the tape is unavailable I receive the e-mail, but on the second time when the tape is available I receive too this same e-mail. [strong]1800 IF COND(&MSGID = 'CPF6760') THEN(DO)...

    RBDSILVA550 pointsBadges:
  • IBM Client Access AFP Workbench viewer and Vista

    I have done a full load of Client Access onto a new Dell laptop with VIsta and all works OK but the AFP Viewer... get the message AFP WOrkbench Viewer has stopped...   How can this be corrected, if at all?

    BillW5 pointsBadges:
  • external procedures

    I have an RPGLE program which I define to be external procedure so that I can call it from a .NET program. When I execute it from iseries it works fine ans returns the parameter requested filled properly. When I call it out AS400 it runs succesfully but with no results. The problem seems to be the...

    GTseli5 pointsBadges:
  • Recommendations on learning CGI for RPG-backend website?

    Anyone have any good recommendations on (free) sites where I could learn CGI from examples, etc?  I'm going to be creating some interactive webpages for our company, and am told I'm gonna be doing it in CGI+RPG...so...better learn it! I am familiar with using APIs, and ILE RPG, and HTML+CSS and a...

    Koohiisan5,045 pointsBadges:
  • Procedure Pointer

    How to use a procedure pointer? Other than procedures where pointers concept can be applicable in AS/400?

    Kar425 pointsBadges:
  • How to convert the spoolfile to TIFF Little Endian in AS400 IFS folder with HPT API?

    Can anyone help to share the experience to convert the spoolfile to TIFF Little Endian in AS400 IFS folder. I have used HPT API with WSCST setting DATASTREAM=TIFF_G4, INITPRT DATA = '4D4D002A'X to covert the spoolfile to Big Endian successfully. However, I still can't figure out the way to...

    CLCL25 pointsBadges:
  • Having trouble with DB2/400 UDF returning a table.

    I've written a test RPGLE program (not a service program) to return a table that for testing puposes I'm returning 1 row and 1 hard coded return column that is defined as varchar. I'm building the return value by concatonating the input parameters. Anyhow I tried running it using interactive SQL. I...

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

Following