• Execute SQL SELECT via RUNSQLSTM error

    Trying to execute SQL-statement "SELECT * FROM mylib/myfile" give errormsg SQL9010. Some say that SELECT is not supported with RUNSQLSTM, but IBM command parameter text indicates otherwise. Is SELECT supported and what am I doing wrong?

    DanTheDane2,555 pointsBadges:
  • SQL400 Strip non-numeric from a column

    Hello everyone, Is there a way to strip non-numeric characters from a char column? Example: I have a Clients file, with column "Telephone Number" (CLPhone, 20, A). The thing is, phone number for many clients is filled with different formats. Example1: (123-12345) Example2: 123 12345...

    Builder40060 pointsBadges:
  • Redundancy Misconfigured in iSeries-SAN

    Oops..new DASD from SAN was misconfigured and loosing redundancy... There are the New Multi Path connections to the SAN for one of the IsERIES server.. note that the Redundancy connections are using the Same BUS.  This unfortunately now gives us a single point of failure down to the Fiber channel...

    qmaster1,675 pointsBadges:
  • Calcing quartiles using the median

    I'm using this SQL to determine the median of a group of temperatures... select x.TEMP from QGPL/WEATHER1 x, QGPL/WEATHER1 y group by x.TEMP having sum(case when y.TEMP <= x.TEMP then 1 else 0 end)    >=(count(*)+1)/2 and sum(case when y.TEMP >= x.TEMP then 1 else 0 end)>= count(*)/2...

    tegarvey35 pointsBadges:
  • ASP – Response.Write Object

    Hi. I am using the ASP tutorial in www.w3schools.com. When i try out the following basic example it is not showing any results: <html> <body> <% response.write("My first ASP script!") %> </body> </html>   [!--response.write("My first ASP script!") --]I have tried...

    JKJK45 pointsBadges:
  • Database file in Novell GroupWise

    what is a data base file in novell groupwise.Is it associated with each novell file or there is only 1 which contains info for all other file

    PCVITA15 pointsBadges:
  • Best approach to integrating multiple solutions

    Hello everybody, I am currently working on a system where I want to integrate two open source solutions together. Each solution has its own database, user authentication and functionality. I would like these two solutions to work together. At the moment, they are completely independant and no...

    Oomta5 pointsBadges:
  • DPI settings different on user machines

    How do I fix my VB.Net application to handle different DPI settings on the users machine?

    Cevonne5 pointsBadges:
  • What is the problem with my Visual Basic reg license?

    Hi to All, I have been using the Microsoft Internet Transfer Control 6 in my software for 1 to 2 years with no issues. I’m using Visual Basic and I attached the control within the form of my program not a problem now for probably 2 years, but my system has been showing signs of register issues...

    TheFinder1,940 pointsBadges:
  • Is paying a training school worth the money to obtain certifications?

    Hi, I am currently considering enrolling in an IT training program that supplies all training and materials along with the testing for 7 certifications (A+, Security+, MCTS, MCP, MCSA, CCENT & CCNA) Everything is included in the tuition along with a new computer to do the training on. The cost is...

    RMTsot5 pointsBadges:
  • Connecting to Oracle with Visual Basic 2005?

    what are "oracle" version to connect "visual basic 2008","visual basic 2005" and "visual basic 6.0" ? whether it's possible to connect "oracle9i" and "visual basic 2005" ? please solve my Q..........

    Amarpdy8820 pointsBadges:
  • Risks in Testing?

    Can ayone tell me what are the different kinds(Internal and External)Risks while conductiong testing?

    Suman1012530 pointsBadges:
  • Career guidance query (please advise)

    Hi Everyone, I would appreciate if you could advise me, based on your experience and educated guesses, for the following questions: Background- I am pursuing MS in MIS with Enterprise Systems(SAP) as my major. I have taken courses which deal with FI/CO, MM, SD, BW. I am very much interested in...

    Aspirant0 pointsBadges:
  • Open IT Forum: What tech CEO would you vote for?

    Michael Morisy recently reported on a primary of off-ticket, independent candidates, which included Cisco CEO John Chambers. Not to get too political, but we were wondering if there were particular tech CEOs that you admired for one reason or another. Share your thoughts -- or your vote -- and...

    ITKE342,985 pointsBadges:
  • help

    class Orc { public static void main(String args[])throws Exception { BufferedReader br = new BufferedReader(new InputStreamReader(System.in)); String s = br.readLine(); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:oradsn","system","sekhar");...

    Vegisekhar35 pointsBadges:
  • COBOL conversion to Java vs .Net

    Our CIO has announced that he wants to eliminate the mainframe by the end of FY 07-08. We are in the strategic planning phase currently and are examining the options. Our current system is z890-2086 running z/OS 1.4, CICS/TS, CA-7 job scheduler, CA Top Secret etc. Our criminal justice system runs...

    BlueKnight10 pointsBadges:
  • Access a password protected URL (web application)

    Greetings! I am facing an issue (class Authenticator was not called when the url asked for an username and password). Here is my sample code. Can anyone see what I am doing wrong or post their working sample code? My scenario, I think is little different from the the article, as I am trying to...

    Mahamdevan25 pointsBadges:
  • Question on Database Development Options

    Our organization is going to build a database program where there will be millions of entries. Data entry will be done from around the country. The central server will be located in the capital city. Presently we use Windows OS, planning to migrate to Linux OS in next 4-5 years. I'd like to know...

    Abdurrahman40815 pointsBadges:
  • Query Many Tables

    I want to run a query on many tables. The answer I am asking is "How many 1s, 2s, and 3s are in all the tables together?" Each semester we get information on standards. How well a student completed a standard - a 1 is the lowest 3 is high proficiency.  The problem is this when I set up the query I...

    ManyJobs5 pointsBadges:
  • Crystal Reports using SQL to create inner join

    I am new to Crsytal Reports. I want to join 2 tables using a formula, which I am trying to do in SQL. I created a simple test report and I can get it to work if I don't put any fields on the report from the joined table.  ie  -  if I just use fields from "sal-rep" the report works.  As soon as...

    Sparis5 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