• AS/400 Authorization Lists

    I created a AUTL with only Read access to certain files.  When my user ran an SQL statement against one of the files in the AUTL that he is a member of it said that he did not have authority to the file.  Why would this not work?

    TomLiotta125,585 pointsBadges:
  • Need to use the cpytoimpf command but have problem

    I have an existing process that uses the following command the only change was to have it use the tildes (~) as a field delimiter. CPYTOIMPF FROMFILE(*LIBL/BDPRISM) TOSTMF('/home/attach/vhaeom2/vhasales.txt') MBROPT(*REPLACE) STMFCODPAG(1252) RCDDLM(*CRLF) DTAFMT(*FIXED) STRDLM(*NONE) FLDDLM('~')...

    AS400PCFileTransfer16115 pointsBadges:
  • I want to dump the contents of the DSPFD command to file and then use FNDSTRPDM to find certain text strings

    I am doing some testing with file attributes that I want to automate.  I have been using the DSPFD command to print the attributes of the file.  I would now like to automate that.  I tried dumping the output of the command to an outfile and then using FNDSTRPDM to find out if the attribute was...

    Qa40045 pointsBadges:
  • Algorithm for parsing a RTF file ? anyone? ?

    I need to extract the user entered text from RTF files held within the IFS. Microsoft have a quaint 'specification' which incorporates several 'standards' for the syntax of control words. Does anyone have any RTF reading code that will run on an IBM i? - doesn't need to produce a print, or do...

    Yorkshireman5,580 pointsBadges:
  • AS/400 (Retail) Banking application

    Hi, I'm looking for some details and materials on any AS/400 retail banking application. Information in design level.. You may ask what exact requirement is but as of now I need a model which uses technology RPG, CL, SQL, menu screens, display files etc pls.. Thanks

    itkr125 pointsBadges:
  • How to save the output from an SQL select statement to a spool file

    Please can someone tell me how I can save the output from an SQL select statement to a spool file. Thanks, Tom

    Tomotsk75 pointsBadges:
  • RPG indicators

    Pls tell me how to pass values to a group of indicators at once in a single statement in RPG and RPGILE with example..thanks

    ten20081,150 pointsBadges:
  • Adding a scheduled job

    Using the WRKJOBSCDE command I am asking it to run this program CALL PGM(TAXNCY/TC350R) - The problem is once this program is called, you have to hit enter to excute the program.  How do I add this to my command?  Thanks,

    lorit365 pointsBadges:
  • How would be the opportunities for AS400 in future

    Hi, I've been working as an AS400 Professional in one of India's largest MNCs for the past 2 years. Now i have a chance of shifting into MAINFRAMES in same organization. Most of my friends telling me that MAINFRAMES had lot of opportunities compared to AS400. Can anyone please suggest me how bright...

    Mohan K695 pointsBadges:
  • How to trap the errors with out using monmsg?

    Is it possible to trap the errors in CL with out using MONMSG.let me explain?

    Nagraj32225 pointsBadges:
  • AS/400 tab text delimited format of physical file

    Hi , Using i series utility you can download PF as Text Tab Delimited format in your PC.However when I do the same by CLP using CPYTOIMPF using FLDDLM as X'05' or *tab , I get a text tab delimited file which is not completely same as the file downloaded using I series utility.

    Atti123135 pointsBadges:
  • AS/400 query

    Is there a way to create a query that gives you a report with an average price, but does not include the zero prices in the count of the average? Those "zero price records" must be included in the report for other info.  

    Hf30 pointsBadges:
  • Create a schedule in Windows Server 2008

    I need to create a schedule for a DOS batch file to run each day, every 15 minutes. I do not know how to accomplish this and need some help. Can anyone give me a helping hand? The operating system is Windows Server 2008.    

    jutpro480 pointsBadges:
  • Change file system from NTFS to FAT32

    how to change ntfs to fat32 because i want to use 300gb external hdd in linux pc but does not mount in linux pc because external hdd in ntfs

    Virendragupta5 pointsBadges:
  • Display AS/400 Password Values

    How can I display as400 password values (exp, length, etc) for audit purposes

    Deadgardens5 pointsBadges:
  • Record locking in iSeries

    My program takes the input as file, and process those records one by one. Here I would like to add the commitment control, if any one record fails then roll back and continue with the next record. To test this, I need to lock the record in another session and to run the program to check the ROLBK....

    Kar425 pointsBadges:
  • Commitment control in SQLRPGLE

    Hi All As we know that using COMMIT keyword at file level, to acheive commitment control, however I would like to know how to acheive commitment control using SQLRPGLE with out defining the COMMIT.

    Kar425 pointsBadges:
  • 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" />

    khan23275 pointsBadges:
  • Free SQL examples for V5R2

    where can I find Free SQL examples for V5R2

    Bob165215 pointsBadges:
  • AS/400 Log User Login/Logout Date and Time?

    Is it possible to see when AS400 users login and logoff? I find it unbelievable that you can see when a user changes/deletes/etc objects, but it doesn't show in the audit journal when a user simply logs on or off?!?!?

    Jt15 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