• SQL query help

    Below is a list of the query that I am working on. There are part numbers that may be match to more than one module number. What I need is to show only the part numbers for the list. These part numbers I need a list of only one part number for each group. PartNo------ Module------ Numbers...

    CompEng1,240 pointsBadges:
  • Having trouble with DB2/400 UDF returning a table.

    I've written a test RPGLE program (not a service program) to return a table that for testing puposes I'm returning 1 row and 1 hard coded return column that is defined as varchar. I'm building the return value by concatonating the input parameters. Anyhow I tried running it using interactive SQL. I...

    Dwk0015 pointsBadges:
  • About Time

    Hi Everyone, I need a PLSQL query inorder to keep track of TIME. Scenario : The Time Performed should be before the Other Time. Regards, Pet  

    Checkp310 pointsBadges:
  • Windows Server 2003

    i have a sever 2 G.B ram ,prosser Intel Xeon 3.0Ghz, i want to configare a domain controllar with using sql application server on that server i want to configare it domain along with sql application server . IS this configaration enough for both server or i needed to  improve configration ....

    Bbb845 pointsBadges:
  • MySQL database size

    Is there a limit on database size for MySQL? my database is getting on the large zise will this effect proformance?

    Worktopm5 pointsBadges:
  • 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...

    ITKE352,420 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:

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