1
  • Select Query in iSeries is running very slow

    I'm writing a query to pull different sets of data from a single table.  I tried the following SELECT query using Data Transfer in iSeries: SELECT INFOR.PFAC , INFOR.PPAR FROM MAINSYSTEM.INFOR INFOR WHERE ppar = '240XXX2A' It takes upwards of 4 minutes for the query to return the data I need. Here...

    ITKE54,755 pointsBadges:
  • Filtering a select based on the value of one column and the max value of another column

    I've created a temp table and need to further select some data from it. Seems simple. The temp table contains thousands of orders, an action code (C or D)and a seq_ID for each order. Each order has multiple instances of the C and D action codes, but I only want a list of those where the value for...

    CO Bill120 pointsBadges:
  • SQL select loop list?

    Say I want to derive the following: Select ID, F1 from table Union Select ID, F2 from table Union Select ID, F3 from table Union … etc until F10. Is there smart and easy way so that I can just provide a list: F1,F2,F3,…,F10 and somehow be able to have the select statement loop through it? Also,...

    Vinical5 pointsBadges:
  • Forced Date Routine Processing

    I’m trying to process a RUNDATE = 2009-08-07 into my COBOL code via a PARM-DATE Link. That date comes in… now I try to place it in the following piece of code: EXEC SQL SET :WS-PREV-WK = CHAR(DATE(TMP-DATE)- 7 DAYS) END-EXEC. What am I getting '0001-01-01' returned?

    A30TPX5 pointsBadges:
1

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