Questions & Answers

  • Duplicate data in Excel sheet

    Hi all, I have made an excel sheet and in one column I have data (DB table column names). I want to see if duplicate data exists or not. If there is then rectify it. I am using Excel 2003. I also have searched around net but yet I didn't find any useful answer.  Thanks,

    hunshabbir72,245 pointsBadges:
  • Best way to do the DASD history capture…(Disk usage)

    Dear team, I need to enhance our current system that captures the disk space usage. I need to maintain the history over it. Currently we do it by using DSPOBJD and DSPFD commands and write the details of all objects and files used in the whole system to the outfile. Hardly it takes more than 4...

    Ezhilkumaran0 pointsBadges:
  • Group Calendar

    How can I create a calendar that 15 admins can access and update when their boss will be traveling too and where?

    acrowell15 pointsBadges:
  • Stop AS/400 job purge program

    I have a requirement where i have to submit a PGM in batch. This program is a SQLRPGLE program that deletes record from a file. I have scheduled it at 8pm and I want to stop its purging at 10pm. This means this job will run for 2 hours every day after which it should be stopped. How can I achieve...

    Supriyoas400165 pointsBadges:
  • READE & SETLL

    File: exam .................. No . name .................. 2 chow 2 siva 3 mical 4 swami 4 radha 2 lord .................. I need only equal records: 2-chow,2-siva,2-lord but I got the wrong output:2-chow, 2-siva,2-lord, 2-lord. it's reading the last rec 2 times. Please correct the below code. And...

    chowas400510 pointsBadges:
  • AS/400 batch jobs

    In a PF, if we delete a record then how to insert a new record at the same place in that PF? Any logic or code? A batch job is taking a lot of time to run,found that it is going into loop and wrapping up so how to skip that loop and process the job without changing the code? In which scenario C D I...

    chowas400510 pointsBadges:
  • In RPGLE, how to fetch the particular record in 1 lakh record without a key

    Hi, I have some 1 lakh record. I need to fetch from 250th record with no key in it. What is the possible optimed way we can achieve it.

    KirManoj15 pointsBadges:
  • DB2/400-AS/400

    File:Student ................. SID     . Sname . ................. 1       .  Chow . 2       .  Ratna. ................. I want to update sname= Rotna(2nd position a=o) using substring? Please help the query or correct the below query: UPDATE STUDENT SET SNAME=SUBSTR(SNAME, 2,1)...

    chowas400510 pointsBadges:
  • How to know login and logout time for 1 month for per user in AS/400

    How can I find out the login & logout time for 1 month for per user in AS/400?

    AS400administratot5 pointsBadges:
  • How to schedule user access time in AS/400?

    Hi I wanted to schedule the time for the AS/400 system access to the user profile. For example how can a particular user can work only between 8 AM to 6 PM. How can I do this? Sureyz.

    Sureyz2,475 pointsBadges:
  • Problem opening up IFS in iSeries Navigator

    Hi all, I am facing problem in opening up my IFS folder. I can't expand IFS directory in iSeries Navigator. Attached is my screen shot. Thanks,

    hunshabbir72,245 pointsBadges:
  • How to check which jobs are using maximum ASP%

    Is there any specific commands to check which jobs are using maximum ASP%? For e.g. when I ran DSPSYSSTS on my system, it showed some 82.6632 of ASP% used. I want to know which jobs are using it the maximum.

    svankipu620 pointsBadges:
  • Installation of WDSC

    Hi all, I have installed Web Sphere Development Studio version 7.0.0 on my PC. it was installed without any error. I created connection to my iSeries Server V5R1M0 and browse my code files etc. But when I try to compile my code I come across an error.   "Host PTF missing. The requested function is...

    hunshabbir72,245 pointsBadges:
  • How to get room appointment data efficiently from Exchange

    I'm trying to get appointment data from different meeting rooms using Exchange Managed API. For the past month, I've been using "ExchangeService.GetUserAvailability()" and it's been working great. Here's the code: private IEnumerable GetEvents(ExchangeService ExchangeService, string room, DateTime...

    ITKE351,865 pointsBadges:
  • Column extention in SQL

    Hi I want to expand the number of columns that SQL would permit me to create. How do I start? any suggestions? example: 1032 maximum column limit I want in the area of upper 5000 range for a table. Someone help. Thanks!

    Ctc12320 pointsBadges:
  • How to convert spool files to DPF?

    I am trying to convert spool files to PDF format and I'm having trouble with special Arabic characters. Can anybody help?

    Aq15 pointsBadges:
  • Full open close in an iSeries System

    I would like to know if some company has had problems about "full open close" in an "iSeries System"

    ccaldero12135 pointsBadges:
  • Proxy server isn’t responding

    Only Google isn't responding. What should I do?

    shashi0920 pointsBadges:
  • Get data from AS/400 in a text file

    How to get data from the AS/400 in the form of a text file?

    Mohammedfawzy50 pointsBadges:
  • Updating my Associate Information in Workspace

    In my Workspace, I have an Associate Information Maintenance page that gives the option of selecting a department number. When I select this option, a list of keywords appear but does not include the keyword I want. Where can I go to find this keyword list so that I can update it?

    bbishop10 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