• AS/400 – iSeries SQL Update of on table with values from another joined table

    I've use an SQL utility on the AS/400 call SEQUEL by ASC, that allows updating of values in one table from values in another joined table. The syntax is something like this: update set((a.fld1=b.fld1)(a.fld2=b.fld2)) from file1 a join file2 b on a.key1=b.key1 where a.key1='OnlyTheOneIWant'I no...

    Mark90990 pointsBadges:
  • Configuring Cisco Wireless Router

    Greetings, I have a Cisco 871 wireless router and am having problems configuring it to act as a Wireless Access Point for my small internal network using Microsoft Small Business Server 2003. I am trying to set up one client access via wireless. Using Cisco’s SDM Express, when trying to change...

    RP@ADF15 pointsBadges:
  • Applying an ACL in Packet Tracer for class

    I'm having a problem figuring out how to configure the following:Allow hosts on the 192.168.30.0/24 network web access to any destination Allow hosts on the 192.168.30.0/24 network ICMP access to any destination. Explicitly deny any other access origination from the network.Now the they say...

    MRLS71815 pointsBadges:
  • Find and replace text in text file using MS Access VBA

    Hi I need to modify some tags of an XML file that I receive. How can I search the file for specific text and replace it? Here is the code I have right now. It runs without errors but does not replace the text.Function ReplaceTextInFile() Dim sSearchText As String Dim sReplaceText As String Dim...

    Vgnadeau15 pointsBadges:
  • Schedule SQL job to run and export to CSV file

    Hi. I am trying to create a SQL job to run every hour and export results to a CSV file. I have created the job and scheduled it but can not figure out how to have it create the CSV file. Thanks!

    Sesa5 pointsBadges:
  • Database connectivity ASP.NET using C#

    Hi, I'm new in ASP.NET so excuse me if this is a stupid question. I'm trying to connect a page to the database but there may be some problem. Please help me...... This the ASPEX file cod: using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using...

    Fabregas5 pointsBadges:
  • ITKE Discussion tool bar

    It's been a few weeks since I had the discussion tool bar. ITKE development can not replicate the problem. Did you experience this problem? How did you resolve it? Thanks Phil 5/7/13 .. added tags that have nothing to do with this task but might get some attention

    philpl1jb49,720 pointsBadges:
  • Upgrade from Access 97 to Access 2010

    Hi All, I have a client requirement to upgrade our existing application which is developed on Access 97 and running on Win Xp to Access 2010 Win 7. The Access 97 database has file like .MDB, .MDE and .MDW. Can someone, please suggest a way to upgrade form Access 97 to Access 2010. This application...

    mercuryspark10 pointsBadges:
  • MS Access 2010 database – contracts and provisions

    Is this possible - legal dept of about 100 people; need database to track perhaps top 250 customer contracts (basic contract info - names/term/type/ID; then need to track how each contract treats certain provisions (affiliates, assignment, insurance, etc). We have standard provisions and can put...

    LegalData5 pointsBadges:
  • Defaults the Physical file with ‘%’ for Character fields and -9999 for Numeric fields.

    Hi all, I have requirements in which I have to pass the file as parameter to another program with defaulting the field value as, If character field default the first character as '%' and if Numeric default till the length of the field with -9999. As per now I'm getting two options. 1. Create the...

    ddaswani170 pointsBadges:
  • I want to assemble a workstation and I don’t know which correct board to use

    I have this task of assembling a workstation, and I have been thinking of what model of system motherboard to use, and what Intel processor type to use and the type of media card to use The workstation is going to be used to hold large amount of data, and stores some high resolution media contents...

    dixton20105 pointsBadges:
  • Crystal Reports 9

    Hi, I'm using Crystal Reports 9 version and in the database expert, it is not displaying all the schemas of the DB2 database connected. Only fewer are displayed. I'm unable to query it even after I have verified all the options such as tables, views etc in the "Options". But none of them have...

    code4565 pointsBadges:
  • SQL update command to update certain digits in a row of a column with VARCHAR2(9) DATATYPE.

    Please I need an SQL command that I can use to update only the fourth and fifth digits in a particular column in an Oracle 9i database.The column has a VARCHAR2(9) datatype. My Oracle database is on Windows 2003 environment. Eg: The row in question reads '063150987' and I want to replace the fourth...

    IdongesitDaniel5 pointsBadges:
  • Difference between ODBC and JDBC?

    I'm writing a Java application. In short, this application needs to connect to DB2 on an AS/400 for some SQL data. I cannot find a straightforward comparison of ODBC and JDBC. Do any of you know where I can find one? Or, have any of you done java programming with the intent to connect to AS/400 SQL...

    Schmidtw11,330 pointsBadges:
  • Count distinct rows on multiple columns

    I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00...

    Mjackson0 pointsBadges:
  • BULK COLLECT and FORALL in PL/SQL

    How do I update multiple columns in a table using the BULK COLLECT... FORALL methods in PL/SQL.

    RangjungDorje20 pointsBadges:
  • Multiple subnets on one physical network

    I am setting up a fairly large wireless network. We have a fibre connection to the internet for a small community wireless project to give high speed to the 10-20 houses in the area. The router device is a windows PC running with two NIC cards, it is hardened down to very minimal services, with...

    Johnshoff60 pointsBadges:
  • I want to select months from Jan to Dec using SQL query

    I want to select months from January to December using SQL query. I will use this for list item note:- without using PL/SQL and less union.

    44063860 pointsBadges:
  • DB2 Date function to convert number to Date

    In Cognos-Framework Manager there is a calculation in the DB2 section called "Date". Supposedly this field will change a numeric date "01012005" to an actual date "01/01/2005". But, we tried it and it does not work. Can you see if you can find anything that will allow us to create a calculated...

    Meenac0 pointsBadges:
  • I am getting ORA-01422: Exact fetch returns more than requested number of rows

    Hi experts, I am getting this error when I run my test case for my PL/SQL procedure, which has select and insert statements only. Not clear where I would have went wrong, Please guide me where should I check exactly. Its popping up with this error message which i caught in a exception piece after...

    Inprise610 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