AS/400 Command Functions

AS/400 Commands Help

I need the short cut commands for the command line that allow me to do the following; Create a Table, Enter Record Data, Report Menu, Create a Report, Run Savings or Budget Report, and Return to DataBase Menu. Any help would be greatly appreciated thanks.

Numeric To Decimal Using %replace possibly

This should be an easy question. My brain is fried and can not figure this out. I'm close but I'm sure one of you has a good solution. Hours# is 5 position 2 decimal. Data coming in is 7 position numeric (NO decimal). The last 2 positions are the decimal positions. I need to get the data coming in...

How to check DB2 version in AS/400 green screen command line?

How to check db2 version in as400 green screen command line?

AS/400 navigation

is there any online material availble for as/400 screens navaigation

AS/400 command to find Object relationships

I have one object named "Pgm1" and i want to know in system in how many programs it may used or reffered ? Is there any command to find out the things like program name and all ?

iSeries

How do I know why our as/400 is running very slow? do you an specific command besides DSPSYSSTS or WRKACTJOB. thanks

runrmtcmd

i am running runrmtcmd from as400 v5r4 to another as400 v5r3 and get this: A remote host refused an attempted connect operation. Command did not complete successfully. what could be the problem? thank you

Objects transfer between AS/400 Environments

Hello, Can anybody briefly explain the process of identifying the active user sessions in a AS/400 environment and kill the sessions?

EXFMT

Hi, I have used two EXFMT Statements successively in my RPG Program as shown below EXFMT FOR1 EXFMT FOR2. FOR1 is SFLCTL and FOR2 is a record to be overlayed in FOR1 at the bottom. Now I want my program to display FOR2 immdediately after FOR1. But I could realise that only whent the enter key is...

AS/400 Command

Hey please let me know, if there is any single AS/400 command to kill all the jobs (Inactive/Active) in a given AS/400 Environment

Can anyone provide a list of "Best Practices" or recommended commands to secure from command line users...???

For Security and auditing purposes we need to secure potential harmful commands frok the few profiles which have command line access. I'm looking for a base list of commands or recommended best practices or a starting point / list. All insight is welcome

as400 rack config

how do i generate a rack config

EOF marker in text file from AS400 to PC

I'm a programmer/analyst using an AS400. We create multiple files daily on our AS400, copy them to PC documents using CPYTOPCD with TRNFMT = *TEXT, then upload them to other data processors. This works very well with most data processors but a few require that there be no EOF marker at the end of...

Enter key usage in load all sub file

When using load all sub file, after loading the records, when i press enter in the third page of my subfile display the control gets transferrred to the first record.How to avoid the control being transferred to the first record when the enter key is pressed?

How to Clear As400 810 drives of data before sending back to vendor

Need to send a rented machine back to the vendor, but want to format or scrub our data off before i do - what command can i use to do this?

AS/400 CPYTOPCD

I am using CPYTOPCD in AS/400 cl to copy an invoice spool file to a PC document. I then email the document to myself (as a test). My goal is to be able to email invoices, instead of printing them. I am using format PC data as *text. When I open my emailed document, the spaces have been randomly...

F9=Retrieve...

I'm creating a DSPF and want to put in some common AS/400 command functions, and one of them would be to hit F9 to retrieve the last command entered. How would I go about doing this? I'm using a mock command line input field and would be sending any commands via QCMDEXC. Any ideas on the F9...