ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Host structure array not defined or not usable.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Host structure array not defined or not usable.

    d RSUPRCDS e ds dim(32767)
    extname(RSUPFILP)
    qualified


    Hi guys iam getting the following error when trying to fetch


    Position 62 Host structure array RSUPRCDS not defined or
    not usable.

    Please find the code

    PHP Code:
    select count(*) into :w_count  from rsupfilp;               
     
    exec sql                                                   
     fetch  from rsupcsr1  
    for :w_count rows  into :RSUPRCDS

  • #2
    Re: Host structure array not defined or not usable.

    What are you trying to do? Your making my head hurt.
    Hunting down the future ms. Ex DeadManWalks. *certain restrictions apply

    Comment


    • #3
      Re: Host structure array not defined or not usable.

      Originally posted by DeadManWalks View Post
      What are you trying to do? Your making my head hurt.
      Sorry for the headache.I want to eliminate fetch from my do loop to reduce the file access multiple times.

      I want to load all the records in one shot using a single fetch then use a counter to work upon them in a do loop.

      Comment


      • #4
        Re: Host structure array not defined or not usable.

        Reduce the size of your array by 1 - 32766....

        I believe you do that it will work for you. If I specify 32766 it works - 32767 I get the same message as you.

        Comment

        Working...
        X