• Changing BCP format file collation

    Hi All, I was wondering if it was possible to change the collation of the format file created by the BCP utility from CS to CI, than import the data? The reason I ask this is I want to import the data from one column to another column using a different collation using bulk insert. Thanks.

    Db23290 pointsBadges:
  • Q+A 5 Recover Database FAIL. Get File In Use

    We are running Q+A 5 and cannot do a successful “Recover Database”. Get “FILE IN USE BY aaa, bbb, aaa, ccc, bbb, bbb, bbb” message. All users were out of Q+A. Also we had the users mentioned in message re-boot their XP PRO workstations. Please Note: UIDs repeat in the in-use message.

    CGuy5 pointsBadges:
  • SQL or VBA code to loop through two columns of data

    I have a database table with 196000 rows (product code and related product codes) and the columns are: product code link product 000507 000123 000507 000456 000507 000789 000508 123456 000508 654321 000508 879456 000508 123789 etc etc I need this data changed to: 000507 000123, 000456, A product...

    Limey5 pointsBadges:
  • How can I synchronize three instances of MySql

    I have three instances of MySQL located in Chicago, London and Hong Kong and I want to keep them sychronized. Is there a standard way to do this.

    Kcornell5 pointsBadges:
  • Accessing AS/400 DB2 physical files with Java

    Hello All, We have one JDE Word Writer program, which export the order master data in the DB2/400 Physical files. We want to access this data from our java program (reside on windows platform). I am wondering how we can do that. I got one hint that can be accessed by ODBC connection. But I am...

    GeethaNatarjan15 pointsBadges:
  • Changing Database Collation

    Hi, I am trying to change the collation of a database and the table and columns, does anyone now how to do this? Thanks.

    Db23290 pointsBadges:
  • Finding nth most recent action with SQL

    I am trying to determine the date on which a certain number of things have happened cumulatively, eg I have a varying number of buyers each month. I want to find out on what date of that month, those buyers make their 3rd purchase. My SQL doesn't seem to support TOP or ROWCOUNT so I would...

    Munona995 pointsBadges:
  • Performance Issue with an Access File Updated through an .accde file with Linked Tables

    I have an Access 2007 Database for tracking daily time for 90+/- employees located on a shared network folder. To enter tasks and time, users click a batch file, which copies a separate .accde file to their C: drive and then opens the file. This .accde file contains a Form for data entry, linked...

    EngTech5510 pointsBadges:
  • Access 2007 removing completed data

    I am working on a database where we visit a prospect 3 times and then remove the prospect for the visitation list. Is there a way to do this so that when the third visit field is entered, Access automatically removes the data or at least hides it?

    MeBrainHurts5 pointsBadges:
  • How a S/W in c# working in N/W accesses access database from other computer not having access

    hi, my project code works in network when i place my database of access in the computer which has ms-access, but wht to do when the other comp, with which i want to connect doesn't have ms-access, then how will i connect to it and run my project?

    Fairy5 pointsBadges:
  • DB2/400 field to match an Oracle VARCHAR?

    We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS field, apparently any...

    Michaelwpeak5 pointsBadges:
  • Compare a field from a file to a column from DB2

    Need to compare a field from a VSAM file to a column from a DB2 table and run through the whole file/table to find differences.

    BobBill10 pointsBadges:
  • Paragraph marks in an ASP blog page.

    My web site includes an asp created blog page that accepts a message in a form text box, sends it to an Access database then returns it to the page. It works without trouble EXCEPT when a user hits enter to go to a new paragraph. The paragraph character is sent to the database but ignored when...

    Boblafferty20 pointsBadges:
  • Execute command in SQL

    can someone tell me the error in this statement declare @cmd nvarchar(4000) declare @PatNo bigint set @PatNo=123 set @cmd= N'insert into TmpDues ( PatNo, BillDate, ReceiptNo, PayMode Amt) select ReceiptTable.PatNo,ReceiptTable.BillDate,ReceiptTable.ReceiptNO,'+ '''Cash'''+' as PayMode,CashAmount...

    Ash1235 pointsBadges:
  • Flat file to PF conversion

    Hi, can anybody tell me how to transfer the entire flat files contents to a new Physical file in regular fields format?

    ten20081,150 pointsBadges:
  • How to get delete history from schema

    How to get delete history from a schema? Application requirement is to get the username ,primary key,date for the deleted records from tables.

    Sureshborse5 pointsBadges:
  • Free Chapter – Tuning database applications for performance

    Another free chapter download is available on the IT Bookworm Blog. Written by: John Goodson and Robert A. Steward Book: The Data Access Handbook: Achieving optimal database application performance and scalability Overview: “Performance and scalability are more critical than ever in today’s...

    BrentSheets6,925 pointsBadges:
  • How to use DateDiff to calculate costs?

    Hi, In my Access bookings system you select a number of Units and a start and end booking time. I need to calculate the cost of each Unit for the booking as well as a total cost for all Units in the booking. The information is stored in two tables: a bookings table called tblHourPeriod with the...

    Dontgetit105 pointsBadges:
  • Open Access 2007 files with Windows 2000 OS

    Is there a reader that that will read .accdb files using a Windows 2000 operating system?

    Skywatcher10 pointsBadges:
  • Calculating prior Query fields

    Inside my query, is four listed fields; date, printer, and a Start and End meter for daily meter readings to keep track of printer impressions. I'm trying to receive a return value by subtracting a meter reading from the START field in a current row and the END meter in the previous row depending...

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

Thanks! We'll email you when relevant content is added and updated.