• How to sort a db2 table column, containing date stored in char format.

    i have a column which is not Y2K complaint, the values are stored in char format like ddmmyy ( i know its totally dumb), i need to sort based on ascending or descending order.  051193 -> 5 nov 1993  140308 -> 14 march 2008  141211 -> 14 december 2011   Now how do i sort this column...

    Maverickgiant40 pointsBadges:
  • Contest Bounty: Ask/Answer questions this weekend, earn 100 points!

    Is the rain keeping your weekend plans from getting off the ground? Well, IT Knowledge Exchange has a chance for you to take advantage of staying indoors. Ask or answer 10 questions* this weekend, and you will earn 100 knowledge points, good for our current contest! Any combination of...

    MelanieYarbrough6,345 pointsBadges:
  • VB6.0 Connectivity to Oracle

    How to connect oracle 9i to vb6.0 using active X data objects? please mention the code.. Thnx ...  Saurabh

    981500799910 pointsBadges:
  • Increasing text in Access 2007 without losing info

    I have formatted an Access Form with four inserts for text as each were limited to 50 characters at the time, this works but is tedious as some of my input is over 50 characters and breaks up my text to the next insert what I am looking for is to encrease my text characters as much as possible for...

    PeterQ10 pointsBadges:
  • Completed IT Knowledge Exchange Profile? Earn points!

    What's a community without a face? Let your fellow IT Knowledge Exchange members know a little more about you and your expertise by filling out your public profile and uploading a photo. Then put the link to your profile in the discussion area below to claim your 10 knowledge points, good toward...

    MelanieYarbrough6,345 pointsBadges:
  • Question on Physical Files & Logical Files

    Hi Group, I have a Physical file. I created a Logical file on it with a key field as Primary key. Later as per the new requirements i created a LF with composite key as primary key. Should i make any changes to the LF that was created earlier??

    mvrkrishna535 pointsBadges:
  • “Automation Error Invalid Advise Tags” What is an advise tag?

    I have a visual basic module within Access that seems to compile fine; when I select the Debug function in the visual basic editor, I receive no errors or messages.  However, within my Access form, when I try to click the button associated with this module, I receive the error message, "Automation...

    Siggy5 pointsBadges:
  • How to make the connection in SQL 2000 with Visual Basic 6

    i want to make the sql connection with vb6,how to open the connection in sql

    Vishalngp15 pointsBadges:
  • Central remote desktop using Windows Server 2008?

    We want to do away with all of our one to one nats into our datacenter. Can we have a central remote desktop server using Windows server 2008 and if so what do we need to do to get it working/configured?

    TeachMeIT975 pointsBadges:
  • DB2 Process automatically Shutdown

    At  our site using IBM DB2 database there some problem with our DB2 Database services stop automatically .Error log  shown the  DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN. Thanks, Nilesh

    Linuxroot35 pointsBadges:
  • use Data connection wizard / Microsoft query to get data from as400 to excel 2007

    Hi, I know the way to download data from as400 to excel 2007. It can be done by using Data connection wizard or Microsoft query. However, when using (1) Data connection wizard, i don't know which kind of database i should choose. ODBC DSN or Other / advanced ? after choosing the kind of database,...

    Clarksonneo15 pointsBadges:
  • Embedded SQL in RPGLE hdr, dtl fetch for subfile build

    I am trying to join a header and a detail file and select all fields into data structures defined as external(filename). D dswtchdr      E DS                  EXTNAME(wtchdr) D dswtcdet      E DS                  EXTNAME(wtcdet) C     $CreateCsr   ...

    NickHutcheson11,380 pointsBadges:
  • Embedded SQLRPGLE Books, guides, how to’s

    Does anyone know of some good SQL books for RPGLE other than the IBM manuals? I need to learn more to keep afloat!

    NickHutcheson11,380 pointsBadges:
  • Can we change length of CSV File

    Hi guys, I have a CSV format file in my database which is used for Adhoc reporting. Now, I need to increase the legnth of that file. I am trying to increase using CHGPF command, But I wasnt able to do the same. Will any one of you suggest me the way for increasing the legnth of CSV file?

    deepu93213,695 pointsBadges:
  • Can Siebel run on AS/400 / iseries and connect to DB2/400?

    Can Siebel run on AS/400/iseries and connect to DB2/400? If not what are the best options to deploy it on AS/400?

    Uiiuo50 pointsBadges:
  • Excel Spreadsheets

    We developed some kind of database with excel spreadsheets to draw monthly stats for diffrent departments. It works as follows: Individual spreadsheets(formulated)feeds into a master Link spreadsheets(data) we then use Pivots for our reports. The problem that I now expierence is that: 1. The...

    Joshua55 pointsBadges:
  • How can I set the default to be on current date when form loads

    I’m using Microsoft Calendar Control 9.0 in Visual Basic 4 and would love some help on getting the calendar to show current date as the default date when it loads. Every thing else seems to work just fine, but I can’t get it to default to current date, it seems to be stuck on the date that the...

    TheFinder1,940 pointsBadges:
  • Will you be at Interop Las Vegas next week?

    Grab lunch or a coffee with editor Michael Morisy to discuss what you think of the keynotes, sessions, and vendor announcements at Interop next week. Get some sweet IT Knowledge Exchange swag and let us know what you're thinking of the show and the direction of networking in general! Let him know...

    ITKE344,900 pointsBadges:
  • Open IT Forum: Share networking resources, earn knowledge points!

    It's Networking month at IT Knowledge Exchange, and we're looking for your best resources on the subject. Share networking guides, blogs, tips, books, and great Twitter pros to follow! For each category you contribute to, we'll give you 25 knowledge points, good toward our latest contest.

    MelanieYarbrough6,345 pointsBadges:
  • MySQL Replication I think!

    Hi, I have a local Access Database that is the management system for a business. They now want to take some feature online so customers can do some functions themselves. What I am thinking is migrate the data to MySQL and use a local install of MySQL as the backend and point the Access front end at...

    Awestrope5 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