• SQL query: Get result from row3 and row6 only sometime row1 and 10 only

    PRIMARY KEY (A/C. NO.) ALSO EXISTS IN TABLE2 AND TABLE 3 TABLE1 TABLE2 TABLE3 TABLE3 a/c. no. Consum demand dues 65138546 2500 193 193 65138546 3100 696 696 65138546 3500 700 700 65138546 4000 763 763 65138546 6000 867 867 65138546 7000 1125 1888 65138546 8000 1281 1281 65138546 9000 1594 1594...

    235235235275 pointsBadges:
  • AS/400 Embedded SQL, RPGLE free format, compilation

    1. My Problem: I am not able to compile a RPGLE free format PGM with embedded SQL. 2. My simple basic code: exec sql select RAGNA from RPFAGE ; *inlr = *on ;  (RPGAGE is the PF name and RAGNA is one of the fields in PF RPGAGE PF contains 100 records) 3, Member type is SQLRPGLE 4. Compile command:...

    anandx605 pointsBadges:
  • select SQL where data contains a hex value

    I have a file/table with 3 fields. The first field is a batch #, the second field is a record #, and the third field contains data. I need to select from the third field where it contains a hex value of X'0A' which doesn't relate to any character on the keyboard. Can someone show me how to do a...

    Carolh0 pointsBadges:
  • How to monitor external ODBC connection(s) for failures and reasons for same

    I am trying to monitor ODBC connections from our website to the iSeries 8 server and find reasons for any failures. Can't seem to find a method.

    randy95975 pointsBadges:
  • Install FoxPro 2.6 on Windows XP

    How do I install FoxPro2.6 window base on Windows XP service 3?

    Jayashah5 pointsBadges:
  • Make EXE file in Visual FoxPro

    How do I create EXE file in Visual FoxPro?

    mukesh18125 pointsBadges:
  • How to become a project manger in the IT industry

    I am a Technical Architect holding 17+ years of experience in IT industry. I wanted to take a diversion in my carrier to become a Project Manager in IT industry. But I am not sure of the process. Can anyone please guide me on this?

    raihanamustaffa25 pointsBadges:
  • What coolest use of APIs you ever did?

    For IBM APIs - what's the coolest use you have ever used it for?

    rajat01170 pointsBadges:
  • Stop Apache and MySQL from automatically starting up in Ubuntu

    For Ubuntu, I don't need Apache and MySQL to run automatically when I startup. When I boot up, they automatically startup. How can I stop this from happening?:

    ITKE1,055,910 pointsBadges:
  • Cannot sign into Yahoo app

    I changed my password. Now I can't sign in in the Yahoo app.

    dazy59625 pointsBadges:
  • Test two applications to exchange of money is it called SIT??

    If there are two applications, one is any shopping app and other one is any payment gateway..if we test both to exchange of money is it called SIT??

    Satinder2706905 pointsBadges:
  • Download speed is extremely slow on computer

    So, it all started when after a 2 months worth of not using my computer (that I built my self) I come back and start playing video games again. I notice that my download speed is extremely slow compared to what I used to get. I have tried everything to fix this problem. At first I thought it was my...

    Tjqueen265 pointsBadges:
  • SQL job keeps failing: Access to the path is denied

    I'm not too experienced with SQL so please let me. I have a SQL job that keeps failing. Here's the error message: Access to the path /d$.... is denied. Would this be network related at all? I have it setup so it's going from one server to another server. Any help would be great. Thank you very much.

    ITKE1,055,910 pointsBadges:
  • Scrolling Popup window by search in FoxPro 2.6

    I have a customer Master with Code & Name Fields. While entering data through Input screen I will type customer name and the program will go on filtering the name of the customer from the Master Data File and when I press Enter Key it will select the exact record from the master with Code. If...

    CNE10 pointsBadges:
  • Setting up a project management office

    What have your successes been setting up Project Management Office? Can anyone give tips or suggestions?

    wwhite5 pointsBadges:
  • How to find the Server name on my iPad

    How do I find my server name? In order to sign up to Yahoo on my new iPad they ask for "Server".

    linklaterk5 pointsBadges:
  • How to enter alphanumeric characters for my name

    I am of african origin,the computer keep asking for alphanumeric for my name. Please assist in doing this.

    namvula15 pointsBadges:
  • Does Cloudwatch have Cloudtrail included?

    Does Cloudwatch offer what you stated in your article and make all that Cloudtrail offers in the same place?

    JillCF5 pointsBadges:
  • Using SUBSTR with interactive SQL

    I am trying to change part of a field using the substring command in interactive SQL. To do this I entered the following: UPDATE LIBRARY/FILE_NAME SET SUBSTR(FIELD_NAME1,194,4) = 'XXXXX' WHERE FIELD_NAME2 = 99999 I get the error token ( was not valid. Valid tokens: = .' Obviously there is a syntax...

    GHENDER220 pointsBadges:
  • Retrieve AS/400 user profile list

    How do I code SQL to retrieve user profiles that have not signed on in 60 days?

    KatieEnglish5 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