Questions & Answers

  • Consolidate multiple Excel 2016 worksheets into one

    I'm using Microsoft Excel 2016 and my workbook contains roughly 15 sheets. I need to consolidate all the sheets into one specific sheet. Obviously, I could copy / paste but that would take way too long. All the data is in the same format. Thanks.

    ITKE998,035 pointsBadges:
  • Stay AS/400 robot schedule inactive

    How do you have robot scheduler stay inactive after IPL until you want it active?

    doogie4920045 pointsBadges:
  • How to Rate Limit incoming SMTP connection on iSeries?

    We have an SMTP server that gets into trouble quite often. Incoming SMTP connections (usual suspects are Microsoft mail servers) are usually multiple connections from the same foreign SMTP server (usually Microsoft Office 365 servers). Trouble is for every SMTP connection a new job (QTSMTPSRVP) is...

    GazzaRoo225 pointsBadges:
  • What does a bad file look like?

    I'm trying to prank my mother by making a fake file that looks as if it has a virus. She's really into computers but I'm not. I wanted to know what a 'bad' file might look like?

    AlexandriaWolf20 pointsBadges:
  • CPF2524 exception at MI instruction number 0021 COBOL statement number .SIZEXCP

    Getting this Exception in one of the COBOL programs which is Reading data from MQ using MQGET. Unable to locate the instruction number in my COBOL program. This program runs always in background and the exception occurs very less often, like once in 2-3 days. Can anyone help how to locate the...

    asakla250 pointsBadges:
  • Did someone hack me?

    Hi! About 10 years ago, I had a strange event occur on my PC. While watching an .avi file everything froze, the screen turned black and a scary face appeared while producing a sound that was similar to a hung up vinyl playing. It was not a pop-up or anything to do with a browser. The only thing...

    threepwood5 pointsBadges:
  • IBM i cannot add new drives to RAID 6

    I'm adding 6 new drives of the same make/model into my IBM i V7R1. When I try to start RAID 6 parity, it will only provide me with the option for RAID 5. Why won't it allow RAID 6?

    jpanzenhagen5 pointsBadges:
  • Who has to be responsible for the performance testing?

    For the software experts out there, who has to be responsible for the performance testing? Is it the managers?

    qalead5 pointsBadges:
  • Program to close multiple Windows programs

    For my job, I usually have a ton of Windows programs open. But sometimes, I have way too many open and I was hoping if there's a way close the majority of them automatically. Is there a nice / easy process? Thanks so much.

    ITKE998,035 pointsBadges:
  • Difference between WAR, JAR and EAR files

    What is the difference between WAR and JAR and EAR files?

    Srivalli5 pointsBadges:
  • Writing 100GB data in elastic search within 5 minutes

    Hi Folks, I need an urgent solution. I have around 100 GB of data that is generated in multiple files (around 250-280) over a period of 5 minutes. I need this data to be inserted in elastic search (that what I'm using) which is then available via search through the API. All this has to be achieved...

    SatyaElasticSearch5 pointsBadges:
  • Cannot find .MDB files

    Cannot find .MDB files to generate a merge. I have new computer with Office 365. All other Office features work. Only Access does not have my data.

    gabartick5 pointsBadges:
  • SUBSTR to view table columns

    How can I use SUBSTR within my view table columns to drop only right part of the string? Thank you.

    pgams201735 pointsBadges:
  • AS/400 Power 8 (Subsystems)

    I have a client who says their IBM rep said they should only have one batch subsystem, and they are adamant that this is gospel. How do I prove this wrong?

    Harry10815 pointsBadges:
  • AS/400 Barcode

    I am in search of information for barcoding onthe AS/400. We would prefer not to purchase new printers. Can printing barcodes be done without using a graphical interface software package?

    NMK5 pointsBadges:
  • Free Database Hosting Services

    I'm looking to develop a few small web apps. I'm looking to have a few of my IT friends and family be my beta testers. What I need is a site where I can have a small hosted database that I can put in the app so they all can use it. Can anyone recommend a few alternatives? I use to have a site at...

    ToddN200069,975 pointsBadges:
  • RAID Array Degradation Isolation

    If you have 4 separate RAID 5 arrays, would a hard drive failure in one of the arrays affect only the performance of the one array and the others would remain unaffected?

    Netbui25 pointsBadges:
  • Reset startup password without reset disk

    How can I reset my password without the reset disk?

    pebbles89215 pointsBadges:
  • AS/400 User Profile

    A particular user profile is getting disabled often and the user has not logged on during that time. Is someone trying to logon using that ID or there is some other reason behind it? Please advise.

    Gayathri12370 pointsBadges:
  • How to create a source file for a client in Photoshop?

    How can I create a source file for a client in Photoshop?

    Shubhamoypaul15 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.

Thanks! We'll email you when relevant content is added and updated.

Following