Please be clear a.Give an example of what youR RESULT should look like and what is your input
View Answer | October 9, 2007 7:11 PM
Parsing, PL/SQL, SQL
If your encryption padds the encrypted value with filler data then yes, the join could fail as the values wouldn’t match. If you aren’t padding the encrypted value then your values should match and you should be able to do the join.
View Answer | October 5, 2007 8:26 PM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server, Web site design & management
You would either need to setup a new server running SQL 2005, or install a SQL 2005 instance leaving the SQL 2000 instance. Then detach the databases from the SQL 2000 instance and attach them to the SQL 2005 instance. Be sure to do full testing to make sure that there won’t be any issues [...]
View Answer | October 5, 2007 8:18 PM
Access, Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
Gforsythe | Sep 30 2007 8:36PM GMT Whenever I have to reload a dell, I always have to go to Dell and download the driver package for that Dell device and install the NIC drivers. Since your wireless is working, if you have internet access over that connection, your golden!
View Answer | October 1, 2007 1:28 PM
D510, Dell, Latituded, NIC, Problems
Bacially it is when you create a database and organize it into tables to get consistent results. You can see the <a href=”http://searchsqlserver.techtarget.com/sDefinition/0,,sid87_gci212669,00.html”>Whatis.com definition here</a>
View Answer | September 19, 2007 4:23 PM
ChrisGee, You may want to consider using the Oracle Label Security and Virtual Private Database features with a single database for training. Here is a link to more info: http://download-west.oracle.com/docs/cd/B10501_01/network.920/a96578/intro.htm#1008265 Hope this helps. Charles
View Answer | July 19, 2007 10:17 AM
Hi Colleen. I’m President of GLUGnet.org, the Lansing MI area user group for .Net. We have over 350 developers on our email list that covers essentially the entire central Michigan area. Since the Michigan economy is struggling and jobs are tight, you should get a strong response to a posting at our job website, jobcoin.glugnet.org. [...]
View Answer | July 12, 2007 10:57 PM
Application development, Business Objects, Business/IT alignment, C, Career development, Certifications, Cognos, Computer Associates, Crystal Reports, Data Junction, Data mining/analysis, Data warehousing applications, Database, DB2, Deltek Systems, Desktops, Development, Distribution/logistics applications, Enterprise Desktop, Financial services applications, IBM, Linux, Management, Microsoft Windows, MySQL, Oracle, OS, PeopleSoft, SAP, SAS Institute, Security, Servers, Software Quality Assurance, Software testing, SPSS, SQL, SQL Server, SS&C Technologies, SunGard Data Systems, Systems Union Group, Training, Transaction Systems Architects, VBScript, Vendors, Visual Basic, Web development, Web development tools
The best way to fix this is to load this data into a database (access or other) that all your users can see. Because you can open file: You could dump the info into flat flies and then load these flat flies into the database that all users can access. Drew
View Answer | July 2, 2007 11:00 AM
Database, DB2, Oracle
select a.studentno, (sum(decode(a.presence_k,’P',1,0))/count(a.presence_k))*100 as PercentAttd from attendence a where a.subject_k = ‘AC’ group by a.studentno having (sum(decode(a.presence_k,’P',1,0))/count(a.presence_k))*100 < 75
View Answer | June 23, 2007 7:40 AM
are you looking for an SQL statement to embed in RPG? COBOL? JAVA? or for some other SQL based interface?
View Answer | May 22, 2007 8:28 AM
Data analysis, Data warehousing applications, Database, DB2, DB2 Universal Database, Development, Oracle, PC/Windows Connectivity, SQL
What exactly are you trying to validate? We do quite a bit of bulk email to student populations, and “a high percentage of blounced emails” is a relative term. It may very well be that your experience with this population is typical/expected.
View Answer | May 21, 2007 3:54 PM
AS/400, CRM, Database, DB2, E-business, Ecommerce applications, Email, Exchange, Oracle, Web services
Yes, the size of certain files DOES drive the optimizer’s plan. You can weigh in on the plan as follows (code shown is fully optimized): SELECT /*+ INDEX(a) INDEX(b) INDEX(c) */ ______99, ______31, ______b.school_id, ______a.provider_id, ______a.student_id, ______’2007′, ______’01′, ______’0′ ___FROM studprovider a, ______student b, ______school c ___WHERE a.student_id=b.student_id AND ______b.school_id=c.school_id AND ______a.provider_id=527 AND ______b.t_districtid=31 AND [...]
View Answer | May 15, 2007 3:17 PM
Oracle, Oracle 10g, SQL
Old Oracle syntax: SELECT s.name, ______DECODE(lm.name, _____________NULL, ‘The first hop failed’, ___________________DECODE(L.name, __________________________NULL, ‘Second hop failed’, ________________________________’Success’)) status ___FROM Source s, ______LookupMap lm, ______Lookup L ___WHERE s.name=lm.name(+) AND ______lm.lookupName=L.lookupName(+); New Oracle ANSI syntax: SELECT s.name, ______CASE _________WHEN L.name IS NOT NULL THEN ‘Success’ _________WHEN lm.name IS NOT NULL THEN ‘Second hop failed’ _________ELSE ‘First hop [...]
View Answer | May 10, 2007 1:56 AM
Database, DB2, Oracle
Are you specifying the correct port number for the http server? To find out the correct port or the exact url you are supposed to input, check in the setupinfo.txt file in the C:oracleora92ApacheApache directory.
View Answer | May 7, 2007 5:02 AM
best is to create a link betwwen c: and S: Is db in archivelogmode? Was db in restricted mode? Did you enter the recovery command ie “recover database;” to actually recover. Initsid.ora locations need changing. Hard to diagnose further. Keep me in the loop please.
View Answer | April 10, 2007 3:29 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML
Most important, do you have an index on transaction that consists of item, version and lasttran? You need lasttran included to make the index work. I think that’s the problem. What may be beneficial is to create a work file containing the last transaction of each item in the warehouse. Then create an index on [...]
View Answer | April 3, 2007 12:56 PM
Application development, AS/400, Database, DB2, DB2 Universal Database, Oracle, SQL
There is a company called Linker IT Software that has a product call SQL*XL that links Excel to an Oracle database. It allows you to pull result sets from the database directly into Excel Here’s the link: http://www.oraxcel.com/projects/sqlxl/index.htm
View Answer | March 19, 2007 12:28 PM
Oracle, Oracle administration, Windows
In DB2 or Oracle, use: UPDATE xref a ___SET id1 = ( ______SELECT b.id2 ______FROM xref b ______WHERE b.projId=’AWPE’ AND _________a.id1=b.id1) ___WHERE projId=’MONDPL’; In MS SQL Server, add AS after xref. — Sheldon Linker (firstname.lastname@example.org) Linker Systems, Inc. (www.linker.com) 800-315-1174 (+1-949-552-1904)
View Answer | March 1, 2007 4:52 PM
Data analysis, Database, DB2, Oracle, SQL
Lotus Notes viewa are not same as table structures but you can make them similar to tables. Views are not RBBMS compliant. but these viewa can be exported to tables using odbc connection or Decs or LEI etc..
View Answer | February 23, 2007 12:12 AM
Architecture/Design, Availability, Database, DB2, Desktops, Development, Installation, Management, Microsoft Windows, Oracle, Oracle administration, OS, Security, Servers, Software testing, SQL, SQL Server
Without seeing your SQL code, my guess is that you’re storing 16-bit characters into an 8-bit field. — Sheldon Linker (email@example.com) Linker Systems, Inc. (www.linkersystems.com) 800-315-1174 (+1-949-552-1904)
View Answer | February 13, 2007 2:52 AM