• Email attachments sent from iSeries to webmail on a mobile device

    This question was originally posted in July 2007 and I was wondering if anyone had a solution for it. email attachments sent from the AS/400 via SNDDST to a mobile device arrive with carats (<>) around the file name. (i.e. <test.txt> instead of test.txt). As a result the mobile device...

    lmensah15 pointsBadges:
  • Compile question

    Have you encountered any issues with clients not being able to compile programs once upgraded to V7R1? I have a client who can not compile RPGLE programs. They are on an iSeries and upgraded from V5R4M5 to V7R1M0 Thanks

    expson75 pointsBadges:
  • How to manage SQL queries on iSeries

    We have users who are using SQL to perform queries on our iSeries. As such, we need a way to manage these queries so that, if a runaway, poorly written, etc. causes issues for CPU and/or DASD we can either be notified, end the job, or some other parameter. Is there such an animal? Thanks!

    StarTaylor15 pointsBadges:
  • IS WRKSYSVAL SYSVAL (QMAXSIGN) COMMAND USER SPECIFIC OR GLOBAL

    Actually I need one commen user id to have mutiple attempts for sign on I had tried with below command but it updates globally and not for one user IS WRKSYSVAL SYSVAL (QMAXSIGN) COMMAND USER SPECIFIC OR GLOBAL pls help

    Manojcgupta25 pointsBadges:
  • File is not moving in folder

    Hi, I want to move a file which has a invoice no and create a sub-folder in /hame folder using the invoice number as the folder name. for example: NAMEIN=/home/Indicium/20202021.pdf Nameout=/home/Intellichief/20202021/20202021.pdf PGM PARM(&NAMEIN &NAMEOUT) DCL VAR(&NAMEIN) TYPE(*CHAR)...

    97834441841,355 pointsBadges:
  • AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database.

    I have a AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database. Is there a API or some method for doing this. Help.

    Theraven35 pointsBadges:
  • GMT timestamp

    I am creating an XML document using RPG and I need to output a timestamp in GMT format : YYYYMMDDThhmmssZ The date will need to end up looking like this: 20131003T210212.001Z. Can anyone tell me how to do that in an RPG program on the iSeries?  Thank you.

    DStaats25 pointsBadges:
  • Workstation Entries vs Communication Entries

    I'm lagging with a clarity between Workstation Entries and Communication Entries. Can anybody explain me about which is meant for what ?to my understanding Workstation Entries are workstation devices for logging into the system for interactive work ?Communication Entries - ? this also do similar...

    qmaster1,675 pointsBadges:
  • Future of AS/400 Admin and Support Jobs

    I have been working with AS/400 for the past 4 years. I know that IBM is shutting down its support for V5R4 now, and also that V7R1 is going to be the last version of OS that a power5 box can have. I think most of the customers may not be upgrading to a new physical box, I'm not sure but I think in...

    AdminAS40015 pointsBadges:
  • Disappearing reports

    I have a client that claims that his reports disappear over night. He runs his reports converts them to PDF and then the next morning when I check them they are in a FIN status. He claims that they are not being printed off. I can find no history of anything being done to them. I am totally stumped

    jmurfitt40 pointsBadges:
  • Help with iSeries CRTLF command

    I need to create a logical file over a physical file. Can someone help me understand what I am doing wrong. The physical file is in library IDSDAYA and is called OOIORDDP. It has 6 members and I am interested in creating a file where I can access the data in three of the members at one time. I...

    mgrady15 pointsBadges:
  • RPGLE Subfile Validation

    Hi Everybody, I am new to RPGLE and I hope you can help me with my problem. I have used a subfile for loading details in my program. Now it is expanded subfile (page down on the next page) cause there is a lot of transactions displayed. My problem is that I have entered a selection on the first...

    calvin0105905 pointsBadges:
  • Insert data to DB2 database using VB and SQL stored procedure

    I have spent a few days trying to find a solution using Google. Has anyone had luck with this problem? Simply put we are trying to send data from our web service to our I-Series. We need to do this via a SQL stored procedure. When we do the insert dynamically it works as long as there are no single...

    ToddN20009,905 pointsBadges:
  • Install iSeries on none IBM server

    Can we install iSeries or create iSeries partition on none IBM server?

    abar1425 pointsBadges:
  • ODBC Library list

    Dear users, If we are using Excel to get External data from iSeries, can we add a library temporary to a predefined Data source such as we can do during File transfer Properties?

    chalenger455 pointsBadges:
  • How do I check members list for a specific user group in iSeries (AS/400)

    What is the command to request system to list out member of a particular group profile with the assumption that my user ID is just a normal user ID (without SECADM function). Please help.

    Grpprfmbr20 pointsBadges:
  • Date calculation using a variable

    This is the original standard date calculation I was using. I need to change the number of months to a variable that I'm getting from a DTAARA. Value is zoned. The error I get isDate, Time or Timestamp value is not valid. I can't find a way to change the one or two digit value to a 'date' field...

    badspeller30 pointsBadges:
  • Firewall preventing NET USE drive mapping PC to iSeries.

    Does anybody know what ports are used when I run net use * \\servername\share PWD /User:USER ? The firewall is stopping it somewhere although ports 137, 139, 445, and 8471-8477 are open on the firewall. It eventually times out with "System error 53 has occurred - The Network Path was not Found"...

    stropley10 pointsBadges:
  • AS400-Who created a user profile

    Is there a report on the AS400 that will show who created a user profile.

    Lope4451720 pointsBadges:
  • VBA code to transfer data from iSeries to Excel

    Hi everyone, could someone provide VBA code to automate the Transfer of data from the iSeries into an Excel 2003 Spreadsheet. Currently we have to manually use the iSeries Excel Add-In. All fields are left default except the Library/File field where we enter PRODDTA/F56EXT. The data then transfers...

    Mblair.au25 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