FTP error on site commands as400 to as400 transfer

I disribute files between a number of AS400's. As part of the procedure I send a remote command to restore the files. The remote command stopped working. The time difference between the two transfers (successful and not) was 2 hours and in the middle of a busy work day. No changes were made to...

KarenL20 pointsBadges:

Screen Size DSPSIZ(27 132 *DS4)

I have to have a screen configured at DSPSIZ(27 132 *DS4) b/c I need more space to put stuff. The company does not want expanded colums (hitting F10 to show more info). So this reduces the size of the text. I can see on the screen there is a little more room to make things bigger. Is there away to...

RonKoontz1,810 pointsBadges:

AS/400 display file

How to decide the position of Display file's constant variable dynamically. I wanted to decide the position in RPGLE program.

rajeshece1,230 pointsBadges:

Barcode scanning

We develop and use a lot of barcode scanning and reading applications. Some of the portable scanners in the warehouse allow the user to establish a session to the AS400 via a wireless bridge. Once signed on, the user is presented with the scanning application. Due to the fact that their scanners...

Floyd02320 pointsBadges:

Add in option to transfer from Iseries to excel2007

I cannot find where to add in the Iseries transfer from or to the Iseries in Excel 2007 running windows vista.

Jpnick5 pointsBadges:

STRSEU a member and display a message while edit is starting.

how can I run the command STRSEU and display a message to the user when the source is displayed. the message can be displayed in the TOP command line or anywhere else on the screen. thanks !

GonenSho0 pointsBadges:

How Do I Speed Up an ODBC Query of AS400 Table

We have a very small piece of software that queries our inventory. once you have selected a product (very quick table has 32k records) and you want to see who has ordered that product it takes minutes (usually about 5) to query that table (830k records) looking for suggestions about how to speed up...

Kerleyp0 pointsBadges:

PCI scan indicates finding default Apache directories on IBM System I5

Scan indicates find default  Apache directories such as /_borders/ /_overlay/ /_themes/ /banners/ ... Does anyone know where these Apache directories exist and/or how to stop access on IBM System I5.  This is a low threat item but is only thing keeping me from 100% clean scan?

STravis5 pointsBadges:

Fields not coming into program from screen

I've written a simple program that reads a record and displays the fields on the screen.  When I change a field for some reason it does not come into the program changed.  I put a debug after the exfmt and it shows the field on the screen as if I did not entering anything new...it shows the...

Harrisom15 pointsBadges:

Need help locating a print driver

Matthew is trying to add Panasonic copiers to his system, but he has no clue what print driver to use. Do you know or know where on the Web he can look? -- Michelle Davidson, editor, Search400.com

MichelleDavidson515 pointsBadges:

What is correct syntax for SQL for Maxrecords in OS400/DB2?

What is correct syntax for SQL for Maxrecords in OS400/DB2? We have a process automatically generating SQL code. However, our iSeries doesn't recognise the code it generates for maxrecords. Here are the examples of what I mean. The DB2 database seems happy with SELECT I1PHON,I1ACC,I1ACC1, FROM...

Peterax0 pointsBadges:

Utility to Print RPG Output Specs

Does anyone recall or use a utility that was used in "the old days" to print a listing of the O-specs in RPG II. The utility would review an RPG source member. It would then print a listing of what the output heading and detail lines would look like. It used "X"s and "9"s to show lengths of fields...

MikeBaker5 pointsBadges:

Setting a Network Printer to a Print Server, CRTDEVPRT

Hi,I need to CRTDEVPRT a network printer in AS/400. This *LAN printer is connected to a Server and I don't wish to vary on the device all the time so I need to create a permanent on device everytime the AS/400 subsystem is up.I managed to create one device description but somehow everytime after I...

Wxchoy0 pointsBadges:

QSH error “find: 001-2191 The ending ‘;’ character was not found.”.

I have attempted to use two approaches (from postings on Search400) in order to clean up the IFS. Both of these use QSH. I have a problem in that both iSeries machines at my disposal ignore the ";" at the line end, and return the error "find: 001-2191 The ending ';' character was not found.". An...

Clincha0 pointsBadges:

QSYS2/SYSCOLUMNS missing

When using ACCESS or EXCEL queries via ODBC to AS400 files (V5R1) I get an error "SYSCOLUMNS is missing" How can I rebuild it? Thanks

JPPLOU135 pointsBadges:

CPYSPLF with *FIRST option.

Hi all, I am try to use the CPYSPLF command to send spoolfiles to a file, but there are 2 spoolfiles with the same name. The command can not use the *last option because the 1st file has the data I need. So I need a CPYSPLF command that has the spool number option of *first, or a way to change the...

Kevin9990 pointsBadges:

startup program not autostarting when called in QCTL

I have a fully re-written startup program placed in my library,and for some reason if i pwrdwn/IPL or after option21 backup startup program does not autostart but if i call the program it works,the system value is set to look at mystartpgm in mylib but doesn't work instead gives message...

JediK45 pointsBadges:

How to operating with Multiple Member PF in RPG ?

I have a multiple member physical file and I want to operate(read/update/delete) with specific member in RPG. The member name for that PF need to be set at runtime depending upon from which program this rpg program is called. I am writing the sample code that I was trying, but it ends up with...

Inlog10 pointsBadges:

STRSEU macro – how to run Repetitive tasks on source members

I want to run few CHANGE commands on list of source members and add some logic to the CHANGE commands - e.g. if a source line contains 'AAA' then do CHANGE 'BBB' to 'CCC' I want to be able to run it in Foreground and Batch. For those of you who understand z/VM or Z/os - I am looking for something...

GonenSho0 pointsBadges:

rpg

We just upgraded to an iSeries box with 5.3. We were running 4.6. My RPG programs function properly until I recompile the program. Then I get an compile error 7073 regarding the length of a key field not equal. The compile shows BIN2 (and sometimes multiples) after the other key fields and I can't...

Kahenry0 pointsBadges: