• AS400 PRINTER FONTS

    I have been asked to produce new printed output in the Helvetica style. I have looked high and low for the font codes to plug into the CRTPRTF cmd with no sucess. Where can I find a listing of these 2, 3 & 4 byte codes (ie 18, 82) We don't have printed documentation on site, and I seem to be...

    MONDOU0 pointsBadges:
  • Subfile not displaying properly

    I am having a problem with my subfile not displaying properly. I my application, I have two scrollable subfiles displayed. The user can select several vendors and then display a list of checks sent to that vendor in a sequential manor (meaning if the user presses enter, the next vendor selected?s...

    RickSavoy0 pointsBadges:
  • Sorting out missing out

    I have 2 files. One having 1000 records and the other 1350. I need to sort out the missing records and place them in an excel sheet. Programmatically how to acgieve this???

    0 pointsBadges:
  • Trying to publish a Webfacing Project

    Using WebSphere Development Studio I've created a WebFacing project converted an existing application on our iSeries to a WebFaced application, but i can only access the WebFaced application from my PC. How publish the application to a web server so that other users can access it. I tried exporting...

    Slaliberte5 pointsBadges:
  • 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:

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