Expert Answer Center > Database > DB2 > DB2 with Craig Mullins
EMAIL THIS
Expert Knowledgebase
  EXPERT KNOWLEDGEBASE HOME        RSS FEEDS  
DB2 with Craig Mullins
Display in sets of:       
391-400 of 438  << Previous   page 1 2 3 ... 38 39 40 41 42 43 44   Next >>
What to look for when monitoring performance (21 JUN 2004)
What are the main things to look at when monitoring performance and what should those numbers be? We need a baseline for stress testing when adding new db2 clients. Subracting a variable from the current date (21 JUN 2004)
I want subtract a variable from the current date, in other words, depending upon certain criteria, I want to subtract a number of days from the date, but I am getting the compile error: undefined or unusabl... Searching for and retrieving names that are stored in mixed case (21 JUN 2004)
If I want to retrieve and display specific names from a table via a SQL procedure, and those name are stored in upper case I would use a wildcard for specific names to be pulled. Example: if I wanted to displ... Determining the number of rows opened by CURSOR without actually fetching them (21 JUN 2004)
Is there any way of knowing the number of rows fetched during a CURSOR open operation, without actually fetching the rows and having the count? I actually want to decide whether to continue processing or not ... TIMESTAMP is the only way to enter dates in DB2 (21 JUN 2004)
I want to enter date in format mm-dd-yyyy hh:mm:ss in DB2. How can I do that? Utility to upload datafiles that contain the "|" character (21 JUN 2004)
I am currrently running PeopleSoft HR on an RS/6000 on an Informix database. We are considering going to DB2 on OS/390. The Informix dbexport utility creates a flat text file with variable length column data... Selecting from two tables without coding two SQL statements (21 JUN 2004)
I have two OS390 DB2 tables - TBLA(Work Data) & TBLB(Master Data). Both tables have identical columns. Based on user input from the online transaction, I want to tell an application to select data from TBLA o... Using PIECESIZE with non-partitioning indexes (21 JUN 2004)
I want to use PIECESIZE with a NPI and spread the datasets across multiple volumes. What syntax do I use? How does the index keep track of what's in which index data set? Selecting from DB2, converting fields, then loading data into Oracle (21 JUN 2004)
I am trying to select against a DB2 table that will be used to load an Oracle table. I need to convert a DECIMAL and an INTEGER field into a CHARACTER field. I will then use SQL*Loader to load it into an Or... Returning a specific set of rows (like using ROWNUM) (21 JUN 2004)
How can I return a specific set of rows in a query for DB2. In Oracle I can specify which rows to return using the ROWNUM function. For example: SELECT * FROM TABLE1 WHERE ROWNUM BETWEEN 5 AND 50. Is this po...
391-400 of 438  << Previous   page 1 2 3 ... 38 39 40 41 42 43 44   Next >>
HomeExperts on DemandIT Expert Webcast SeriesExpert KnowledgebaseSite Index
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2009, TechTarget | Read our Privacy Policy 		  TechTarget - The IT Media ROI Experts