• Is there and efficient way to load Prtf fields with data from a PF?

    I want to load a Physical File with Printer File field names and Data. Then read through the PF and populate the printer file field variable with the data from another field in the file. Then I can write the PrtF record with the variable data from the file. For example PFfields: fLINE fCMD1 fRIGHT...

    JimboNbr215 pointsBadges:
  • How do you display user profile authority and object access

    Hi all, I would like to know if there is a command to check the private authority of a user profile over all objects inside the iSeries. Thank you

    iNewbie215 pointsBadges:
  • QSECURITY 40

    Hi All, If I was on QSecurity 30 and shifted the operations to QSecurity 40, knowing that my collected audits collections (logs from QAUDLVL) are ok and passed all possible program failures. Now during operations problems occured. Boom! Can I immediately revert back to QSECURITY 30 and continue my...

    iNewbie215 pointsBadges:
  • Color Overlays?

    What is required to produce a COLOR overlays on an iSeries. B&W is no problem.

    DLM2007280 pointsBadges:
  • Add In function in Excel 2010 to download file from iSeries v7.1 exceeding limit, is there something we need to do to up the limit of records from 64K

    We are running a Data File Transfer from the iSeries to Excel 2010, using the Add In off of Excel for File Transfer From iSeries. We can only download 64K records. How can we get this size limit to be larger? Our iSeries is at V7.1 and our client Access is at V6 and/or V7 for various users. We want...

    pgmr80 pointsBadges:
  • Authority to some objects in a library to which user already has access

    Hello A user is already having access to a specific library but he complained about not having authority to some PFs and queries existing in the same library? 1Not sure how the access is not there in first place? 2) to grant access now do we need to add *ALL authority for each individual object?...

    100282145 pointsBadges:
  • Grant Authority to directory in root directory

    Hi All, How do I grant authority for selected users to access a directory we have built in the root directory containing a transmittal file? I used WRKLNK, but there is no authority access like when you have a folder. Thanks!

    NYRANGER245 pointsBadges:
  • How to create Report on WRKOBJ’s output using a pf?

    Hi gotta develop a pf which will show all the objects under all user's library. Please suggest

    Archnav01270 pointsBadges:
  • Client Access Download w/ Chinese

    We are trying to download a file through Client Access that has Simplified Chinese in fields that are defined as Open and CCSID 65535. The Chinese characters are coming through as 'garbage'. Is there some setting(s) in the download that can be changed to accomplish this?

    KMoen15 pointsBadges:
  • SQLRPGLE producing invalid output

    I've got an SQLRPGLE program used to determine, among other things, whether data in one file member does or does not exist - if data exists in the current version but not in the previous a record is written to a transaction file. Thing is, I'm getting multiple records being written even though the...

    Splat7,055 pointsBadges:
  • Retrieve remote directory listing via QSH

    Hello,I have a CL function which sends a .ZIP file to our client via SFTP.I have retrieved the size of the .ZIP from our IFS by using QSH to 'ls -l' the details and redirect this output to a data area from which I can extract the size. I now need to retrieve the size of the same file from our...

    Miffo170110 pointsBadges:
  • SST QSECOFR Disabled

    My QSECOFR Profile has been disabled after couple of wrong attempts with in correct password.Now,I forgot what actually the password is ...I'm trying to force DST with option 21 from HMC Interface to reset SST QSECOFR Profile...I'm getting DST log on screen when i force DST.Here also I forgot what...

    qmaster1,675 pointsBadges:
  • difference b/w dspjoblog and spooled files

    what is the difference b/w dspjoblog and spooled files...?

    malathi2410 pointsBadges:
  • MESSAGE CPF4128

    Display All Messages System: MARS Job . . : TELNET49 User . . : JCTYNER Number . . . : 456157 2>> /* */ /* */ 228 records copied from member SANOUT1. Ownership of object QCPIMTEMPS in QTEMP type *USRSPC changed. Ownership of object QACPTEMP01 in QTEMP type *USRSPC changed. Ownership of object...

    a1maida150 pointsBadges:
  • Journaling if I drop a table

    Hi Tom, New to iSeries. If I drop and recreate a table with two additional fields, will the journalling be cleared out too? Also will the jounalling be enabled when I recreate the table? I have this brief........   We need to have the old journal entries (relating to the current layout before the...

    WendyB95 pointsBadges:
  • V6R1 QPMLPMGT svrpgm

    On my V6R1 partition, I upgraded a 3rd party applilciation that now reads the QPMLPMGT svrpgm for partition number.  The problem is that now the using the gui piece of the application users fail because the QPMLPMGT svrpgm is *public *exclude in V6R1.  They recommend changing *public to *use.  ...

    TWINLEY40 pointsBadges:
  • How do you use multiple member files in Crystal Reports?

    i have to retreive data from as400 iseires files that have multiple members and most do not have a logical for that member without creating a new logical is there anyway to tell crystal reports to use a certain member ?

    tcuccaro40 pointsBadges:
  • FTP a file from the IFS

    I have a .CSV file on the IFS that I want to FTP out to another server(not ours).  I am running the STRTCPFTP command from a clp program.  Input file is overridden to a text file in the same library.  I try to Put /home/folder/filename.csv Their server replys with: File name format not valid. ...

    NickHutcheson11,380 pointsBadges:
  • What do I have to do to get FTR QUOTE RCMD … to work

    I would like to be able to use this FTP command. I keep getting invalid kind of errors returned. I have *ALLOBJ authority on both systems. But yet I believe there is some kind of authority issue. What do I have to do on either / both systems to get this FTP command to work. What I want to do is...

    CoderHal360 pointsBadges:
  • Using CTE with Update on the iSeries

    Anyone have examples of using a common table expression with an update of fields in a file?

    Dhascuba15 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