• How can I find on which files a program has been attached as an external trigger?

    I have a "generic" rpgle program that can be attached to any physical file as a trigger. And so it has been, many times.. Is there a utility that I can use to find exactly what files have this program attached as a trigger? Or some table where I can look? Thanks! Kevin

    Beercheck0 pointsBadges:
  • Emailing from iSeries with multiple attachments

    I am looking for a way to send an email from the iSeries with multiple attachements. The attachments are documents (.doc, .pdf, etc.) in the IFS not spool files. SNDDST only allows one attachment and most of the other options I have seen involve spool files. Does anyone know how this can be done?...

    Joy195400 pointsBadges:
  • FTP from iSeries to PC

    I have installed a Cerberus FTP Server on the PC and I need to FTP a flat file FROM the iSeries TO the PC. However, when I enter the PUT statement it returns with : 227 Entering Passive Mode (213,210,55,130,4,22) 425 Unable to open the data connection Any idea where I am going wrong please?

    Selectsoft65 pointsBadges:
  • Reg Data extraction from one environment to another

    Hi Consider i have testing library and development library in my library list. Say for eg, given a shipment ID i need to copy all the relevant data from testing enviroment to development environment. Since the file objects reside in testing and dev environment how will i be able to fetch data from...

    Rafiqm0 pointsBadges:
  • vb.net and AS400

    I have to develop a VB.net application where I download some data from an IBM system I(AS400) to interface with some Microsoft products. The data from the system i(AS400) will be a list of vendors and various data elements that will help me determine if they are the cheapest vendor. I will need to...

    Slacker0 pointsBadges:
  • Front End Development for AS400

    Hi We have an application in AS400 for which we are thinking of developing a GUI front end for the users. The users will then be able to run the processes from their PC. I have not worked on any such application and so, I do not know anything of that. I have done some initial research on that and...

    Pgsdeb20 pointsBadges:
  • SQL Logical Functions

    Which is better to use and why? Also, which function is faster and why? Coalesce -or- IfNull

    maryann465 pointsBadges:
  • Deriving tape header info for use in logging and messaging

    I would like an example, preferably in i5/OS CL, for a method to retreive the volume number of the tape just used for a complete system backup so that I can put out a message to the system operator queue or the system log which includes the tape volume number. I tried this with CHKTAP which puts it...

    DeadMeatinLA0 pointsBadges:
  • Journal Receiver Sequencing

    Hi All, We have a test and production data library, we have a separate journal for each that fill journal receivers in their respective libraries. In TEST our system managed receivers always start at sequence 1 when a new receiver is attached, in production the sequence number continues from the...

    RaydenR0 pointsBadges:
  • Tape Expiration

    Does anyone know how to automatically check a tape to make sure that it has not expired before running a backup. I know you can use BRMS but we do not have BRMS on our system. We have set up the backups to put an expiration date on them but if the operators put the wrong tape in I get a call at...

    HippoLady0 pointsBadges:
  • Use SNDDST command to send email

    I'm using the SNDDST command on the AS400 to send email but its failing to deliver to users outside of my company. The emails are delivered to inhouse users but not outside email addresses. Can anyone inform why this is occuring and how to fix it?

    cmarsellus50 pointsBadges:
  • Using an array in embedded SQL in RPGLE

    Is there a way to specify a host array element in a where clause in embedded SQL? This is what I am trying to do: C+ Where TkPart01 = :odPart(01) C+ and TkQty01 = :odQty(01) C+ and TkPart02 = :odPart(02) C+ and TkQty02 = :odQty(02) There's more to it than that but that should give you the general...

    Vatchy1,410 pointsBadges:
  • MS SQL Server 2000

    Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

    Sudh2k0 pointsBadges:
  • can strqmqry be run as remote command

    I am trying to run strqmqry via a dos/cmd ftp session. command: QUOTE RCMD STRQMQRY QMQRY(lib/qry) ... where ... are other options I followed various instructions posted here and on as400 tech sites on how to create the query. I was able to do all of that via a dos/cmd ftp session (except for...

    Bdatadigger0 pointsBadges:
  • CPYTOIMPF Nightmare

    I am using this to transfer data from the S400 to the IFS. The data has to be tab delimited. I am the sending the data to a UNIX box. the problem is I am a getting a carriage return at the end of fields - and it appears to be random. Here is my command CPYTOIMPF FROMFILE(*LIBL/IOBEXT) +...

    Raddy590 pointsBadges:
  • OPNQRYF’s MAPFLD

    I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined this way...

    JohndeCoville0 pointsBadges:
  • Single quotes around a CL variable

    The easiest way to do the above please

    Raddy590 pointsBadges:
  • Using S/36 object members (load and subroutine) on AS/400

    Hello, We are looking for IBM-supplied commands that will convert and/or run S/36 object members (load and subroutine members) to useable AS/400 system objects. The fact is that we lost the RPG source code from the S/36; so there is no source to compile on the AS/400. We look forward to your help....

    Masquita0 pointsBadges:
  • Display Footers in Subfiles

    Hi, I have a dual display subfile. I am able to do display the screens allright but it's the footer record i am unable to display at all. I have made sure that the second subfile record doesn't overlap my footer area (by footer, i mean the area where i want to display my Function keys). I have used...

    Me2learn0 pointsBadges:
  • Increase Size of Network Storage Area

    I have a client that needs to increase the size of the NWS being used with Windows Server 2003. It is a mapped drive for all users. Can anyone help with the steps required to change the size and maintain the drive mapping? They are on V5R3. Any suggestions will be appreciated.

    Dsheafl0 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