• Need to port flat file data into AS/400 physical files

    Hi, There are some flat files in one environment (within the same AS/400) with huge data and we need to create physical files and need to port that data such that the reports being generated over those files should be same even after migration. Thanks in advance, Svanky

    svankipu625 pointsBadges:
  • Multiplying 2 fields from ASP.NET database

    How to multiply 2 fields from 2 tables from a database in ASP.NET?

    Srunaidu5 pointsBadges:
  • Admin access for Access Control Salto

    How do I gain admin access for Salto access control?

    DonnVl5 pointsBadges:
  • Which one is better to start career: Oracle DB or SAP Basis?

    Hi, this is shiva. Recently I got a job in a MNC company. I have a choice to choose domain Oracle DB or SAP Basis for 3 months training. Basically my background is Non IT. So little confusion which one to accept to start career as a beginner and better for future. I hope I will get answers as soon...

    singamsiva19935 pointsBadges:
  • Microsoft Access subform modification problem

    I have a main form with 6 tabs. I added a 7th tab and inputed a subform. However, when I rearrange the subform in design view, the edits do not show in form view. It appears I can only make changes to the subform when a I use the "Subforn in new window" button. With all my other subforms I can make...

    fjn0bu15 pointsBadges:
  • Web project setup

    I am new the Linux servers but will be using CentOS servers. I have a web application that was created in Java using a NoSQL database. This application will give users the ability to create there own drag and drop web sites. Very similar to , Web.com, wixs.com, suarespace.com and weekly.com. We...

    sstepky60 pointsBadges:
  • Pass data from Access subform to another form

    In Access - How do I select or pass data from a subform to another form? I can pass the data back to the main form, but I want to pass to the subform data to another form

    Bdbarnes5 pointsBadges:
  • 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?

    ITKE413,390 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:...

    ITKE413,390 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?

    ITKE413,390 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?

    ITKE413,390 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.

Following