• AS/400 – (IBM i) FTP to port 990 (Secure FTP)

    Greetings,This is about FTPing from an AS/400 (aka iBMi, iSeries, Power6, etc.) to Port(990) - aka - SFTP - Secure FTP.Receiving an error when switching to a new target FTP site that requires using port 990. "-23 Certificate is not signed by a trusted certificate authority." Need to know how to get...

    Klipster5 pointsBadges:
  • Update sql400

    What is wrong in this statement

    Msatbh190 pointsBadges:
  • How to setup a new raid set with Hot spare on current configuration on AS/400 V5R4M0

    Currently we have V5R4 system with two raid sets(RAID5 active) hot spare is not enabled. We added an expansion unit with extra disks. I want to create another two raid sets with hot spare enabled. Could you please provide the details how it could be done from DST. I don't have navigator setup for...

    venkatktata300 pointsBadges:
  • IBM AS/400 Report

    How do I run a report in IBM AS400 software using payment type?

    pullikkal5 pointsBadges:
  • QADBXREF file attributes

    This is a challenging question: System Cross Reference file QADBXREF field name DBXATR = 'CL'. What is "CL" file attribute type for a file (not a program)? I know the standards PF, LF, AR etc but I have one file on the system that I cannot find on the system and it is the only one that is file...

    Modiyooch850 pointsBadges:
  • Error in compiling embedded SQLRPGLE in full free format

    Hi everyone - here's a question from a user in regards to SQLRPGLE: I have written some simple embedded SQL PGMS in COBOL in AS/400, compiled and run successfully. But I am not able to do so in full free format RPGLE. Here is the RPGLE code that doesn't compile. dcl-s sql_RCONAME char(20) ; exec...

    Michael Tidmarsh65,565 pointsBadges:
  • SETLL & READ

    Hello, I am a beginner with AS/400, I am developing a program to SCAN IN records, this record can be scanned multiple times (Duplicated records). But I need a code that search if the record exist, if exist a record then sum the quantity field of that record with the quantity entered if is greater...

    k3v1N24105 pointsBadges:
  • RPG stored procedures

    Remote client calls RPG stored procedure which invokes RPG program. I am then calling another program from initial program but when I make this call it does not return result set. Can I call one program from the called program?

    junekotey50 pointsBadges:
  • AS400 libraries used by DAS

    How do I find the libraries used by DAS to fetch data from the underlying AS400?

    Jailakshmi20 pointsBadges:
  • SFLRCDNBR – type of data?

    Hello. 20 years in 390 and I've just arrived in 400. I've an issue with a screen, giving a status 22 (dup key) writing the subfile. I see we have more than 10.000 lines to show, but the field in the SFLRCDNBR (CURSOR) only allow 4S definition. So when I add 1 after 9999, it becomes 0 again. I can...

    GonzaloGY5 pointsBadges:
  • Trying to get AFPRSC keyword to work

    Has anyone gotten the printer keyword AFPRSC to work to print a .jpeg file? I have not been able to get it to work.  I am just testing with a simple .jpg picture and a test print file with the one AFPRSC command on a record format. It seems to ignore the command and do nothing. I am on V7R1.

    aburkes15 pointsBadges:
  • Infor XA Modules list

    Hi, I would like to know about INFOR XA in almost all the below areas, your help in any of it is very much appreciated. Infor XA data dictionary Basic architecture Modules list Database mapping Any user guide

    as400dev655 pointsBadges:
  • Execute SQL Server Procedure from the iSeries

    I have an internal web address for a SQL Server application, where they want to run an iSeries stored procedure to connect to the SQL Server, call a SQL Server Stored Procedure, and receive resulting values back to the iSeries. Is this possible?

    sonorato15 pointsBadges:
  • Limit Query PF File Size

    When creating a PF thru AS/400 Query, would like to limit file size?

    Yuehan6835 pointsBadges:
  • Pasing Distinct values to UDFs in SQLRPGLE

    Hi, I need to execute a query like, select UDF(col2) from FILE.    col2 is not a unique field in FILE. I don't want to calculate UDF(col2) for same values.  FILE col1 col2 1      77 2      77 3       85 4       85 5       52 I need to handle this situation in query itself....

    xselvam20 pointsBadges:
  • How to read physical file and split to another physical file

    Hi, how to split physical file when we have first column is 1? that means page break. Than create new physical file automatically when split file.

    amiruladli9540 pointsBadges:
  • DB2 Triggers not always firing

    When EDI writes our order detail lines to the physical file which is triggered, the triggers are not firing. However, when entering detail lines through a screen the triggers fire and and all is well. Through journals I can see the EDI program is writing all lines in  probably less than 1 second...

    UARTJ220 pointsBadges:
  • Upload Excel file into AS/400

    Can an excel file be uploaded into AS/400?

    Tammyc15695 pointsBadges:
  • Setoff EndOfFile and Found built-in functions

    How can we manually setOFF and setON the %Eof and %Found built-in functions on RPGLE? (Without using reading opcodes)

    csuoaananth110 pointsBadges:
  • Configure AS/400 mirror machine

    We have an AS/400 production machine and we buy another to be the production mirror. Could you explain how it should be configured to be the exact replica of production?

    CJAVIER10 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