• Win a free Microsoft SQL Server 2012 Pocket Consultant book

    Enter for your chance to win a brand new 2012 Microsoft SQL Server Pocket Consultant book by William R. Stanek.  To win, answer below: What would you like to learn or improve about your SQL server skills over the next year?  Good Luck!

    Michael Tidmarsh34,905 pointsBadges:
  • Merge two companies into one network

    The company I work for has decided to merge with its Sister Company on the lower floor. While we share the same room to house our independent servers, both companies have separate physical networks. Each with their own separate File Servers & SQL servers. Allowing Company "A" employees to log into...

    PatM5 pointsBadges:
  • QAQQINI File

    What is the QAQQINI file? Does it have to be in every library? I saw someone mention ignore_derived_index and setting it to yes. My files don't even have that value. I have the file in QSYS, QUSRSYS, and one of our test libraries. Are there any other options I should worry about? Currently, any...

    Dcantwell470 pointsBadges:
  • Letting users upload pictures MYSQL Database

    What is the easiest way in DW to allow users to upload a picture to my website. I don't know much coding so ...how can it be done using the functionality of DW. I am using a MYSQL database.

    PBen5 pointsBadges:
  • SQL Server Logins

    Hi Currently using SQL server 2000 Is there a way of making SQL server logins use case sensitive passwords. for example    user = SA password = PassWord123 as it stands "SA" can login with password = password123 how can can i change it so the user cannot login with different case password. I...

    KH155 pointsBadges:
  • water billing system

    does anyone know how to make a water billing system? im currently working on it for a project for my school and im stumped. i cant seem to make my prog run properly. please help me out, just a student here.. also, can you please send me a code on how to make my program run everytime i start my...

    Trebllaw0 pointsBadges:
  • WRKDBF replacement?

    Does anyone know of a good, free alternative to WRKDBF? I've been using it for years. However we just upgraded our business software. In this new version it has ISO date fields. For those fields that are null (essentially are 0001-01-01), WRKDBF can't handle it and blows up. I'm NOT a programmer by...

    Mrnaturl145 pointsBadges:
  • DSNTEP2 output problem

    DSNTEP2 (aka SPUFI in batch) is causing problems for my extract JCL. How do you get rid of the SPUFI-like column headers from the output datafile produced by DSNTEP2? I don't have ANY experience with REXX, so an example would be appreciated. Jon

    Jonty Walker105 pointsBadges:
  • Access Oracle/Sybase/Informix from RPG

    Hi, I would like to access Oracle/Sybase/Informix directly from within an RPG program. This is something similar to ODBC but in reverse - my data source is external to the iSeries and my application and APIs, or called routines, internal in the iSeries. The access to the external database should:...

    JohnDavid5 pointsBadges:
  • IT Data Updates and Auditors

    I would like to hear how other shops deal with auditors regarding data updates made by IT staff.   We use DFU/FILMNT/SQL for occasional data fixes. We print and file a log with who and why the change was made. Then to appease the auditors, we journal pretty much everything. A report is generated...

    LetItBe260 pointsBadges:
  • InfoPath cannot connect to data source

    Hi all, I have an InfoPath form in SharePoint 2007 that has dataconnections to SQL server DBs. I have a group of users that have been using them for the past few months with no problem. The permissions on the site have not changed but users can no longer access the Data connections. They get a...

    Jaylou185 pointsBadges:
  • how to store radio button responses in MySQL

    I am creating an online test. Each item has 5 response options (radio buttons with 1-5 values, or 5-1 values depending on the question). How do I store these values in a database, to be able to score the test later?

    Vm3335 pointsBadges:
  • pl/sql fixed file creation

    I am new to the pl/sql world. I'm ok with writing out a comma delimited file but I can't figure out how to write out a file where the fields are fixed length. I could use some examples. thanks,

    Bordenatemple5 pointsBadges:
  • export xml file of new stored data into a folder through trigger in sql server!

    Hello everyone , im newbie on SQL and need to make a trigger that generate an xml file of the new data whenever an action happens ( INSERT ), i looked around and found a clause that can query an output as xml format (FOR XML )but i cant make the actual (xml)file and put it in a path , can someone...

    Rahmony10 pointsBadges:
  • Latest date SQL

    Hi I am Trying to grab only the latest date from a uniquie stock number wich has mutiple dates? All i want to show is the lastest date against the stock number. Bear in mind that theese are comming from two different tables. Any Ideas

    Rizdon15 pointsBadges:
  • How to pass array in MySQL procedure parameter

    how to pass array in mysql procedure parameter

    Guptarun5 pointsBadges:
  • select parent where more than one child

    I want to select a row from the parent table based on whether there are two or more rows in a child table. What is the best way to do that?

    Ghjazz5 pointsBadges:
  • Get your FREE ITKnowledgeExchange.com sticker

    Be proud to show off you are part of the community with your free ITKnowledgeExchange.com sticker. All you have to do is answer a question and email me your handle and address and we will get one out in the mail to you. Allow 4-6 weeks delivery. Even if you have one already get one for your...

    ITKE353,370 pointsBadges:
  • Data type for output file in DB2 SQL

    I am using DB2 SQL on the mainframe - not sure of the version - I want to write out a file and transfer it down to the PC - how do I specifiy numeric values for dollar values so that when I bring the file into Microsoft Access the numeric fields come in as numeric and not character?

    Kath95675 pointsBadges:
  • Can anyone suggest a good loan APR formula in SQL

    I am getting a rather large error with an Excel RATE function, and so am wondering if someone can suggest a SQL formula or a solution?

    Nrate5 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