Questions & Answers

  • Update a subquery with different tables

    I am trying to update a table and use a subquery for the argument. I think I have both queries correct but since but since they are from two tables I am not tying together correctly. Can you tell me what I need to do? update MVXJDTA.MITMAS set MMSTAT ='01' where MVXJDTA.MITMAS.MMITNO =...

    Bartbart50 pointsBadges:

    Hi, Good you give me an best real example for using the sub query, correlation of sub query & Top analysis using subqueries. Thanks in Advance.................

    134915 pointsBadges:
  • Using select statement in an update query of Oracle SQL

    how to update an entire column of an table by an subquery in an update statement.and that subquery is returning multiple rows

    Farhandgr85 pointsBadges:
  • Add animation to a phrase in a PowerPoint slide

    I want too animation to a phrase in a slide and I want to use that slide for a presentation. Will the animation be in the presentation or not?

    safeshield100610 pointsBadges:
  • Get PowerPoint presentation onto flash drive and laptop

    I completed my PowerPoint presentation. How can I get the power point presentation to the flash drive, and into a laptop on screen for presentation? Also, what equipment is needed?

    safeshield100610 pointsBadges:
  • Two mail copy in Lotus Notes 8.5.2

    I created rules on Lotus Notes 8.5.2 but when I'm sending mail that is received, I'm getting 2 mail copy.

    PAELTD5 pointsBadges:
  • How to move running Linux process to screen

    For my job, I have to sometimes connect to a Linux box using VNC. For the most part, I start the remote job on my console but it runs longer than I need it to be. Now, I don't want this running overnight just to my VNC session is open. Is there a way I can move the running remote job into my screen...

    ITKE371,795 pointsBadges:
  • Outsourcing QA functions is call centers

    Does a trend exist regarding financial service companies outsourcing the Quality Assurance function? Any opinions about this concept pro or con would be appreciated.

    DEMUSA5 pointsBadges:
  • Passing variables from CL to QMQRY

    Hi, I have a CL that get parameter and run QMQRY. When I run it, I get a prompt: "Type a value for variable "x" and press enter". Why I get it even though I pass the parameter? The CL: " PGM PARAM(&X) DCL VAR(&X) TYPE(*CHAR) LEN(8) STRQMQR QMQR(LIB1/QRY1) OUTPUT(*OUTFILE)...

    felixb50 pointsBadges:
  • Tools used widely for business analysis and project management

    What are the tools which are currently in top gear for Business Analysis and why are they used?

    Tanviv15 pointsBadges:
  • Personalizing important tabs

    Can you personalize the important tabs? Why it is important?

    Maezy19645 pointsBadges:
  • Install FoxPro 2.6 on Windows XP

    How do I install FoxPro2.6 window base on Windows XP service 3?

    Jayashah5 pointsBadges:
  • Export SQL Server database to SQL script

    For my SQL Server database, is there a way to export it to an SQL script? I need something like mysqldump. It would take the database's name, and create a script that will remake the tables, data, stored procedures, etc. Does anyone know of anything like this?

    ITKE371,795 pointsBadges:
  • Compacting files in Microsoft Outlook 2007

    I need to compact all files in my folder to free up space. It was suggested to do this from a page by Microsoft outlook 2007. I got as far as settings and chose to "compact" the chosen files. It seemed to be processing. But then stopped. I hit OK and then went back to my email page. Still slow....

    sirarthur5 pointsBadges:
  • Trigger email alerts on Windows Server 2008

    In Windows Server 2oo8, can I trigger it to send out an email alert when our logical disk partitions become low on space? We currently have two SQL Servers that are running out of space. It's due to log files. Thank you.

    ITKE371,795 pointsBadges:
  • How do I start a query on AS/400 with a parameter

    Can I start a query on AS/400 and give a variable or a parameter to that query for record selection (RCDSLT)?

    BertHeesakkers20 pointsBadges:
  • Compare field in display with actual date

    I have a field in my display ( @invdate 8y 0 edtcde(y). I want to compare this field with actual date, my field is dd/mm/yyyy. How can I make the comparison?

    obretingeorge5 pointsBadges:
  • Correlation coefficient

    how are correlation coefficient used in research reports and assessments

    browncharlene385 pointsBadges:
  • Read numeric duplicate key values in RPG program

    How do I read numeric duplicate key values in an RPG program?

    22736435 pointsBadges:
  • Get size of Linux folders and subfolders

    I'm trying to get the size of my folders in a Linux file system. I've been using 1s -la but it's the giving me the summarized size. Is there a another command that would achieve this? Du only gives me the size of the sub folder. Can I get both?

    ITKE371,795 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.