• Access 2007 DB Project

    Hello, I am setting up a database for a small airline. I have an 'Aircraft_Table' with the fields:

    PhilipG5 pointsBadges:
  • Automated Query iSQL

    I am very new to SQL and only have experience running my queries though iSQL Version 10 Build 3960 where I manually type (copy & paste) my queries. I would like to schedule a specific query to run at certain hours each day and then save the results to an excel or text file. Is this possible? How?

    Loveisalluneed325 pointsBadges:
  • Can I use SQL to delete a couple record from a member of a physical file?

    I have a physical file that have multiple member and I delete a couple records from one of the member.  I'm not sure if I can use SQL to do it.  I'm using DFU to remove records now. Thanks!!

    HelenLee5 pointsBadges:
  • 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,110 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:

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