• Want Query output into Spool file

    Hello Folks I am creating utility CLLE program based on 5 options. Inital 4 options will be RUNQRY (query name and library is fix). Queries I have already created by WRKQRY via joining various (4-5) files. 5th option is for to check spool file. Now I want to make a program that first displays the...

    pankaj2r100 pointsBadges:
  • Regarding message subfile

    I have made a display file containing two subfiles.The first subfile is a load all scroll subfile and the second is a message subfile.The problem is that i am not able to display error message is message subfile while performing validations on data on first Load-all subfile.What could be the...

    Suvzz5 pointsBadges:
  • Error trying to call PRG

    i was try to call a prg, but im getting the error which given as follows ( Job 352272/RPANNEER/QPADEV000R started on 19/04/12 at 17:06:00 in subsystem User library list not set properly. Press Enter or Help(review reason). im having all the authority to access all obj as a secoff and the object...

    Rajasekhar151,395 pointsBadges:
  • Transform rows to files in an SQL statement.

    Hello We hava been able to produce the SQL that returns us a Vertical table with the LABELTEXT  from table CLIENTES (sql against qsys2/syscolumns).   SELECT LABELTEXT FROM QSYS2.SYSCOLUMNS WHERE TABLE_NAME = 'CLIENTES' AND TABLE_SCHEMA = 'MANEL' Observe vertical orientation. Column 1 Column 2...

    I40075 pointsBadges:
  • Query in SQL400

    Hi, I want one query in SQL400, I will give small example? Suppose there are two tables,    TAb1                Tab2 1.CMP                 1.CMP 2.Item NO           2. Item NO 3.Status              3.Warehouse 4.Quantity          ...

    ssssssssssssssss115 pointsBadges:
  • Can I change c0001copybook in RPG?

    in rpg c0001 is a standard copybook.if i want to make a new program then can i use this copybook.and for my program some modification is necessary...so can i change this copybook program

    Rehan8810 pointsBadges:
  • Clearing a subfile screen

    I have a load-all subfile that offers the user an Fkey to only display records that contain a predetermined value in a specific field. Here's the problem; If the user presses the Fkey and there are no records that contain the value required to select the record for display, I present the user with...

    Floyd02320 pointsBadges:
  • Error Msg Clean Tape in AS/400 backup

    Our backup is failing due to an error message that states we need to clean TAP01. We used a tape cleaner, also tried a solvent on swabs, tried a brand new tape and still get the error message. Any suggestions?

    Mapics60 pointsBadges:
  • Compilation issue in AS400

    Hi, I had an issue in Compiling my Files/Programs. When i compile my Files/programs interactively , I am not able to See my Spool file.Then i have checked my OUTQ , it was in *WRKSTN, which is the Printer for my Client.So when i compile it was going to their Printer. I asked them to change it to a...

    22917510 pointsBadges:
  • how to copy column-headings from a PF

    how to get column-heading names copied along with data from a PF to a flat-file? - OR - how to copy column-headings from a PF to another PF?

    svankipu560 pointsBadges:
  • Can we rename QSECOFR user id.(Auditors requirement)

    Can we rename QSECOFR user id.(Auditors requirement)

    JohnsonMumbai1,160 pointsBadges:
  • Encrypting AS400 database file

    I need to encrypt a database file residing on the as400 and FTP to a destination. Can I use QC3ENCDT to do this?

    Jeffm125 pointsBadges:
  • How to print AS/400 using HP5si and specify color paper or custom ‘type’ for tray selection

    How can i setup a AS400 print configuration using HP5si PCL and select a specific paper color and/or paper type when default printer setup is for standard plain white stock. Actually printing to Xerox 5755 Need to someway to make color or type values unique-rather not use PCL tray call code.  ...

    Pkaiser5 pointsBadges:
  • retrieve library list

    how to retrieve library list when i pressed f4 in a field and is field has *all the it fetch all library listed in subfile

    97834441841,355 pointsBadges:
  • AS400 File transfer from AS400

    I transfered the database output into excel file using CPYTOIMP command and attached the excel file using SNDDST command.But i have issue that i didn't received the excel file through email only if the file size more.Anyone kindly tell me, how to write the data into multiple sheets or kindly advise...

    hamsinee130 pointsBadges:
  • Logical file Error.

    i try to create Multiple-format Logical File but i getting compile time error. i have two PF dds is as follow.. A          R RDEPTMST                A            DEPTNAME      15        A            DID            5        A            LNAME      ...

    Nikrajpapa230 pointsBadges:
  • AS400 SNDDST with Dynamic from address

    kindly anyone please tell me, how to change dynamic FROM email address in the SNDDST command.I have task to change the from address in the SNDDST based on parameter user sent.I checked in the internet with option to configure TCP using WRKDIRE.But i want the dynamic from address for the particular...

    hamsinee130 pointsBadges:
  • upload the data into files

    hi, how to upload the data into bpcs files from excel sheet. please anyone help on this.

    421380 pointsBadges:
  • iSeries Access and 5250 Session Disconnects

    I have a client with a Dell Laptop that is connecting to an i5 520 system with iSeries Access V5R3. The 5250 sessions will not stay connected. All other PC and telnet devices have no problems stating connected. I believe the issue is associated with the Microsoft updates associated with the Laptop....

    hafwhit1,145 pointsBadges:
  • pass array to clle

    i created RPGLE,within that i defined compiled time array now i want to pass that array (at a time only one insex) to cllle but while i run this rpgle its give me run time error ..that  Error occurred while calling program or procedure *LIBL/practcl8 Message ID . . . . . . :   RNQ0211      ...

    Nikrajpapa230 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