• Question on Database Development Options

    Our organization is going to build a database program where there will be millions of entries. Data entry will be done from around the country. The central server will be located in the capital city. Presently we use Windows OS, planning to migrate to Linux OS in next 4-5 years. I'd like to know...

    Abdurrahman40815 pointsBadges:
  • Crystal Reports using SQL to create inner join

    I am new to Crsytal Reports. I want to join 2 tables using a formula, which I am trying to do in SQL. I created a simple test report and I can get it to work if I don't put any fields on the report from the joined table.  ie  -  if I just use fields from "sal-rep" the report works.  As soon as...

    Sparis5 pointsBadges:
  • Win a free Microsoft SQL Server 2012 Pocket Consultant book!

    Interested in managing server groups and server activity?  Enter for your chance to win a brand new 2012 Microsoft SQL Server Pocket Consultant book Microsoft expert William R. Stanek.  To win, e-mail Michael@ITKnowledgeExchange.com explaining your security priorities for 2012. Good Luck!

    Michael Tidmarsh29,700 pointsBadges:
  • REGULAR EXPRESSIONS / META CHARACTERS REGEXP_INSTR

    I'm a bit confused here. Looking at the Student Guide from the Intro to Oracle 10g SQL class, on page 8-6 (volume II) it states that the ^ represents "Beginning of Line Anchor" then four pages further on 8-10 it states that the ^ inidcates NOT. Can anyone explain? This is the first time I'm seeing...

    Midolci0 pointsBadges:
  • SQL How to split out the Time from a DateTime col then use that in a WHERE Clause

    Hi, I have an SQL Server database that has a table containing 3 fields that I need to query. 1 field holds the date, and the other 2 hold the start and end times. What I was hoping to do was to split out the time only from the Start and End time fields and then use these times in the WHERE clause...

    Darraca290 pointsBadges:
  • Exporting a (.csv) file from SQL 2005

    Hi, I'm trying to export date to a (.csv) file from SQL 2005 and I keep getting a carriage return and line feed after each record. I have been told that this may be because it is getting exported in Unicode rather than ASCII. I do not have reporting services on my box. I have heard that there is a...

    Jeager6640 pointsBadges:
  • 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 Tidmarsh29,700 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:
  • Duplicate object (PF) using SQL with same attributes

    I want to create a duplicate object using SQL. I don't want to use CRTDUPOBJ and also do not want to compile my rpg's pgm because of new file level identifier. Please advice

    Anwer5 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:

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