How to check if email option is enabled on a AS/400 server
How to check if email option is enabled on a AS400 server
How to check if email option is enabled on a AS400 server
How to export data from AS/400 into Microsoft Excel
Hi, Plse tell me ,what is the problem. I try to export data from As400 into Excle.I wrote a macro in the excle sheet.I run a progrme it gives error massege ['Excel is not recognized as an internal or external command operable programe or batch file. thanks & best regards, Nadeeshani.
View Answer
| Jan 22 2009 7:58 AM GMT
AS/400 import/export, Microsoft Excel import/export, AS/400 administration
Hi, Plse tell me ,what is the problem. I try to export data from As400 into Excle.I wrote a macro in the excle sheet.I run a progrme it gives error massege ['Excel is not recognized as an internal or external command operable programe or batch file. thanks & best regards, Nadeeshani.
AS/400 import/export, Microsoft Excel import/export, AS/400 administration
Mysterious AS/400 record locking
We have been experiencing a surge in the number of occurrences of record locks in our shop. We make sure we follow the rules for preventing record locks. But I have seen programs where the UNLOCK is not used even though the UPDATE operation is embedded in between If-EndIf statements. At first I...
We have been experiencing a surge in the number of occurrences of record locks in our shop. We make sure we follow the rules for preventing record locks. But I have seen programs where the UNLOCK is not used even though the UPDATE operation is embedded in between If-EndIf statements. At first I...
AS/400 restoring across partitions
I recently got sucked into an AS/400 issue, but know very little about the system so am using manuals to figure things out.(Our sys. admin. left) We've got a server set up with a few partitions. One corresponds to our production partition, another corresponds to our testing partition. They have...
I recently got sucked into an AS/400 issue, but know very little about the system so am using manuals to figure things out.(Our sys. admin. left) We've got a server set up with a few partitions. One corresponds to our production partition, another corresponds to our testing partition. They have...
I want to copy the IFS fIle from one directory to another file and i want to ftp that file
I want to copy the IFS fIle from one directory to another file and i want to ftp that file..I need a solution how to perform this??
I want to copy the IFS fIle from one directory to another file and i want to ftp that file..I need a solution how to perform this??
How can minimize System ASP used
My As/400 System % System ASP Used goes to 76 %, How can we minimize this, I already delete Spool File.
My As/400 System % System ASP Used goes to 76 %, How can we minimize this, I already delete Spool File.
MSGW
Thank You for your reply But I need the process how I can write a program in order to get all the process to be done that is, giving opt7 & reply 'G' for a MSGW job. Or can I have any other process to do the same that means sending a reply to a MSGW job in RPGLE or CLLE or by any other process in...
Thank You for your reply But I need the process how I can write a program in order to get all the process to be done that is, giving opt7 & reply 'G' for a MSGW job. Or can I have any other process to do the same that means sending a reply to a MSGW job in RPGLE or CLLE or by any other process in...
Regarding deletion of user profile from AS/400 system
While changing the owner of the objects of the user profile from the system i encountered an error 'Ownership of 0 document library objects changed to profile XXXXXX; 1 not ...'. I need to know how can i solve this error. Thanks,
While changing the owner of the objects of the user profile from the system i encountered an error 'Ownership of 0 document library objects changed to profile XXXXXX; 1 not ...'. I need to know how can i solve this error. Thanks,
Numeric fields in AS/400
I have a numeric field 5,2 in a display file. when i am entering values i have blanks in between two numeric digits. the program is considering these blanks as zero. I hvae to avoid this, please let me know the way.
I have a numeric field 5,2 in a display file. when i am entering values i have blanks in between two numeric digits. the program is considering these blanks as zero. I hvae to avoid this, please let me know the way.
Copying a USRPRF to create a new one
Copied user A's profile to create user B. However, objects owned by A did not get copied on B's profile. How do I add about 50 objs owned by A to B's profile? Thanks.
Copied user A's profile to create user B. However, objects owned by A did not get copied on B's profile. How do I add about 50 objs owned by A to B's profile? Thanks.
How to view online the new data added to a PF?
Hi, I need to display in a subfile the new data added to a phisical file, in real time. Who knows unix, this is something like the command "tail -f". Thanks a lot!
Hi, I need to display in a subfile the new data added to a phisical file, in real time. Who knows unix, this is something like the command "tail -f". Thanks a lot!
AS/400 - Physical File in update mode
hi all, i have a physical file i need to update that file (not append) ,I opened that file in update mode eg F MYFILE UF E K DISK (i didn't mention 'A' because i dont need to append records) now after certain checks i update (any field) with syntex. UPDATE RECORD FORMAT ...
hi all, i have a physical file i need to update that file (not append) ,I opened that file in update mode eg F MYFILE UF E K DISK (i didn't mention 'A' because i dont need to append records) now after certain checks i update (any field) with syntex. UPDATE RECORD FORMAT ...
IFS maximum record size
I retrieved a file via FTP and placed it on the AS/400 IFS drive. Then when I viewed the data all the records wrapped at 4096 characters. Is this a system limit or is there a system config that can be changed to allow longer record lengths?
I retrieved a file via FTP and placed it on the AS/400 IFS drive. Then when I viewed the data all the records wrapped at 4096 characters. Is this a system limit or is there a system config that can be changed to allow longer record lengths?
AS/400: Unique records in file
hi all, i have a problem , suppose i have a physical file which has multiple occurrences of fld1 , now i need to access that in distinct (one data single time) order. so i created a logical file with UNIQUE keyword . but when i make query on this LF then msg comes that no member found. and a dump...
hi all, i have a problem , suppose i have a physical file which has multiple occurrences of fld1 , now i need to access that in distinct (one data single time) order. so i created a logical file with UNIQUE keyword . but when i make query on this LF then msg comes that no member found. and a dump...
Login timestamp of an AS/400 user into a subsystem
I want to extract all the timestamps of an particular user when he logged into the sub-system. Is there any report or file which extracts this information i.e login timestamp of an user in AS/400. Kindly provide me the solution. Thanks, Gadang
View Answer
| Nov 25 2008 1:57 AM GMT
AS/400 administration, AS/400 user sessions, AS/400 user administration
I want to extract all the timestamps of an particular user when he logged into the sub-system. Is there any report or file which extracts this information i.e login timestamp of an user in AS/400. Kindly provide me the solution. Thanks, Gadang
AS/400 administration, AS/400 user sessions, AS/400 user administration
Remote access the login time stamp of user, where it is being stored by system
In case of AS/400 Remote access the login time stamp of user is being stored by system some where and displaying correctly, whenever required. Please let us know where this data is being stored and how to extract the same. Thanks, Gadang
View Answer
| Nov 24 2008 2:14 AM GMT
AS/400 administration, AS/400 remote access, AS/400 user sessions
In case of AS/400 Remote access the login time stamp of user is being stored by system some where and displaying correctly, whenever required. Please let us know where this data is being stored and how to extract the same. Thanks, Gadang
AS/400 administration, AS/400 remote access, AS/400 user sessions


