Results 1 to 5 of 5

Thread: alternate array

  1. #1
    Code400 Newbie viswa's Avatar
    Join Date
    Jun 2011
    Location
    chennai
    Posts
    26
    Rep Power
    0

    Post alternate array

    Hai all,

    am currently encounter a doudt in rpgle free format concept,

    how to retrieve or read a data from database file using alternate array concept in rpgle (using free format)
    for example if i have a db file with fields department code and description then read the description for
    a particular code
    depcde depdes
    IT Information technology
    AD Administration
    etc.........................
    -
    if any one knw the ans plz reply

  2. # 666
    Circuit advertisement
    Join Date
    Aug 1965
    Location
    Yakutsk, Russia
    Posts
    1,000,000
     

  3. #2
    Sr. Product Specialist FaStOnE's Avatar
    Join Date
    Nov 2005
    Location
    Phoenix, AZ
    Age
    51
    Posts
    2,611
    Rep Power
    3991

    Re: alternate array

    I guess I'm not sure where the "array" is coming from in this. Maybe I just don't understand the question...

    But, why not use SQL and select the values you need directly from the DB?

    Select DepCde, DepDes
    From (My File)
    Where DepDes = (Target Value)
    -Rick

    _____________________________

    Need a Managed File Transfer Solution -OR- iSeries Encryption?
    GoAnywhere and Crypto Complete by Linoma Software


  4. #3
    Code400 Newbie viswa's Avatar
    Join Date
    Jun 2011
    Location
    chennai
    Posts
    26
    Rep Power
    0

    Re: alternate array

    Thanks for you reply and suggestion @FaStOnE

  5. #4
    Programmer Mercury's Avatar
    Join Date
    Feb 2007
    Location
    Paris, France
    Posts
    1,831
    Rep Power
    5424

    Re: alternate array

    Look here.
    Philippe

  6. #5
    Code400 Newbie viswa's Avatar
    Join Date
    Jun 2011
    Location
    chennai
    Posts
    26
    Rep Power
    0

    Re: alternate array

    @mercury TanQ ) i seen that ppt ,, i will use it

  7. # 666
    Circuit advertisement
    Join Date
    Aug 1965
    Location
    Yakutsk, Russia
    Posts
    1,000,000
     

Facebook Comments


Similar Threads

  1. WRKDBF on V6R1 not working - Alternate utility??
    By ilikecgi in forum Tips for the Iseries/AS400
    Replies: 17
    Last Post: January 29th, 2013, 04:53 AM
  2. Replies: 1
    Last Post: January 9th, 2010, 09:37 AM
  3. Array
    By Atul Bindlish in forum RPG/RPGLE
    Replies: 1
    Last Post: July 9th, 2009, 06:05 AM
  4. Array
    By dcutaia in forum /Free format
    Replies: 3
    Last Post: November 12th, 2007, 05:54 PM
  5. RPG array look up using SQL
    By EMSS in forum SQL
    Replies: 2
    Last Post: March 15th, 2006, 12:46 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •