• Improving the initial speed of a SQL query

    I have optimized my SQL query to the maximum extent. The first time I ran the query, it took 7 seconds; the next time it took half a second. Why did this happen? How can I make the query run faster the first time around?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Retrieving data from AS/400 tables with PHP?

    I think I will die! Does anyone know how to get data from a table on AS/400 displayed with PHP through ODBC? I'm starting to go mad. I tried ODBC drivers (iSeries Access client, Client Access). Nothing helps. I have Apache server as localhost on my machine and PHP installed and that works fine. The...

    Avrelivs80 pointsBadges:
  • How to connect to an AS/400 database from a remote PHP script

    Hello. I have a requirement to use a PHP script running under Windows to access a remote DB2/400 on an iSeries. Can anyone please assist in what PHP coding would be needed, thank you! Regards Paul

    PaulTaylor15 pointsBadges:
  • backup and recovery

    details about backup and recovery and suppose i was import data from oracle database. we can export to another database(not oracle)?

    Onlyplsql5 pointsBadges:
  • MySQL syntax

    Hi, Have a table budget When I try this: MySQL: insert into budget values (’Department A’,1,2,200) Department A represents:A Department called A 1 represents: a course no from table course 2 also represents: a course no from table course. It doesn't work. Any suggestions?

    Ak1bo78150 pointsBadges:
  • Store image from a directory into Oracle database using SQL

    I have a directory containing 1000s of photos which I have to upload into Oracle 9i DB. I need to use only SQL plus for this. I want a simple material to upload all those photos.

    cmuraz5 pointsBadges:
  • Timestamp InCOBOL/400

    Can we use Timestamp in COBOL/400. If we can, how?

    Michael Tidmarsh25,335 pointsBadges:
  • Script to extract files information from FTP server

    Hi, I 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 It then find the files (no downloading) in a specific folder that begins with...

    Aiko2720 pointsBadges:
  • Firewall preventing NET USE drive mapping PC to iSeries.

    Does anybody know what ports are used when I run net use * \\servername\share PWD /User:USER ? The firewall is stopping it somewhere although ports 137, 139, 445, and 8471-8477 are open on the firewall. It eventually times out with "System error 53 has occurred - The Network Path was not Found"...

    stropley10 pointsBadges:
  • MS Access 2013

    Does anyone have VB code for add a new value to a lookup table during execution of application?

    Robertar15 pointsBadges:
  • Connect Direct File transmission

    How to confirm whether the file has fully transmitted from source system(say mainframe) to iseries. I know how to check manually using wrkoutq. Mainframe is transmitting FileA to iseries. File transmission itself will take 1 hour to complete or sometimes may take upto 2 hours. iseries job should...

    anuppdas105 pointsBadges:
  • Free IT Book: Official Cert Guide for CCNP Security SECURE 642-637

    This week's free IT book is just what you need if you're planning to take your CCNP Security SECURE 642-637 certification exam. From exam topics and quizzes to exam prep tasks and realistic exam questions, the Official Cert Guide is a must for everyone preparing or planning to prepare for this...

    MelanieYarbrough6,345 pointsBadges:
  • Joining More Than 2 Files

    What is the best way to join more than 2 files using SQLRPGLE with embedded sql?

    TJSDAD35 pointsBadges:
  • How to retrieve, add and update data manually using VB.NET 2005

    Hey guys! I'm quite new to VB.NET 2005. I need to know how to add, update and retrieve data manually using VB.NET 2005. In the software which I'm trying to implement, data is entered in text boxes and then they are updated/added into an SQL table. When retrieving the data, for example: A student is...

    Obhasha0795 pointsBadges:
  • Free IT Book: Fedora and Red Hat Enterprise Linux

    The Practical Guide to Fedora and Red Hat Enterprise Linux serves as both a tutorial and an on-the-job reference. You'll learn to use GUI-based tools, the command line, and Perl scripts, and how to set up key Internet servers. How do you win this book? Simply answer one of five questions and post...

    MelanieYarbrough6,345 pointsBadges:
  • Access 2007 database errors when using Access 2010

    I have a database built with Access 2007. Some of our customers are upgraded to Access 2010 and cannot open the database anymore. Error is "The expression On Timer you entered as the event property setting produced the following error: Object or class does not support the set of events". Anyone...

    Browntr15 pointsBadges:
  • Free IT Book: Cisco Firewalls

    Learn concepts, design and deployment for Cisco Stateful Firewall solutions with this week's free IT book. To win, simply answer one of five questions and post the link to your answer below. Windows Server 2003 user locked Windows 7 Professional permissions Offline folder issue in Windows Server...

    MelanieYarbrough6,345 pointsBadges:
  • Which is the best among DBA and CCNA for career in all aspects

    Hi all, presently I have one year of experience in the networking field. I want change my domain to DBA. Now I'm confused whether to continue with CCNA or to change to DBA. Please, can anyone suggest to me which will be the best for my career in all aspects? Please help me out

    Vedantham5 pointsBadges:
  • Created Public Folders for Excel spreadsheets

    I have created a public folder to store Excel spreadsheets that I need users to be able to access and change. I understand the permissions. My question is can more than 1 user be in the same spread sheet at one time and make individual changes. Will all changes be saved?

    Chenzo5 pointsBadges:
  • converting single user foxpro 2.6 application in to multiuser application for use on local network

    i have developed a single user application in foxpro 2.6.How can i use it as multiuser application on a local network.What commands should i use so that each workstation can acess data stored in d drive of server.

    Hemant20095 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