Database Tag Directory

Browse Alphabetically:

Featured Database Questions

  • Script to extract files information from FTP server

    Hi Wonder if you could help me with the following please. I would like to construct a script (in any language whichever it's easiest) which when run, it will log on to a ftp server using a generic account and password, then list the files in a specific folder that begins with the string "abc". The...

    Aiko2720 pointsBadges:
  • Zipping CSV to AS/400

    Hi I have one doubt in zipping the CSV files. I'm keeping the daily running reports in My IFS called ABC folder. wrklnk ABC. This folder contains 10 CSV files with date extension. Now I want to zip all this CSV files and FTP to another system. How to do this in AS/400? Please help me out in solving...

    iiiiiiiiiiiii335 pointsBadges:
  • Collect random data from PHP web form

    I need to collect data to compliment a voting PHP web form when it is filled in. Firstly, the data is sent to a CSV storage folder on the server and assigned its appropriate heading.[name, address, category etc] The file is downloaded weekly. The data is manually copied and pasted into its own...

    iainroome5 pointsBadges:
  • How do you load a CSV file into Oracle?

    How do I load a .CSV file into Oracle?

    Dolly275 pointsBadges:
  • Corrupted database file with Memo Field in FoxPro 2.6

    I am using a software in FoxPRO 2.6. I had a problem that a database file with memo field has been corrupted. I have used foxbase for repairing but that file is not opening I have erased cdx file bofore using but that file still not openig kindly solve this problem.

    Asifarp5 pointsBadges:
  • How to implement crosstab query in Access?

    How to implement crosstab query

    Shamu75 pointsBadges:
  • Crosstab query in SQL

    How to make crosstab in my sql?

    Tafz085 pointsBadges:
  • Corrupt File on Windows Server 2003

    Hello All, I just got this error on my Windows 2003 Server "the file or directory C:WINDOWSDebugUserModeChkAcc.log is corrupt and unnreadable. Please run the Chkdsk utility". What do I do? Thanks All... Rgds, Jennifer.

    Jjjjjjjj95 pointsBadges:
  • What is difference between Clustered Index and Non-Cluster Index?

    What is difference between cluster index and non cluster index?

    Amin4rmOvexTechnology250 pointsBadges:
  • Hibernate with clob type

    I am using clob of oracle 10 g in hibernate. When I tried to insert 5000lines of HTML code to the variable in Java, I'm getting the following error; Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.citi.gicap.bpm.ver.domain.Notes];...

    Arunpmk5 pointsBadges:
  • Case Statements SQL

    I'm running a query that returns a specific status code. However, within my query that specific status doesn't always exist and I get a null value. I would like to return another status when that is the case. I can't seem to get the case statement to work.

    Wilso01115 pointsBadges:
  • Cloning my dual boot Ubuntu/Mac PC to another

    HI, I have some computers which dual boots Ubuntu and Mac. I need to do the same in around 20 PCs again! How can I do using less resources and time? (All PCs are of the same configuration). All computers can be connected via LAN. I think Norton Ghost is not a solution.

    Jibin405 pointsBadges:
  • How can I change the collation name of a specific database?

    How can I change the collation name of a specific database?

    Nooshka5 pointsBadges:
  • How to extract a query to a CSV formatted file using SQL Plus

    I'm trying to extract several queries to a CSV output format. The only problem is that I can't use SQL Client or Oracle. I need to use SQL Plus. How can I do it?

    ITKE352,580 pointsBadges:
  • How to create a virtual shared disk on for a cluster setup?

    How to create a virtual shared disk on for a cluster setup? This question is from the Microsoft Virtualization Chat held on August 27th.

    ITKE352,580 pointsBadges:
  • Create .csv file on IFS folder in AS/400

    Please help to create .csv file in as/400 (V4R3). Please provide me the steps to create .csv file on IFS path on AS/400.(V4R3).

    Samule400160 pointsBadges:
  • Do you have any idea approximately when MS & Marathon will have the capability of clustering completed?

    Do you have any idea approximately when MS & Marathon will have the capability of clustering completed? This question is from the Microsoft Virtualization Chat held on August 27th.

    ITKE352,580 pointsBadges:
  • Help on Bulk insert and xp_cmdshell rename

    Hi, I have a csv with only one field with multiple rows, when i am using bulk insert to insert into sql server table, all the rows are inserted in to single column instead of multiple rows. I don't have a delimiter. csv file: (First row is blank) apple bat cat doll when I used the below command:...

    GIG240 pointsBadges:
  • How do I duplicate or clone a dying SATA drive?

    If a sata drive is dying what is the best method to duplicate or clone it without risking the data? Is this the same for ide or scsi drives? If not please list the best methods for these as well across any platform.

    ITKE352,580 pointsBadges:
  • Catching an uncaptured error in SQL

    This is a batch of SQL code I’ve been using: BEGIN TRY begin BULK INSERT DBXMRPAS2.dbo.[STG_drive] FROM '\Wdmyitpxmdev1xmmsbcpcsvfile20080715drive.200807151100.extracting' WITH ( MAXERRORS =1000, FIELDTERMINATOR = '^', ROWTERMINATOR = '|n' ) end END TRY BEGIN CATCH SELECT 'Error Caught' SELECT...

    SQL Server Ask the Experts2,585 pointsBadges:

Browse Alphabetically:

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