• How to select 1 record in DB2

    As usual, I often use: select top 1 * from table but in DB2, I can't. I use the Toad tool to input SQL statement. Does anyone have a solution? Please share it with me. Tkanks a lot!

    Linhntk5 pointsBadges:
  • Access

    How do I access SQL data in software?

    shafi5 pointsBadges:
  • IF ELSE in SQL Server stored procedure

    I am using this code which is giving error: if (@report_type = 'CM') Begin Select distinct Region,sum(ClientCount) as ClientTotal Into #NewTemp From ( End else if (@report_type = 'AM' ) Begin ( Select distinct Region,Area,sum(ClientCount) as ClientTotal Into #NewTemp1 From End else if (@report_type...

    Rrj15 pointsBadges:
  • How to read MS SQL tables using iSeries RPG

    Has anyone found a technique for reading data directly from MS SQL using an iSeries RPG program?

    WoodEngineer6,435 pointsBadges:
  • SQL Plus stops before finishing

    Why does SQL+ stop after running so many characters in a long SQL statement?

    rayfish201315 pointsBadges:
  • Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database?

    Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database? I need to access data in an Intersystems Cachè Database from an SQL Server database. Can I do a select in SQL Server from a table in another DBMS system? How can I do it? Data is in a Cachè Database. I was...

    FernandaAraujo45 pointsBadges:
  • webservice and iDB2 connections slow on startup

    We have a web service running on a SQL server sending data to our I-Series using a DB2 connection. The first time the service is run to submit an order, there is a long delay before it is submitted. On repeated orders it much quicker. Is there something we can do to speed up the initial connection?...

    ToddN20009,700 pointsBadges:
  • I need the date to go to my dataTable

    I have a form that updates the amounts a parent is either charging or paying which is working but I need the date to go to my parent table also for the date of a payment or a separate column if it was a charge. I would put my code on here but I dont see a place for it. Private Sub...

    brendaStrub5 pointsBadges:
  • Exchange – extracting email properties

    Hi there, just need a bit of guidance here. I need to extract from email accounts a list of the emails in that account - I don't want the content of the emails - but what I want is emailID, subjsy, date received and it's current location (ie what folder is it in) in that email account. I need this...

    dragonsong15 pointsBadges:
  • Convert from text to number – exporting to Excel 2003 from SQL Reporting Services 2008 R2

    Hi I was trying to export a report which is in float format. When I do that, all the numbers in excel have a green small tag beside it saying "The number in this cell is formatted as text or preceded by an apostrophe". I have to sum my report values and this can only be done after I convert each...

    DhivyaJ10 pointsBadges:
  • Server upgrade 2003 to 2008

    I'm upgrading my server hardware, I currently have server 2003. I also want to upgrade to server 2008 too. The new server I'm getting comes with its own new drives. How can I upgrade to a completely new server and upgrade to 2008, while retaining all of my data and Active Directory, etc.

    dthomas51865 pointsBadges:
  • Importing Excel data into SQL Server and filtering columns of Excel data in SQL

    I'm trying to import Excel sheet's data into SQL server and filter column data.eg: pim ,rib,rpm,rms,ssrs ets sub topics comes under Oracle retail tower. Likewise, I need to filter for 9 other towers. How can I do this? Can anyone please help me?

    dammu5 pointsBadges:
  • Unidirectional replication in SQL Server 2008

    Can transactional replication be bidirectional?

    Dougm10 pointsBadges:
  • Linked server SQL select into

    I'm trying to create a stored procedure that will trigger every 15 minutes via a server agent job. I need to pull data back from a linked server to our SQL server. The tables have the same columns/fields just different names. I know the linked server logic works because I get the data if I run this...

    ToddN20009,700 pointsBadges:
  • Getting DB2 data into SQL 2008 database

    We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged to...

    ToddN20009,700 pointsBadges:
  • Creating service accounts in Windows 7 home edition

    In Mike Hotek's book SQL Server 2008 he gave instructions on how to create service accounts using XP. How do I create these accounts using Windows 7 home edition? Thanks.

    kerrycorr5 pointsBadges:
  • Best practice when using a shared table across multiple databases

    Hi everyone! I thought I would easily find a discussion on the internet about this subject but I didn't find anything to really help me. I have many applications that need to share common tables. Think about an Employee table for example. I don't want to have this table duplicated in each project's...

    skoub5 pointsBadges:
  • Open IT Forum: IT’s role in customer service

    One of ITKnowledgeExchange's bloggers is working on a series about customer service in the enterprise, and how it can be improved. From the IT side, do you have any experiences or suggestions for improving how companies do customer service? We'll take horror stories as well! Help a fellow IT...

    MelanieYarbrough6,345 pointsBadges:
  • Which config file does MySQL use?

    Hi, I'm having trouble with MySQL. My OS is IBMi V7R1. We are using MySQL 5.0.45 with zend server 5.6.0. The problem is that the MySQL server works fine in qp2term(shell) but ends immediately after start with zend server. Also, when I check the defaults config file for MySQL I get this message:...

    jailall101735 pointsBadges:
  • Getting 2008 voting data inside Spatial

    When creating a choropleth map, first I must obtain the data. If I have the table of values in my possession, what are the steps for moving the data inside Spatial?

    lloydia5 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