• Office 2007

    I have QMF for Windows 7.2 installed on my computer. I just got Office 2007 installed on my computer. Now, the Excel QMF Add-on is not working properly. I have a query with eight columns. when I use the QMF add-on to retrieve the data, it only retrieves 3 of the columns. How can I get the add-on to...

    AuntDi5 pointsBadges:
  • The most-watched IT questions this week: Sept. 22, 2009

    Curious as to what the most popular IT questions and answers are on  ITKE? So were we! So we’ve been watching the watchlists, so to speak, to bring you the top 10 questions, answers and discussions at the top of user watchlists this week. Read them all at our Community Blog.

    Michael Morisy8,323 pointsBadges:
  • Find the DB2 Contoken

    I have the load modules, can I look at them and find the DB2 CONTOKEN to match the package contoken?

    BhleftD10 pointsBadges:
  • DB2 Spufi output formatted

    How do I get 2 lines of user specified headings using db2 SPUFI: SELECT A AS "LINE1 HDG" "LINE2 HDG" FROM TABLE doesn't work.

    Dhanson20 pointsBadges:
  • DB2 Select on a large number of rows/

    I have to run a DB2 against a number of table for example tableA, tableB and select a number of fields from the table. However, I have to run the selection against 5,000 records that. I want to know if using SQL embedded in a JCL, if I could plug in a file with the records I want to select for...

    Michaelf215 pointsBadges:
  • Extracting data from a DB2 table using IKJEFT01

    I'm trying to extract data from a DB2 table via an SQL query and use IKJEFT01 to create a flat file. However, one of the non-key fields contains characters that are not nulls but non-printable. Whenever IKJEFT01 extracts these characters it changes them to nulls in the flat file. Is there an...

    AlanJ5 pointsBadges:
  • SQL join two counts on same table

    I have two different SQL statements that each is a count on the same table, but a count of different columns. I'm trying to combine them into a single statement, but am having trouble doing so.  The two statements are:  SELECT photoIDWinner as photoID, count(primaryID) as countWin FROM `rankRaw`...

    Shantheman15 pointsBadges:
  • CPYTOIMPF data corruption

    CPYTOIMPF on V5R4 with latest PTF's adds invalid data to the created CSV file for some blank fields in the PF. Is this a Bug?

    JMShmc5 pointsBadges:
  • How do I set decimal places with VB Access

    I am using Access 2000 database for calibration control of measuring instruments. i.e. micrometers, calipers etc. The precision of the instruments varies and the decimal data fields in the table are set to Auto to minimize the stored values without changing the accuracy. I want to change the number...

    Reject5 pointsBadges:
  • mainframe db2 – get current month and year

    Please advise. My DB2 statement does not work. gl_date is a date field, format is 'yyyy-mm-dd'. select * from db2 table where year(gl_date) = year(current date) and month(gl_date) = month(current date);

    Rulala5 pointsBadges:
  • dbcc checkdb error; object id 0

    Hi, We have been ask by one of our customer to restore a database from SQL Server 2000 and SQL Server 2005. The restore completed however when we run a integrity check on the database errors occurred. We than ran an integrity check with repair allow data loss option, as the customer is happy to...

    Db23290 pointsBadges:
  • Trigger Use

    I have a Sequel Server 2005 database with a Table called Main Call Issue. I want to update the DateTimeModifed field to be the Current System date without changing my original DateTimeAdded field when the record was added to the database. I know a Trigger will work here. Where do I place the...

    Jjc98105 pointsBadges:
  • Are your administrative and technical security protocols run separately or together?

    Do you have the same team managing your administrative security (user permissions, access controls) and your technical security (antivirus, firewalls), or are they managed separately? What factors influenced your organization's decision?

    JennyMack4,280 pointsBadges:
  • The most-watched IT questions this week: Sept. 15, 2009

    As part of a new feature on the IT Knowledge Exchange Community Blog, we're highlighting the top 10 most-watched questions. Here are the top 5: Virtualization vs. ConsolidationTracing a computer to an IP addressConnect remote Oracle 11g server in VB 6.0How to utlize multiple static IP's when ISP...

    Michael Morisy8,323 pointsBadges:
  • AS400 – DB2 file names

    Given a view name, how will i find its physical file name... e.g. my view name is EMP_TMP_TPL_HDR Thanks, NG

    Nutangujar895 pointsBadges:
  • How to create a virtual shared disk on for a cluster setup?

    How to create a virtual shared disk on for a cluster setup? This question is from the Microsoft Virtualization Chat held on August 27th.

    ITKE342,860 pointsBadges:
  • Oracle ODBC Windows Server 2003 scheduling issue

    I have a win 2k3 server running an MS Access odbc application that automatically links to an oracle database using the Oracle Instant client. The problem is that it runs fine when run from the Servers console as a local machine user, but fails when run from the windows at.exe scheduler. It seems...

    Ttstudio45 pointsBadges:
  • Controlling tempdb Growth

    I have a user running a SAS job that kicks tempdb from 8.5M to 6.6Gig in less than ten minutes. tempdb is on the default C: partition, which is only 16G (I have no control over that ridiculous size)! I’m new at this so I’m thinking my only option is to MOVE tempdb because of the space...

    VelameLaCosa110 pointsBadges:
  • As400 – XML

    Can i pass value from DB2 400 to XML.. how to do this?

    Nutangujar895 pointsBadges:
  • PeopleSoft Index Peformance

    Should a PeopleSoft table that has only 1 field in it have that field also defined as a key?

    LB28095 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