vvDTA900.VVSTMT doesn't include Where clause

[llarge]

Hello,
I was checking for some fields used in my datasources and have always run queries against vvdta. today I ran this statement.

select * from space6d10.vvdta900
where upper(vvstmt) like '%STATUSCODE%'

I noticed that 1 data source I was expecting to see did not show up. After further investigation, I noticed that the where clause of the SQL statement in my datasource is not in VVSTMT. I was expecting it to have the whole statement you would see in NAB. Is there somewhere I need to look to join vvdta900 to get the rest of the statement?
Am I missing something or is this normal?

[sean.lanktree]

Yes, also check VVDTA905.

[llarge]

That was it. Thanks.
Is there a way to query the DB to get all the vvIDs that an app uses?

[sean.lanktree]

Table VVQRY300 should give you what you need. VVID would be your app id with a VVIDTYPE of "A" (for app).

It will have one to many records for every object it uses. VVOBJID will contain the object id and VVOBJID will contain the type:

• "W" = widget
• "D" = data source
• "A" = app (calls another app)