Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

I was experimenting with the InfoAssist subquery. My though...


Todd Van Valkenburg

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...