• Calling External Procedure from Java Web based Application

    Below given is a procedure to access a CL Program in iSeries from a Java web based program. create procedure libxxx/proc_name LANGUAGE CL FENCED EXTERNAL NAME 'libxxx/clprogram' PARAMETER STYLE GENERAL The external CL program has other calls to Cobol programs in the same library.The procedure is in...

    TOKNOWIT0 pointsBadges:
  • Calculation of (num) 1/n (square root) using RPG

    Do any one know how to handle below formula using RPG or else method which can be implement on AS400 RPG program : The formula is (number ) 1/n 1/n = mean 1 over n square root N= certain number and with decimal digit eg. 1.21 Please send me some suggestion about this . Many thanks Beside you can...

    Vlui000 pointsBadges:
  • How to use SQL to filter columns in a spreadsheet.

    I have a query that is listed below. I need to develop a statement that would filter the month and the year as well as the Phase informaton in the access table.  __________________________________________________________________ Select INMSP300.M3OE# as "OENo", INMSP300.M3OEC as "ComprsOE",...

    CompEng1,240 pointsBadges:
  • MERGE using DECODE logic to control UPDATE

    MERGE using DECODE logic to control UPDATE The SQL below has been running extremely well for over a years in our Production application on Oracle release 10.1. We have recently upgraded to Oracle release 11.1 and this same SQL routine now takes a minimum of 4 times longer to run on 11.1 Has anyone...

    ITKE366,875 pointsBadges:
  • Page at a time subfile

    I want to code loading a single page subfile in SQLRPGLE. How do I handle the page up and page down key, posotion to in that program? thanks, NG

    Nutangujar895 pointsBadges:
  • SQL query for same phone number

    I have 3 columns phone number, users and locations I would like to see only the name and phone numbers of the users that are calling the same phone number Not quite sure how to represent this in a SQL Statement Thank you very much for your assistance

    Iamnfo5 pointsBadges:
  • STRQMQRY in batch on i5

    Can STRQMQRY be run in batch? I am getting error message: Global variable prompting is not allowed in batch mode. I am passing 2 parameters from a display screen

    TOASTY35 pointsBadges:
  • Cross reference tool

    Hello, I'm currently working in an AS400 native RPG-environment, not ILE, and I want to create a cross reference for a part of the system(about 10 libraries). I'd like to create this by myself with the common commands on our system, I can do this thru DSPPGMREF and DSPBDR, DSPFD, DSPFFD, etc... But...

    Zappaz5 pointsBadges:
  • SQL related tables

    I have 2 tables one with all my products and their accociated details and another with comments on the products. Product table 1 prodID, title, description, price Comments table 2 commID, prodID, comment I would like to export this to a single XML file, thus an XML element for each product from...

    Geeko5 pointsBadges:
  • View scheduled jobs in a data file

    When using the WRKJOBSCDE command on the AS400, you can see information regarding jobs in the scheduler. Is this information contained in a file which can be accessed for query?

    cmarsellus50 pointsBadges:
  • ms sql query problem with a case statement

    [strong]This code works: SELECT     passengers.*, passship.passship_name AS name, passship.passship_speed AS speed, passship.passship_size AS cargo, hyperjump.hops AS hops, ROUND((passengers.pass_engers * passengers.pass_price) / (hyperjump.hops * passship.passship_speed), 0) AS ptprofit...

    Rinkratt20 pointsBadges:
  • Using SQL with MS Access and the AS400.

    Each of the numbers in the column [New PART] is linked to the column [OLD PART]. The [New Part] column may have multiple rows of the same number in the same column but is it due to the association to the [OLISTd part] column, which are out dated numbers. Both the [OLISTd part] and the [new part]...

    CompEng1,240 pointsBadges:
  • Updating a View

    I have a view that's missing data and needs to be updated. I'm not sure how to update a view - any help would be greatly appreciated. The database name is: ABCD_Dbase The view that needs to be updated is: dbo.vGoLPgcfos Thanks in advance. ~DJ  

    DCDJ45 pointsBadges:
  • Convert and Expand Field through SQL/400

    I am using the AS400 platform and a novice with SQL. I have a common field in multiple files - some files define the field as numeric and some alpha. My question: Is there a way in SQL to first convert the numeric field to alpha and then expand the alpha field adding two leading zeros? If this is...

    Rjejcsb5 pointsBadges:
  • text data to packed

    i have comp-3 data in a text field. i need to extract the info and convert it back to numerics to download to a pc. i want to use sql ...

    matis75 pointsBadges:
  • Using SRCDBG with an SQLRPGLE module

    I'm trying to debug a RPGLE module created with CRTSQLRPGI. The STRDBG program returns an error message stating the program "cannot be accessed". There is no DBGVIEW option on the CRTSQLRPGI command, so even if I get the debug to work. will I see any source data? Thanks.

    Grp5 pointsBadges:
  • file user open exceptions for printer file

    i'm opening a program defined printer file in SQLRPGLE.. i get error file is already open.... if that is the case, then i'm trying to write in that file but now this gives me exception that attempting to write in closed file...   Please help

    Nutangujar895 pointsBadges:
  • Need to know the date and time a particular sql command was fired through an interactive session

    Is it possible to find the date and time a particular sql command was entered. Iam able to view the commands entered in an sql session but not able to find the date and time the commands where fired.

    JohnsonMumbai1,260 pointsBadges:
  • Can I Use Tomcate as a “Witness” Server in SQL 2005 Mirroring

    Hello i am using SQL 2005 and i have Tomcat as an Application Server i want to use Mirroring on my DB and i am looking for the way that let me make Tomcat as my Witness server [Br class="height5" />[small] [/small]

    ITKE366,875 pointsBadges:
  • SQL EXPLAIN

    How do I interpret the EXPLAIN plan of a particular SQL which has "Bytes" and "Cost(CPU%)" columns?

    ITKE366,875 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