• SQL view & FTP of this view

    I need to create an SQL view & do FTP of this view. CREATE VIEW palib/reshgjw AS SELECT WJWID as WJWID,char(WPEROD) as WPEROD,char(WCMPNY) as WCMPNY from libname/filename. In my text file, I need a tab b/w each fields. But in the text i got there are no field separators b/w field 1 & field...

    vibgyor280 pointsBadges:
  • How to display audited user profiles in AS/400

    Through CHGUSRAUD ,I had applied auditing to the particular user profiles. Later I forget what are user profiles being audited. How to display that information?

    Madhuas40040 pointsBadges:
  • AS/400 auditing user profiles

    How to display what are the user profiles deleted?

    Madhuas40040 pointsBadges:
  • AS/400 access control for sensitive commands

    Is there a way to verify list of users granted access to sensitive commands ADDAUTLE| CHGAUTLE| CHGDTA.....? As these commands are executed at the green screen of the systems. How to identify who has access to the green screen.

    Anukku30 pointsBadges:
  • AS/400 access control for commands

    Some of the system commands are considered to be powerful like, {*USRPRF,*AUTHLR, CHGSYSLIBL, CHGSYSVAL, etc}. 1. Limiting capability does not restrict a user from executing a command. If so how can we restrict the user access to these commands? 2. Is there way to list all users with the access to...

    Anukku30 pointsBadges:
  • AS/400 error message

    I'm receiving this error message (file exception 10 on file). Any ideas?

    Dbatank0 pointsBadges:
  • Command to display description of error message

    Hi, I want to know the command to display the description of error messages. Please clear my doubt.

    Babs30 pointsBadges:
  • How can I find the backup detials when I don’t have BRMS

    I have system which had backup recently. I am unaware of the job name also we don't have BRMS on the system, is there any possibility that I can find the job name or work with logs?

    Dinnu360 pointsBadges:
  • AS/400: Close open files solution

    Thank sirs , i used RCLRSC in the CLP and files closed

    SAMANDI75 pointsBadges:
  • AS/400: Close open files problem

    Dear sirs, could you please help me with the following problem: I want to close all open files that are left open from previous different steps (pgms rpg , rpgle , clp) that were run. I have tried to use a CLP pgm using RCLRSC, RCLRSC *CALLER with no success. Could you please advise me how to close...

    SAMANDI75 pointsBadges:
  • My operating system was upgraded from V5R3 to V5R4

    my operating system was just upgraded from V5R3 to V5R4. All my cobol programs are compiled with *none commitment control and a target release of V5R3M0. However after upgrading the operating system while executing the programs -913 errors are being encountered. The same programs are getting...

    Priyaranjanltcp0 pointsBadges:
  • AS/400

    yes, i am looking to start new it company.I am planing to work on AS/400 platform and related projects in my new company.For this,I am looking to purchase small as/400 server. For this question,Please give me some details like as/400 server(small one)cost,other details.

    Girilabs130 pointsBadges:
  • How to clear credit balance off a purchase ledger account?

    How do you clear credit balances off a purchase ledger account in BPCS AS/400 version 8.3, we have tried to clear off as a negative payment and through other ways but apparently BPCS won't allow a minus payment to go through so if there is a negative balance on an account and the account is no...

    ELB5 pointsBadges:
  • What is the difference between object oriented system and object oriented language

    Hi, Can anyone please tell me What is the difference between object oriented system and object oriented language since AS/400 system is an object oriented system?

    Mohan K695 pointsBadges:
  • AS/400 server built

    How to built AS/400 Box & Basic requirements needed? Hardware and software etc.

    DST60 pointsBadges:
  • Replacing a pst file

    How can I replace a pst file. I have removed and reinstalled outlook a couple of times and always get a outlook.pst file missing.

    PLMerry5 pointsBadges:
  • Compile Program for previous system level

    Hi, My system is on IBM i V7R1. I have a SQL procedure on AS/400 created using "CREATE PROCEDURE" command on SQL400 command prompt. By default resultant Program object is created with CLE attribute & for System Level V7R1M0. I want to compile this program for System Level V6R1M1. How to do this...

    Ketan19305 pointsBadges:
  • Test of running programs

    Before starting RPG program (PROGA) I need to check if the other given programs are running (for instance PROGB and PROGC). (PROGB, PROGC could be start in interactive or batch jobs by different users.) Can you let me know how to do it ? Thanks a lot.

    jitkaa5 pointsBadges:
  • How do I configure AS/400 remote user printers

    I have a remote user. She is printing on a our local printer here (main office). How can I have her print at her local printer in their office? All other users are printing OK. All user profiles are the same, OUTQ and PRTDEV = *WRKSTN

    smintz90 pointsBadges:
  • AS/400 – SQL

    I am reading a record in SQL with No Lock and its getting displayed in Screen. Based on the user input, I will/won't update the record. I want to check the record lock before performing the update statement. I don't want to check the SQL code after performing the update statement. What I want is: I...

    rajeshece1,215 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following