• PLSQL code on iSeries

    Hi, I have a question as we have developed some plsql procedures on Db2 10.5 on windows & Linux. This is purely plsql code. as we need to run these procedures on all the databases under a particular instance. My requirement is can I use the same plsql code on Db2/400. I mean on iSeries. On...

    HABBIE850 pointsBadges:
  • Exporting Polish characters from iSeries

    V5R4. We have a client database that, for the first time, has to deal with Latin-2 characters. We have set up some sessions to use Polish configuration (code page 1153) and got around printing problems by having a separately configured printer. Now we have a problem with exporting the data to...

    Abby7010 pointsBadges:
  • Command line instead of AFPU (IBM Advanced Function Printing Utilities for iSeries)

    Instead of going to the AFPU (IBM Advanced Function Printing Utilities for iSeries) menu to print an overlay to a specific printer out queue (taking option 22 - Work with overlays, then option 6 - print) What command and its parameters can I type from the iSeries command line to print an overlay to...

    Zemogdug35 pointsBadges:
  • Web Application Development on iSeries

    May be this would be the right place to ask this. But still I'm not getting a clear idea. We are using an application written in RPG running in iSeries machine. I'm pure AS/400 Developer cum Administrator. since the users complaining so much we wanted to develop a web application which will replace...

    Sureyz2,555 pointsBadges:
  • Client Access adding decimal and blank space after numeric fields

    How can I remove the decimal point and blank spaces during the file transfer process. These are defined as zoned numeric fields. The file is a typical iSeries physical file with both Character and zoned numeric fields. The blank spaces and decimal point do not show when you display the file on the...

    Sharonhynes45 pointsBadges:
  • User Not On the Menu System

    iNavigator v.7.2, OS400-iSeries.v5r3, When a regular user logs on from iNavigator, he sees no Menus, also encountering a confusing Message: “User Not On the Menu System”! What User Setting might have been Corrupted or Missing? THX! Kanneth

    KenKimNy50 pointsBadges:
  • AS/400: Finding a list of objects which are locked by users.

    We have Visions Mimix global software replicating data from Source to 3 target servers. There are few users running sql queries etc on the target servers causing objects to go into lock and this results in objects going into replication error. Is it possible to get a list of objects which are...

    JohnsonMumbai1,210 pointsBadges:
  • iSeries-AS/400 SQL

    I have a table in a test environment and need to update the same name table up in a production environment. This would be any table and here are things we won't know. We do not know if there is a key, field names, or what was changed. It could be any file. so this has to work for any table. I used...

    Pgmr4665 pointsBadges:
  • FTP from iSeries to PC server

    I've written a script to ftp text file to PC server. Tried on command line, no issue. But put that in CL program, I got the following error message. My INPUT file is as follow “ USER username userpwd NAMEFMT 1 ASCII PROMPT CD /ftp LCD /FTP/outbox PUT datafile.txt CLOSE QUIT “ Log file shows the...

    ChrisLYL35 pointsBadges:
  • iSeries SNDDST issue

    Hi, I'm trying to send a notification email from the iSeries using snddst, but part of the message includes a £ sign. On arrival at the designated email address this character has changed to $.

    MorphyDR15 pointsBadges:
  • Robot Scheduler settings in iSeries

    Is there a way for Robot scheduler to say, don't submit the job, if the previous one is still in job queue?

    Aruldas5 pointsBadges:
  • Form Definition in iSeries

    Hi, I would like to know if there is any Form Definition in iSeries that have a Margin of 1/8 inch. I believe that F1C10110 had a margin of 1/6 inch. We had a problem that the bottom of the printing is being cut off. Any advice? We are using Printronix T5304r. Help!

    TeddySoh50 pointsBadges:
  • Reset Regular User Password

    Hi! re: OS/400 iSeries 5.7, Command to Change Regular User PasswordAlthough I have QSecOfr Level privilege, I am somewhat baffled by the Procedure of "emptying" Corrupted Regular User Password and let him enter a new one when log on from iNavigator.It just happened that a regular user changed his...

    KenKimNy50 pointsBadges:
  • How to drop an alias table named alias

    I needed to access a specific file member of a DB2 file, so I created an alias in my library via a SQL statement using a iDB2Connection. Now I cannot drop it. Here is my create statement. CREATE ALIAS MYLIB/ALIAS  FOR OPTIOFILE/FXFORM (MYFORM) I can now run my selects and load my datagrids using...

    ToddN200021,420 pointsBadges:
  • How to fix CPD5231

    How do I fix CPD5231?

    mlaw00125 pointsBadges:
  • Excessive JOBLOGS from subfile

    Since upgrading to 7.1 this past month we are experiencing a problem from one program from a subfile that is causing excessive job logs creating huge spool files. A message will appear in the subfile then its automatically answered with a 'C' and this happens several times in the spool file causing...

    UARTJ115 pointsBadges:
  • iDB2 connection lifetime fails

    I'm getting an error on my connection string. The error says The connectiong property is invalid.  It also says it must be IsGeneric. Not sure what I'm missing and I'v searched IBM's site.. It was not much help.  The reason I want to put a lifetime on connection is to prevent object locks. I can...

    ToddN200021,420 pointsBadges:
  • AS/400: How to start a new session using menu option

    I have created a menu using STRSDA. I wanted to add a option to start a new session in IBM iSeries access. (Usually I open a new session by selecting file -> Run the same.) Is there any related command is available in AS/400 so that I minimize work in opening new session each and every time....

    RPOOJA125 pointsBadges:
  • How do I copy a pipe delimited text file to pf on iseries.

    Can someone tell me how to copy a pipe delimited text file to PF on iSeries?

    CarolKendall5 pointsBadges:
  • How to create a WSCST Object to Print to Output tray 2?

    I have a printer *DEVD created with 'Manufacturer type and model  *HP5SI' and it's a Canon IR-ADV C5235 printer. We have two output trays on that printer and need to send all iSeries reports to Tray 2. I can't make any changes to PRTF as same printer file is being used for reports which...

    Chamika20 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