Todd Van Valkenburg Posted March 29, 2021 Share Posted March 29, 2021 I was experimenting with the InfoAssist subquery. My thought is that I could create some permanent reusable hold files that could either be rebuilt periodically or saved as SQL. The subquery could be used to either include or not include records based on a match. There are other ways of handling this like using DB_LOOKUP and/or table joins but I wanted to get to know the subquery and how it worked. I see that it generates the DB_INFILE function in the WHERE statement. I keep getting an error when I use my previously created binary hold file in a new report by creating a subquery. The error that I see is: I recreated this using a simple example with the CAR table. The hold table created by TABLE FILE ibisamp/car BY CAR.SPECS.MPG AS (mpg_target, CAR.SPECS.MPG, mpg_target ) WHERE CAR.SPECS.MPG EQ 18; ON TABLE HOLD AS ibisamp/mpg_hold2 FORMAT BINARY Then I go about creating a new report with CAR as the source. I will only include records where mpg is 18 using this hold file. I create a WHERE subquery filter. At which point I get the error message. So, I guess I am missing something. When I look at the code source, it does not even have the DB_INFILE so it must error out before saving this subquery. So any pointers with using the InfoAssist subquery Thanks! Todd Link to comment Share on other sites More sharing options...
Todd Van Valkenburg Posted April 1, 2021 Author Share Posted April 1, 2021 Opened a case with ibi and initial response is that this may be a bug. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now