• Script to connect to different database connection to export data into flat file

    Script to connect to different database connection to export data into flat file. I need combine data from different connections in system i navigator. I want to create a script to do so if it is possible. I'm new to system navigator.

    SQLinavigatoruser20 pointsBadges:
  • Dbase III files exported from Access

    In Access you can export data to a dbase III, dbase IV or dbase V file. However when I do this for a dbase III file and try and open it is dbase III plus software it says it is not a dbase III plus file. How can I open the file in dbase III plus? I could append it as a CSV file but I was hoping the...

    cornisht20 pointsBadges:
  • How to execute a message in PL/SQL from SQL command prompt

    Sir, I have written a small message using PL/SQL. When I execute that query in SQL CMD prompt, I'm unable to see my output. How can I execute my output in SQL?

    kothias5 pointsBadges:
  • What are the Advantages of database system over File processing systems?

    What are the Advantages of database system over File processing systems?

    Pepito5 pointsBadges:
  • The action will reset the current code in break mode?

    I have an Access mdb format split database. There are main form and pop-up subform. When I click on ID in main form pop-up subform appearing. This subform has 2 buttons to exit form without saving (Cancel, Exit).The problem is: When I filter records in main form by a certain ID, consequently, I...

    lissaru5 pointsBadges:
  • Access client’s WordPress database

    I scanned my customer's site for vulnerability in his site and I found the WP-CONFIG backup which contains all info about the site and database username and password. So how can I access my client's database using that username and password?

    mrchat5 pointsBadges:
  • Query pulling combo list box data

    I have a basic table in (column 1) list of individuals and in (column 2) lists the state(s) that the individuals hold licenses. Column 2 is a Combo Box Value List and several individuals hold multi state licenses. I am trying to figure how to pull out the states that require continuing education....

    emclean5 pointsBadges:
  • How to do a full outer JOIN in MySQL

    I'm fairly new to MySQL but I'm wondering if I could do a full outer Join in it? Does anyone know if that's possible? Is it actually supported?

    ITKE440,470 pointsBadges:
  • IIF function

    I have 2 tables: First table: 1- name 2- position 3- nationality 4- visa No. Second table: 1- Position 2- No of visas. 3- No of used visas. 4- No of remaining visas. But I want to use IIF function when add new position in first table increases the no of used visas in the second table automatically....

    khalid1155 pointsBadges:
  • MySQL or PostgreSQL for block storage volume

    I was wondering if I could have 2 VP MySQL servers and one SQL database located on a block storage volume. Then I can mount the same volume on both servers reading and writing to a singe database so I can have two VP MySQL machines access and running one database. Thanks

    sstepky60 pointsBadges:
  • MySQL 1093 error message

    In MySQL database, I have a table that have corrupt entries. Here's the query that returns the entries: SELECT * FROM story_category WHERE category_id NOT IN ( SELECT DISTINCT category.id FROM category INNER JOIN story_category ON category_id=category.id); So, here's how I tried to delete them:...

    ITKE440,470 pointsBadges:
  • MySQL server syntax error

    I have this SQL query below: INSERT INTO user_details (username, location, key) VALUES ('Tim', 'Florida', 42) But it keeps saying I have a Syntax error - it relates to the MySQL server version for the right syntax. What should I do?

    ITKE440,470 pointsBadges:
  • How to convert Excel file to CSV

    I currently have a Microsoft Excel that has characters in different languages. I have to convert it to a CSV file. But when I'm trying to save it, those characters are destroyed (FYI - those characters aren't ASCII characters). How can I go about doing this? Should I use UTF-8?

    ITKE440,470 pointsBadges:
  • Recordset in Excel spreadsheet

    I have table of counties and one query, I want to loop through the same query that produces a separate report for each county and export each one to excel spreadsheet

    karenMcCracken20 pointsBadges:
  • is there any process to store the data of dataqueue

    is there any process to store the data of dataqueue

    Siru15 pointsBadges:
  • How to reorder MySQL auto increment primary key

    I'm using MySQL and in my table, I have an auto increment primary keys. I already deleted several rows in the middle of the table. Now, I need to reorder the keys but I'm not sure how to do it. Can someone help me?

    ITKE440,470 pointsBadges:
  • How to open .tra file in R?

    I am trying to work with a .tra file in R studio. But I'm unable to open it. Can someone tell me how to open it or suggest me a code to convert it to a csv file?

    niveditha5 pointsBadges:
  • Run SQL query with CSV format

    I'm trying to run a SQL query from my Linux command line and getting the result in a CSV format. Here's what I have so far: mysql -u uid -ppwd -D dbname << EOQ | sed -e 's/ /,/g' | tee list.csv select id, concat("\"",name,"\"") as name from students EOQ And here's my issue: The columns that...

    ITKE440,470 pointsBadges:
  • SQL error message when creating procedure containing three cursors

    I have created a procedure containing 3 cursor. It gives me the below error and when I add @delimiter ++; at start and end it gives message that "command processed" but doesn't show output. Any suggestions? [Error Code: -104, SQL State: 42601] DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601,...

    rockstar185 pointsBadges:
  • Which tool is preferable to test and evaluate the MySQL and MongoDB databases?

    I have developed a small case study online application using Hibernate that can communicate with both MySQL and MongoDB database. Now I need to test the performance of both the databases against each other by supplying a large dummy test data to the developed application on various scenarios such...

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