• Can embedded SQL in a SQLRPGLE program be used as a stored procedure?

    I am successfully using (external) stored procedures with many RPGLE programs. (Some of these are SQLRPGLE programs because they return a result set.) All of this works fine. But if I try to replace some of the RPG I/O in a RPGLE program with embedded SQL, creating a SQLRPGLE program, and run it as...

    Warykat20 pointsBadges:
  • ASP getting increasing

    Hi All, One of the our production server its V5R4.3 months back only we bought this server.Perviously its working fine.But Nowadays ASP is getting increasing some times its went 55% also.we deleted some JRNRCVRs which are in SAVED status.but still its getting increasing.Any one know why its...

    MQ admin110 pointsBadges:
  • COPY data between to files with SQL in iSeries

    hi, i need help with this: i have two files in Iseries one of them is new and other have old records and i pretend with sql copy some records. But file 1(new) and file 2(old) they don't have same collums file1 file2 fielda fielda fieldb fieldb fieldc filedd fieldd how can i make the correspond...

    BUG68235 pointsBadges:
  • Meeting Minutes application in Domino-based client

    Iam making an application based on Minutes of Meeting, which are recorded after every meeting.I want to ask that my form contains two sections sayin status of last meeting and action plans after current meeting.which i need to display in a meeting related to same meeting purpose. I thought of doing...

    KBhatiaYMSLI10 pointsBadges:
  • WEB / iSeries

    Where do you foresee browser-based iSeries access applications going, with regard to development portals, user interface methodologies, etc. ?

    Tsmith7155315 pointsBadges:
  • How can I transfer an ASCII file with negative numbers to my iSeries

    I need to transfer an ASCII file that has a field that may contain negative numbers to my iSeries. I'm getting nowhere with this. Can someone tell me how I might do this?

    Rscoville15 pointsBadges:
  • Concatenating two note fields into one, but need them to be on their own line

    sort of like update table set master_note = Note1 + CRLF + Note2. result should be Note1 Note2 I cant find the syntax fir the CRLF part. Any suggestions?

    Macsterling5 pointsBadges:
  • Vehicle tracking software with J2ME

    can i code vehicle Tracking software using J2ME

    999559534735 pointsBadges:
  • Reporting Services 2000: Deployed results different from preview in Visual Studio

    I have 1 main report that contains lists. In each list are many subreports. The subreports are called multiple times based on the grouping in the list Problem: There is one particular subreports that shows the zero amount after deployment. However, the results are accurate when viewed in Visual...

    Droozy15 pointsBadges:
  • DateTimePicker set Time boundary

    I have a datetimepicker control which is set to display time in hh:mm format. The format property is set to custom and the ShowUpDown setting to True. Is there any way I can set the lower limit of time in the control to 8:00 AM from 5:00 PM? Any suggestions will be great appreciated. Thanks.

    Cus1295 pointsBadges:
  • Sending a print job to two separate printers using VB 6

    I have prepared a Restaurant Software in VB 6.0 and Access 2001. I have to print a prepaid bill in two copies (one for customer and another for kitchen). One epson lq 300+ printer is attached in LPT1: port and another in USB001:port. I printed the Bill through LPT1: port and I could not print...

    Jsss5 pointsBadges:
  • stored procedure component

    what is the difference between the way of using storedprocedure component in delphi5 and delphi7?

    VPL100 pointsBadges:
  • How do I configure my PC as a Web Server?

    I have a Domain name registered. Now i want to put some web pages under it. Further i want to use my PC as Web server. How can i do this ? Need some help from you experts. Waiting for reply.

    Kelp115 pointsBadges:
  • What should our next contest be on ITKnowledgeExchange.com?

    We want to kick off the new year with an exciting contest and want your input. We have done a variety of contests from the top 3 Knowledge Point earners winning prizes like an XBOX 360. Also we have had Amazon.com gift cards for the top 10 point earners who achieve over 500 Knowledge Points. I want...

    ITKE828,060 pointsBadges:
  • SpinButton linking to an occupied cell

    Can a spin button be linked to the cell that it is located in? I have about 100 spin buttons that I need in this sheet and don't want to individually link each one! Thanks!

    Sleibbra245 pointsBadges:
  • Find Next SQL AutoNumber

    Hi, I was wondering if there is a way to find the next autonumber in a SQL table before inserting the record? I tried just looking at the previous number and adding one but if I delete the last record then this wouldn't work or if I delete all the records then the number won't be 1. Any suggestions...

    RoadDust390 pointsBadges:
  • DB2 SQL Confusion

    I am failing to understand why the following won't work SELECT m.index, SUM(d1.amt), SUM(d2.amt) FROM master m, detail d1, detail d2 WHERE m.index = d1.index AND m.index = d2.index AND d2.qalif = 1 GROUP BY m.index I wrote another sql that does work, I just don't understand why I get higher values...

    ThorButtox5 pointsBadges:
  • Tricky Grouping problem!

    I am trying to migrate some Employee absence data, from one table to another. The data currently looks like: Employee, Date, Reason ------------------------ dave,01/01/08,sick1 dave,02/01/08,sick1 dave,03/01/08,sick2 dave,04/01/08,sick1 dave,05/01/08,sick1 bob,01/01/08,sick1 bob,02/01/08,sick1...

    EggBeard5 pointsBadges:
  • Relative hyperlinks to start a CD/HDD application

    I'm trying to make a game CD with a html menu from where game (converted flash games in to exe file) will start but if, I use html pictures’ of the games as buttons all will point to CD but I like to make it neutrally so I can just copy CD to each computer ore run the files from CD I'm using a...

    Webpanther5465 pointsBadges:
  • count physical files

    How can I count all the physical files on a System i?

    Vitome5 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