Select only updates/deletes/changes to files using query
How can I Only select updates/deletes/changes to files and dont want I/O type access using query
Answer Question
| June 24, 2011 3:12 PM
AS/400, AS/400 administration, AS/400 Query, I/O devices
How can I Only select updates/deletes/changes to files and dont want I/O type access using query
Answer Question
| June 24, 2011 3:12 PM
AS/400, AS/400 administration, AS/400 Query, I/O devices
How to Monitor File Changes done thru STRSQL
I need a solution for monitoring file changes done by programmers using the STRSQL from a command line for SOX purposes.
Answer Question
| June 20, 2011 6:44 PM
AS/400 administration, AS/400 SOX, Command line, SOX, STRSQL
I need a solution for monitoring file changes done by programmers using the STRSQL from a command line for SOX purposes.
Answer Question
| June 20, 2011 6:44 PM
AS/400 administration, AS/400 SOX, Command line, SOX, STRSQL
AS/400 query join
I have 2 files I am joining. The primary file is an employee master. The secondary is a history file with the employees time punches. Using a type 1 join it works fine. The user wants a change to the query to show the employees who did not punch in for a specific day as [...]
Answer Question
| December 19, 2011 11:38 AM
AS/400 administration, AS/400 Query, AS/400 Query Select Records, V6R1
I have 2 files I am joining. The primary file is an employee master. The secondary is a history file with the employees time punches. Using a type 1 join it works fine. The user wants a change to the query to show the employees who did not punch in for a specific day as [...]
Answer Question
| December 19, 2011 11:38 AM
AS/400 administration, AS/400 Query, AS/400 Query Select Records, V6R1
AS/400 symatrax telnet
how can i make as400 symatrax telnet system display the sign on srceen
Answer Question
| June 7, 2011 12:56 PM
AS/400 administration, AS/400 command functions, AS/400 Display File, Telnet
how can i make as400 symatrax telnet system display the sign on srceen
Answer Question
| June 7, 2011 12:56 PM
AS/400 administration, AS/400 command functions, AS/400 Display File, Telnet
Create savf on pc to download to AS/400?
how do you create a .savf on the pc to download to as400
Answer Question
| June 30, 2011 11:32 PM
AS/400, AS/400 administration, Excel to iSeries, SAVF
how do you create a .savf on the pc to download to as400
Answer Question
| June 30, 2011 11:32 PM
AS/400, AS/400 administration, Excel to iSeries, SAVF
AS/400 520 c1001020
Hi I just bought an AS/400 520. I started and I can see my machine is sitting around this SRC c1001020 which is at the very beginning. Can someone help me. The console is connected at port 0. No light is on on the front of AS/400. I want my machine to start. MK[Br _extended=”true” />
Answer Question
| June 15, 2011 12:02 AM
AS/400, AS/400 administration, AS/400 performance, SRC C1001020
Hi I just bought an AS/400 520. I started and I can see my machine is sitting around this SRC c1001020 which is at the very beginning. Can someone help me. The console is connected at port 0. No light is on on the front of AS/400. I want my machine to start. MK[Br _extended=”true” />
Answer Question
| June 15, 2011 12:02 AM
AS/400, AS/400 administration, AS/400 performance, SRC C1001020
AS400 Triggers
I have some triggers set up on our AS400. A record gets written to a physical file each time one of the triggered files has an add, update or delete performed against it. The problem is that we have a few batch programs that do not write to the trigger file when run (and update [...]
Answer Question
| May 27, 2011 7:58 PM
AS/400 administration, AS/400 Parameters, AS/400 triggers, CL batch program, TRIGGER, Trigger failure
I have some triggers set up on our AS400. A record gets written to a physical file each time one of the triggered files has an add, update or delete performed against it. The problem is that we have a few batch programs that do not write to the trigger file when run (and update [...]
Answer Question
| May 27, 2011 7:58 PM
AS/400 administration, AS/400 Parameters, AS/400 triggers, CL batch program, TRIGGER, Trigger failure
Graphic to text conversion in AS/400
i have a program in that program graphic characters are there how to convert graphical character to as400 characters using cl program only.how is it possible in as400
Answer Question
| May 26, 2011 2:29 PM
AS/400, AS/400 administration, CL Program, CL programming, Conversion functions
i have a program in that program graphic characters are there how to convert graphical character to as400 characters using cl program only.how is it possible in as400
Answer Question
| May 26, 2011 2:29 PM
AS/400, AS/400 administration, CL Program, CL programming, Conversion functions
AS/400 Signon screen problem
I am using DELL VOSTRO 1015 Laptop. When I am trying to enter my login ID in the AS400 signon screen it is taking numbers for whatever character / number typed in. For ex: If I typed in ‘TTSS’ it will enter as 1234, again if I clear it and try to re-enter then it will [...]
Answer Question
| May 18, 2011 5:25 PM
AS/400 administration, AS/400 login, AS/400 sign-on screen, AS/400 signon
I am using DELL VOSTRO 1015 Laptop. When I am trying to enter my login ID in the AS400 signon screen it is taking numbers for whatever character / number typed in. For ex: If I typed in ‘TTSS’ it will enter as 1234, again if I clear it and try to re-enter then it will [...]
Answer Question
| May 18, 2011 5:25 PM
AS/400 administration, AS/400 login, AS/400 sign-on screen, AS/400 signon
Export AS/400 database to new website
how would we go about exporting our as400 product database of 2,000 items (without images – only image name or link) to our new website? we would likely be using a Joomla content management system (CMS) website but would use standard HTML if we had to.
Answer Question
| May 18, 2011 1:51 PM
AS/400 administration, AS/400 database, AS/400 database administration
how would we go about exporting our as400 product database of 2,000 items (without images – only image name or link) to our new website? we would likely be using a Joomla content management system (CMS) website but would use standard HTML if we had to.
Answer Question
| May 18, 2011 1:51 PM
AS/400 administration, AS/400 database, AS/400 database administration
Design 2 Column DFU Screen
I have 37 fields in the data records and I would like to display input dfu screen using two columns as input.
Answer Question
| May 12, 2011 6:15 PM
AS/400 administration, AS/400 Data Reports, AS400 DFU, DFU
I have 37 fields in the data records and I would like to display input dfu screen using two columns as input.
Answer Question
| May 12, 2011 6:15 PM
AS/400 administration, AS/400 Data Reports, AS400 DFU, DFU
SAP on Systemi (AS/400)
Hi , i want to know SAP licences on the production Box are valid for DR BOX or we need to apply seprate Licences for DR. Are there any Licences for Development Enviroment ?
Answer Question
| June 30, 2011 6:50 AM
AS/400 administration, AS/400 applications, SAP, System i
Hi , i want to know SAP licences on the production Box are valid for DR BOX or we need to apply seprate Licences for DR. Are there any Licences for Development Enviroment ?
Answer Question
| June 30, 2011 6:50 AM
AS/400 administration, AS/400 applications, SAP, System i
System 36 resources
I’ve inherited a true system 36 last summer and need some advice. I’ve got a consultant on hand to perform the migration to a new LPAR running V5R4. I’m not concerned about getting the database files and program libraries migrated and restored. The day-to day administration and maintenance is what I’m worried about. I haven’t [...]
Answer Question
| May 2, 2011 5:53 PM
AS/400, AS/400 administration, LPAR, System 36, V5R4
I’ve inherited a true system 36 last summer and need some advice. I’ve got a consultant on hand to perform the migration to a new LPAR running V5R4. I’m not concerned about getting the database files and program libraries migrated and restored. The day-to day administration and maintenance is what I’m worried about. I haven’t [...]
Answer Question
| May 2, 2011 5:53 PM
AS/400, AS/400 administration, LPAR, System 36, V5R4
Error Messages on AS/400
Dear All, Friends i want to know how to show all error messeges using AS400. For example criticle messages, other messages. Regards, Tahir
Answer Question
| May 2, 2011 7:06 AM
AS/400 administration, AS/400 error messages, AS/400 errors
Dear All, Friends i want to know how to show all error messeges using AS400. For example criticle messages, other messages. Regards, Tahir
Answer Question
| May 2, 2011 7:06 AM
AS/400 administration, AS/400 error messages, AS/400 errors
How to display error message without using error message but from complete file time array
DEAR, HI I HAVE TO DISPLAY ERROR MESSAGES LIKE WHEN I ADD EMPLOYEE CODE,MY PROGRAM SHOULD DISPLAY ERROR MESSAGE AS “EMPLOYEE ALREADY EXISTS”… ONE THING I SHOULD NOT USE ERROR MESSAGE OR ERRMSGID SIMPLE DISPLAY FILE… NOT USING SUBFILE… THEN MAINLY I AM USING COMPILE TIME ARRAY as err1… VALUES LIKE ** RECORD ALREADY EXISTS [...]
Answer Question
| March 22, 2011 8:56 AM
AS/400 administration, AS/400 error messages, AS/400 errors, Display File, RPG IV
DEAR, HI I HAVE TO DISPLAY ERROR MESSAGES LIKE WHEN I ADD EMPLOYEE CODE,MY PROGRAM SHOULD DISPLAY ERROR MESSAGE AS “EMPLOYEE ALREADY EXISTS”… ONE THING I SHOULD NOT USE ERROR MESSAGE OR ERRMSGID SIMPLE DISPLAY FILE… NOT USING SUBFILE… THEN MAINLY I AM USING COMPILE TIME ARRAY as err1… VALUES LIKE ** RECORD ALREADY EXISTS [...]
Answer Question
| March 22, 2011 8:56 AM
AS/400 administration, AS/400 error messages, AS/400 errors, Display File, RPG IV
Exporting a query in AS/400
How do I export a query that I’m currently viewing?
Answer Question
| February 28, 2012 9:22 PM
AS/400 administration, AS/400 Administrator, AS/400 Query
How do I export a query that I’m currently viewing?
Answer Question
| February 28, 2012 9:22 PM
AS/400 administration, AS/400 Administrator, AS/400 Query
Is there any conflict if create 2 different unit in as400 with the same objects and same ownership.
Is there any conflict if create 2 different unit in as400 with the same objects and same ownership. Are the LF’s will the PF’s dependencies (the LF) will not mixed?
Answer Question
| March 18, 2011 6:06 AM
AS/400 administration, Logical Files, Physical Files, V5R3
Is there any conflict if create 2 different unit in as400 with the same objects and same ownership. Are the LF’s will the PF’s dependencies (the LF) will not mixed?
Answer Question
| March 18, 2011 6:06 AM
AS/400 administration, Logical Files, Physical Files, V5R3
difference between QSTGLOWLMT and Threshold in dsk capabilty
there is a confusion regarding the ASP%. Just wanted to know that we have set the ASP% threshold in the SST as 90% and in the System Value is set to 95% as shown below Display System Value System value . . . . . : QSTGLOWLMT Description . . . . . : Auxiliary [...]
Answer Question
| March 18, 2011 10:42 AM
AS/400 administration, AS/400 ASP, ASP, ASP Maintenance
there is a confusion regarding the ASP%. Just wanted to know that we have set the ASP% threshold in the SST as 90% and in the System Value is set to 95% as shown below Display System Value System value . . . . . : QSTGLOWLMT Description . . . . . : Auxiliary [...]
Answer Question
| March 18, 2011 10:42 AM
AS/400 administration, AS/400 ASP, ASP, ASP Maintenance
FTP user Authority
hi, any one help me how to restrict the user in ftp mode. i heard through exit program can do. any one say the procedure.
Answer Question
| April 3, 2011 7:13 AM
AS/400 administration, AS/400 user authority, FTP, FTP management, User authority, User restrictions
hi, any one help me how to restrict the user in ftp mode. i heard through exit program can do. any one say the procedure.
Answer Question
| April 3, 2011 7:13 AM
AS/400 administration, AS/400 user authority, FTP, FTP management, User authority, User restrictions
AS/400 English to Arabic data
Hi , Is there is way to convert as Data(Character) which is store in English to Arabic via Rpgile Pgm . Are there any API for it . Thanks , Bisht
Answer Question
| March 21, 2011 8:23 AM
AS/400 administration, AS/400 Languages, RPGILE
Hi , Is there is way to convert as Data(Character) which is store in English to Arabic via Rpgile Pgm . Are there any API for it . Thanks , Bisht
Answer Question
| March 21, 2011 8:23 AM
AS/400 administration, AS/400 Languages, RPGILE
