• SQL and Dates

    Can someone date a look at this SQL and recommend a cleaner way to go about this? [BMDTOR is a date field in the file stored as CCYYMMDD] SELECT (DAYS(CURRENT DATE)-DAYS(SUBSTR(BMDTOR,5,2)||'/'||SUBSTR(BMDTOR,7,2)||'/'||SUBSTR(BMDTOR,3,2)))/30 AGE,...

    jschultz385 pointsBadges:
  • Change password through JDBC

    hi can any one help me .. how to change a password reset/ change password through JDBC connections specifications: 1)we are going to change password from front end URL 2)we need to connect through Db2 database through JDBC connections

    Srinivas204415 pointsBadges:
  • iSeries Access Macro to run from a program.

    I think I've asked the same question some months ago but didn't get any answer and couldn't be able to find one myself. The issue is: i have an iseries access macro that i run every day, but I do it from the Play button in the access menu. I would like to put this macro in a common directory (done)...

    Mawc10 pointsBadges:
  • Application Upgrade and Data migration

    Hello Sir/Mam We have a web application that has an intensive usage of Database operations. This application of course has some sort of sophisticated Database (tables, indexes, ...)  structure according to Database engine used.  My question now is , what is the best practice to migrate old...

    Mshafie70 pointsBadges:
  • Just started learning java programming, how do I become a Java Programmer?

    HI i am 20 yrs old, i have no experience what so ever with programming but am very good at using windows. I've just started to learn java programming using an Ebook called Java programming for dummies. I've recently looked up on google wages for java programmers and seen wages as much as 80 to 100...

    AC205 pointsBadges:
  • Crystal Reports 8.5 iMIS 10.6 database

    I am using Crystal 8.5 with iMIS 10.6. In the database we collect Annual Fund gift information. Each Annual Fund year is a discrete value (AF_2011, AF_2010, AF_2009 etc. I am having difficulty writing a formula that will give me new (AF_2011 only) gifts. I want to show those who only gave to...

    Mystic15 pointsBadges:
  • SQL Server project in VB 2005

    A form contain two text field (Name,Address) three buttons (Save,Modify,Delete). A test.mdf file in sql server. I want total source code of that sample project Pl help me about that. Thank you prit

    PRITH5 pointsBadges:
  • TGIF: IT Book Giveaway

    Happy Friday, everyone! If you want to take a break from your hectic day at the office, you've come to the right place to get those competitive juices flowing. We're giving away Embedded Linux Primer, Second Edition from the Prentice Hall Open Source Software Development Series. If you want this...

    MelanieYarbrough6,345 pointsBadges:
  • SQLCMD does not create a log file

    I have several SQL update/delete statements I run during a payroll cycle. When I run a SQL that does not have any records that meet the selection criteria, I do not get a log created. I can run the same SQL in SQLServer, and it shows (0 records updated).

    Harv200250 pointsBadges:
  • ID card scanner software/hardware

    Hi friends ,hope you all are fine and doing well.I am working as a security guard for my company, recently our company has started expanding its ware house and workshop and it hired three companies to complete the project.As a part of my duty is to check identification and work passes issued by our...

    Kanutake39100 pointsBadges:
  • Hard drive failing on production server

    We think a hard drive is failing on a production server. I copied everything to another drive on a different array. How can we monitor the health of the hard drive/array?

    NewnanIT1,110 pointsBadges:
  • Automatic serial number assignment and customer exits in SAP

    I have a serial number profile with a single serializing procedure, SDAU. The procedure calls for automatic serial numbers and requires equipment records. Is it possible, using one of the serial number customer exits, to create a custom serial number in place of the numerical serial number assigned...

    TheRockinRandy5 pointsBadges:
  • Server Timeout on initial web connection to SQLServer

    We run a couple of websites (hosted on different webservers) that connect to an SQL Server. The data was recently moved to another SQL Server (called SQLCLUSTER) and now the first time the site is accessed, it takes over 20 seconds to bring up the page. If I don't set the Connection Timeout in the...

    Ajmo25 pointsBadges:
  • IT Knowledge Exchange’s iPad Contest Starts Today!

    Today marks a new contest around IT Knowledge Exchange. The Lowdown (i.e. The Rules**) Every member who earns 500 knowledge points in the next 4 weeks (between today and Wednesday, February 16th) will be entered into a drawing for 5 names. You must have a completed profile including a photo or...

    MelanieYarbrough6,345 pointsBadges:
  • SCSI drives suitable for setting up an array

    What speed SCSI drives are suitable for CAD designers working off the server? How would you set them up in an array? We need 10 TB capacity.

    Troubleshooter24755 pointsBadges:
  • Call a program and send parameters in WRKJOBSCDE

    I want to schedule a job to run. It needs to call the program and send 20 parameters. Is this a good way to do through Job Schedular on the AS400?

    Jaymz69765 pointsBadges:
  • Oracle Reports Builder

    Hi, i have one query plz help me on the same.... I am creating the report in oracle report builder 6i,  i made every thing but i stuck on one problem. it is i used group by command in sql query. i got the total of one column. but in that column there are no. of same customer name in a month which...

    Ss66015 pointsBadges:
  • Novell GroupWise: WPHOST.DB

    when is the WPHOST.db file created.How do we create a Post Office.Do we do it in the same manner as we create a domain.

    PCVITA15 pointsBadges:
  • Graphic card in SCO Unix

    we have sco unix 5.04 and teleperm xp software of siemens company installed on it.when i installed a new graphic card the om screen (graphical screen )can not initialized and screen is black.what i must do .there are some script of om software.the previous graphic card was 16 color and current...

    Mostafanabavi20 pointsBadges:
  • The future of PHP

    Big companies are not working in php. so what is the future of php?

    Sudiprai1010 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.