We have grouped according to our Accoutname field from databse. now we want to fetch only the first record from the group as we want one condition to be applied only on first record of the group and for rest another condition.this we want in every group not only one!!

We have a database with 15GB freespace, we want to shirnk it and reduce device size so the physical space can be recliamed at the OS level also. Is it possible?

what is the diffrences between oracle proprietary join and sql 1999 compliant joins

I have a string-combinatino of rich text and tagged test: ex: “test msg <p><STRONG></P>” on Windows machine. How i can insert data ‘AS IS’ without any data loss into a Db2 clob column. Db2 is residing on mainframe and we are using Db2 version 8.

I have this code that someone else created and I modified to calculate elapsed time between submit time & complete time but exclude hours that aren’t between 6AM & 6PM. The problem I am having is if something is submitted at 6:18PM and not completed until 6:30AM the next day it isn’t providing the correct…

I currently have an MBA and 10 years experience in managing profit and revenue (financial analysis) of software development projects. I decided to go back to school for an MIS degree. I want to manage infrastructure projects; particularly data center consolidations. I am thinking I can leverage my business experience and degree in project management.…

Hi, Im trying to connect to as400 by simply using [B style=”font-style: italic;”>Microsoft OLE DB provider for ODBC drivers. In the specify source data i placed the IP address or my as400 then the user ID and password, but when i tried Test Connection the error is general security error. 

Good day, In PowerBuilder, how can I add a picture control on a specific location on a window progmatically or at runtime…?  thanks.

when i execute following function in postgres, it gives me null. select get_strelements(’1000-2000-3000-4000′,array[''::text]); here, “get_strelements” function is as follows: CREATE OR REPLACE FUNCTION “public”.”get_strelements” (str varchar, dummyarr “pg_catalog”.”anyarray”) RETURNS “pg_catalog”.”anyarray” AS $body$ declare —————————————————————————————————————— len integer; len1 integer; len2 integer; v_str varchar; repl_char varchar := ‘-’; i integer; num numeric; noarr varchar[10]; splstr varchar; ——————————————————————————————————————…

I have loaded an ODBC Driver ‘PB INTERSOLV OEM 3.11 32-BIT INFORMIX 9 ODBC’ driver and receive two errors: “The setup routines for the ‘PB INTERSOLV OEM 3.11 32-BIT INFORMIX 9 ODBC’ driver could not be loaded due to system error code 126.” and “Could not load the setup translator library” After googling this error…

How can i set table storage settings at table creation time or any existing table

Database – MS Sql Server How to estimate the amount of space that a query uses in tempdb? I am trying to join certain transaction tables that are really huge – about 300GB. Is there a way I can compute the space that the query might take in tempdb based on factors like: 1. Columns…

I’m attempting to add subdata sheets that come from several different tables in my database to my master table. I have found, however, that no matter how I manipulate the different relationships I can only get one subdata sheet to work at a time. Is there anyway to link multiple tables as subdata sheets to…

I am trying to connect to a remote DB on a UNIX server. I am using embedded SQL statements to achieve this task. I have a file that contains DB name, ID & PW that I pass to the connect statement, rather than hardcoding the info to the program (for security reasons). C EstConnect BegSr…

How different is DB2 for AS/400 and for mainframe? For example, the high-level DB2 administrative privileges. Catalog names such as SYSADM, SYSCTRL, SYSOPR, DBADM, PACKADM, DBMAINT, DBCTRL, or catalog views such as SYSCAT.DBAUTH, SYSCAT.COLAUTH, SYSCAT.TABAUTH etc, are they using the same names for both platforms (AS/400 and mainframe)?[Br _extended=”true” />

Can someone point me to some recent real world information about CMDB? The tools, the implementation, approaches, realistic expectations. I am a data guy and understand the complexities of the underlying data. I am having a hard time getting my arms around what are realistic expectations and what the the industry is currently capable of. Thanks.…

How can i get user input in any mysql query at runtime.

I use Crystal reports via ODBC to the iSeries and have for years.  After loading V6R1 when I go in to create a report, the files aren’t showing any indexes like they used to.  The used to show indexes based on the file definitions but now there are no indexes showing. I have even pointed…

I have databases with longititude and latitude and one with Business Info – What is the best solution for getting the longitude/latitude into the Business Database? or Do I even need to merge them?

Michael Morisy recently reported on a primary of off-ticket, independent candidates, which included Cisco CEO John Chambers. Not to get too political, but we were wondering if there were particular tech CEOs that you admired for one reason or another. Share your thoughts — or your vote — and we’ll share 50 Knowledge Points!